Subject Re: [firebird-support] Count(id) returns null. although count should never return null...
Author Federico Tello Gentile
asakin312 wrote:
> SELECT count(id) FROM FILES WHERE 0=1 group by id
> and I got NULL as an answer.
>
> The following query works ok and returns 0:
> SELECT count(id) FROM FILES WHERE 0=1
>
> Is this the correct behavior?

Oracle does the same. I didn't read the SQL standard.