On 16-06-2012 17:13, Black, Michael (IS) wrote: > Works in 3.7.9 > > > On my Windows 3.7.12 version it gets a segfault. > On my Unix 3.7.13 version I get the misuse of aggregate > >
works in 3.7.11 too (Windows7): SQLite version 3.7.11 2012-03-20 11:35:50 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE t1 (A1 INTEGER NOT NULL,A2 INTEGER NOT NULL,A3 INTEGER NOT NULL,A4 INTEGER NOT NULL,PRIMARY KEY(A1)); sqlite> REPLACE INTO t1 VALUES(1,11,111,1111); sqlite> REPLACE INTO t1 VALUES(2,22,222,2222); sqlite> REPLACE INTO t1 VALUES(3,33,333,3333); sqlite> CREATE TABLE t2 (B1 INTEGER NOT NULL,B2 INTEGER NOT NULL,B3 INTEGER NOT NULL,B4 INTEGER NOT NULL,PRIMARY KEY(B1)); sqlite> REPLACE INTO t2 VALUES(1,88,888,8888); sqlite> REPLACE INTO t2 VALUES(2,99,999,9999); sqlite> SELECT (SELECT GROUP_CONCAT(CASE WHEN a1=1 THEN'A' ELSE 'B' END) FROM t2),t1.* FROM t1; A,A|1|11|111|1111 B,B|2|22|222|2222 B,B|3|33|333|3333 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
