Re: [sqlite] Parser bug on sub joins when on right side of the join operator

2012-06-22 Thread TAUZIN Mathieu
Hi, According to the documentation (Sqlite + standard Ansi), queries that should be supported like : SELECT * FROM A JOIN (B JOIN C ON B.ID = C.ID) ON A.ID = B.ID are still not supported whereas badly formed queries like : SELECT * FROM A JOIN (B JOIN C ON B.ID =

Re: [sqlite] Parser bug on sub joins when on right side of the join operator

2012-04-04 Thread TAUZIN Mathieu
Hi, I expected someone would reply to this one Mathieu -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Mathieu TAUZIN Envoyé : lundi 26 mars 2012 15:53 À : sqlite-users@sqlite.org Objet : [sqlite] Parser bug on sub

[sqlite] Parser bug on sub joins when on right side of the join operator

2012-03-27 Thread Mathieu TAUZIN
Hi, According to their definition (http://sqlite.org/syntaxdiagrams.html#single-source) , Join sources (named single-source) are either : * a table or view with an optional alias and/or with an optional index * a sub query with an optional alias