On 07/13/2014 01:24 AM, Staffan Tylen wrote:
According to sqlite3 I'm on 3.8.3:
SQLite version 3.8.3 2014-02-03 14:04:11
I remember now. There was a bug regarding compound SELECT statements
that use CTEs discovered shortly after 3.8.3 was released:
http://www.sqlite.org/src/info/67bfd59d9087a987
http://www.sqlite.org/src/info/31a19d11b97088296a
The fix appeared in 3.8.4. If you upgrade, the statement will work.
You'll note that I said the statement "should" work in 3.8.3. Not that
it does. :)
Dan.
On Sat, Jul 12, 2014 at 8:06 PM, Dan Kennedy <danielk1...@gmail.com> wrote:
On 07/13/2014 12:29 AM, Staffan Tylen wrote:
The following statement is flagged as invalid, so what's the correct way
of
coding it?
WITH A AS (SELECT 'A'),
B AS (SELECT 'B')
SELECT *
FROM A
UNION
SELECT *
FROM B
;
This statement should work in SQLite 3.8.3 or newer.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
