Re: [sqlite] group by error in 3.2.6?

2005-09-20 Thread Eric Bohlman
Edzard Pasma wrote: There is a difference in the behaviour of GROUP BY in version 3.2.6. If you group by a column that contains NULL values, each NULL value comes on a seperate output line. Conceptually not so bad, if we read NULL as "unknown" and not as "empty". But I guess it is an error. T

[sqlite] group by error in 3.2.6?

2005-09-20 Thread Edzard Pasma
There is a difference in the behaviour of GROUP BY in version 3.2.6. If you group by a column that contains NULL values, each NULL value comes on a seperate output line. Conceptually not so bad, if we read NULL as "unknown" and not as "empty". But I guess it is an error. For the rest I'm very h