Subject Re: [firebird-support] Count(id) returns null. although count should never return null...
Author Helen Borrie
At 07:40 PM 6/09/2005 +0200, you wrote:
> > I ran the following query on a regular table:
> > SELECT count(id) FROM FILES WHERE 0=1 group by id
> > and I got NULL as an answer.
>Are you sure ? It should not return NULL but empty result.

In 1.5 it shouldn't return a result at all. It should except at Prepare
with 335544824 (dsql_agg_column_err) Invalid expression in the %s (not
contained in either an aggregate function or the GROUP BY clause.