RE: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Reid Thompson
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. > >

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Martin Engelschalk
postgresql 8.0.1 on WinXP: a | b | sum ---+---+- 1 | 2 | 2 | 2 | 4 1 | | 8 | | 16 (4 rows) Martin 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 su

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread G. Roderick Singleton
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

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread D. Richard Hipp
Thanks everybody! All the results so far seem to be in agreement with each other and with the current behavior of SQLite. So I think everything is good. Thx for the help. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread G. Roderick Singleton
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

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Nemanja Corlija
On 9/1/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: >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;

RE: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Thomas Briggs
- - 16 -Tom > -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 01, 2005 2:51 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Survey: NULLs and GROUP BY > > I'm rewriting the aggregate fun

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Mark de Vries
Postgresql 7.4.7 stats=>SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; a | b | sum ---+---+- 1 | 2 | 2 | 2 | 4 1 | | 8 | | 16 (4 rows) Rgds, Mark. On Thu, 1 Sep 2005, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so th

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Robert Simpson
Sent: Thursday, September 01, 2005 11:51 AM Subject: [sqlite] Survey: NULLs and GROUP BY 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 NUL

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Brass Tilde
>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

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Vladimir Zelinski
Oracle 9i: A B SUM(C) 1 2 2 [NULL] 2 4 1 [NULL] 8 [NULL] [NULL] 16 --- "D. Richard Hipp" <[EMAIL PROTECTED]> 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

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Puneet Kishor
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 so

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Cory Nelson
SQL Server 2005: a b --- --- --- 1 2 2 NULL 2 4 1NULL 8 NULLNULL 16 On 9/1/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > I'm rewriting the aggregate fu

RE: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Bob Dankert
. 608.256.5680 f. 608.256.3780 -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 1:51 PM To: sqlite-users@sqlite.org Subject: [sqlite] Survey: NULLs and GROUP BY I'm rewriting the aggregate function processing in SQLite (so that it runs faste

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Robert Simpson
MS Jet: a bExpr1002 1 22 NULL 24 1 NULL 8 NULL NULL 16 - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Thursday, September 01, 2005 11:51 AM Subject: [sqlite] Survey: NULLs and GROUP BY I'm re

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Andrew Piskorski
On Thu, Sep 01, 2005 at 02:51:21PM -0400, D. Richard Hipp wrote: Oracle9i Enterprise Edition Release 9.2.0.4.0: SQL> SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; A B SUM(C) -- -- -- 1 2 2 2 4 1 8 16 > Can I get some volunteers to run the

Re: [sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread Puneet Kishor
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 so

[sqlite] Survey: NULLs and GROUP BY

2005-09-01 Thread D. Richard Hipp
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