|
Home > Archive > SQL Anywhere database > May 2005 > Null value eliminated
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Null value eliminated
|
|
|
| Hi all,
Lately I've migrated my database from ASA 7 to ASA 9
I used to have a query that do a summation on a column that may contain null
values
ASA7 was returning null, but in ASA9 I'm receiving a "null value eliminated
in aggregate function" message, and no result is returned.
Any one has any idea, how to solve this issue using the ASA 9
Regards
Rabih
| |
| Chris Keating \(iAnywhere Solutions\) 2005-05-30, 7:23 am |
| That is correct ANSI behaviour and should have been reported in previous
releases. However, due to a bug some of these warnings were not making it
back to the client. As it is just a warning, you can ignore it and work with
the resultset that gets generated (assuming that the client application is
able to handle warnings correctly).
A workaround option is to set the "Suppress Fetch Warnings" in the DSN, if
using ODBC.
"Rabih" <rabih_maalouf@ipsos-stat.com> wrote in message
news:429afe3e@forums
-2-dub...
> Hi all,
>
> Lately I've migrated my database from ASA 7 to ASA 9
> I used to have a query that do a summation on a column that may contain
> null
> values
> ASA7 was returning null, but in ASA9 I'm receiving a "null value
> eliminated
> in aggregate function" message, and no result is returned.
>
> Any one has any idea, how to solve this issue using the ASA 9
>
> Regards
> Rabih
>
>
|
|
|
|
|