[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] error group_concat
From:       Richard Hipp <drh () sqlite ! org>
Date:       2012-08-24 1:15:36
Message-ID: CALwJ=Mzn4XB+WF0EK3Nv6D=NxGho5KyX_-_3o1TVDUD9y3ZOrw () mail ! gmail ! com
[Download RAW message or body]

On Fri, Jun 15, 2012 at 9:22 AM, Luigi <luigi@emme4.it> wrote:

> CREATE TABLE t1 (A1 INTEGER NOT NULL,A2 INTEGER NOT NULL,A3 INTEGER NOT
> NULL,A4 INTEGER NOT NULL,PRIMARY KEY(A1));
> REPLACE INTO t1 VALUES(1,11,111,1111);
> REPLACE INTO t1 VALUES(2,22,222,2222);
> REPLACE INTO t1 VALUES(3,33,333,3333);
> CREATE TABLE t2 (B1 INTEGER NOT NULL,B2 INTEGER NOT NULL,B3 INTEGER NOT
> NULL,B4 INTEGER NOT NULL,PRIMARY KEY(B1));
> REPLACE INTO t2 VALUES(1,88,888,8888);
> REPLACE INTO t2 VALUES(2,99,999,9999);
>
> SELECT (SELECT GROUP_CONCAT(CASE WHEN a1=1 THEN'A' ELSE 'B' END) FROM
> t2),t1.*
> FROM t1;
>
> from Sqlite 3.7.12
> return error misuse of aggregate
>

Fixed in http://www.sqlite.org/src/info/d4cd6017c9


>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
drh@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]