Re: [sqlite] Problem with recursive CTE

- Original Message - From: "Alek Paunov" <a...@declera.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, August 25, 2014 4:04 PM Subject: Re: [sqlite] Problem with recursive CTE On 25.08.2014 15:42, Frank

Re: [sqlite] Problem with recursive CTE

On 25.08.2014 15:42, Frank Millman wrote: I have upgraded to version 3.8.6, and I can confirm that it now works. Thanks very much, Richard and Keith Now I have to figure out how to get Python to use the upgraded version, but that is one for the python mailing list. You may consider upgrade

Re: [sqlite] Problem with recursive CTE

- Original Message - From: "Frank Millman" <fr...@chagford.com> To: <sqlite-users@sqlite.org> Sent: Monday, August 25, 2014 2:32 PM Subject: Re: [sqlite] Problem with recursive CTE Could it be a version problem? I am using the version bundled with P

Re: [sqlite] Problem with recursive CTE

- 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

Re: [sqlite] Problem with recursive CTE

From: "Frank Millman" Thanks for the reply, Richard. WITH RECURSIVE temp(x) AS ( SELECT 1 UNION ALL SELECT x+1 FROM temp WHERE x<5 ) SELECT x FROM temp UNION SELECT x+5 FROM temp; And did indeed get integers 1 through 10 as an answer. I get the same error as before -

Re: [sqlite] Problem with recursive CTE

ust, 2014 04:11 >To: sqlite-users@sqlite.org >Subject: [sqlite] Problem with recursive CTE > >Hi all > >According to the documentation for the WITH clause, "the recursive table >must appear exactly once in the FROM clause of the recursive-select and >must >not appea

Re: [sqlite] Problem with recursive CTE

On Mon, Aug 25, 2014 at 6:10 AM, Frank Millman wrote: > > I am trying to do the following - > > WITH RECURSIVE temp AS ( > [initial-select UNION ALL recursive-select] > ) > SELECT * FROM temp UNION * FROM temp > > I get the error 'no such table: temp'. > Hard to test

Re: [sqlite] Problem with recursive CTE

From: "Frank Millman" WITH RECURSIVE temp AS ( [initial-select UNION ALL recursive-select] ) SELECT * FROM temp UNION * FROM temp Sorry, I meant SELECT * FROM temp UNION SELECT * FROM temp Frank ___ sqlite-users mailing

[sqlite] Problem with recursive CTE

Hi all According to the documentation for the WITH clause, "the recursive table must appear exactly once in the FROM clause of the recursive-select and must not appear anywhere else in either the initial-select or the recursive-select, including subqueries". I am trying to do the following