On Thu, 2005-09-01 at 14:51 -0400, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make > sure that SQLite handles NULLs in GROUP BY values the same > as other database engines. > > Can I get some volunteers to run the SQL shown below on various > other SQL database engines and tell me what the output is? > > CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER); > INSERT INTO t1 VALUES(1,2,1); > INSERT INTO t1 VALUES(NULL,2,2); > INSERT INTO t1 VALUES(1,NULL,4); > INSERT INTO t1 VALUES(NULL,NULL,8); > INSERT INTO t1 SELECT * FROM t1; > SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; > > Thanks.
Dumb forgot the version. Postgresql 8.0.3 psql template1 <pg.sql CREATE TABLE INSERT 17808 1 INSERT 17809 1 INSERT 17810 1 INSERT 17811 1 INSERT 0 4 a | b | sum ---+---+----- 1 | 2 | 2 | 2 | 4 1 | | 8 | | 16 (4 rows) -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech