----- Original Message -----
From: "Keith Medcalf" <kmedc...@dessus.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Monday, August 25, 2014 2:28 PM
Subject: Re: [sqlite] Problem with recursive CTE
Looking backwards on the list one finds that:
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.
Since you do not mention what version you are using, one assumes it is
prior to this fix?
Thanks, Keith. I think you are spot on. See my reply to Richard.
I will upgrade and try again.
Frank
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
