| Subject | Re: [firebird-support] Count(id) returns null. although count should never return null... |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-09-07T01:01:28Z |
At 07:40 PM 6/09/2005 +0200, you wrote:
with 335544824 (dsql_agg_column_err) Invalid expression in the %s (not
contained in either an aggregate function or the GROUP BY clause.
./heLen
> > I ran the following query on a regular table:In 1.5 it shouldn't return a result at all. It should except at Prepare
> > 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.
with 335544824 (dsql_agg_column_err) Invalid expression in the %s (not
contained in either an aggregate function or the GROUP BY clause.
./heLen