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

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] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

ONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0 TAUZIN Mathieu wrote: > > I've just noticed that a resource is missing in System.Data.SQLite.Linq.dll > since version 1.0.79.0. > I'm not able to reproduce this problem. When viewed with ILDAS

Re: [sqlite] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

Hi, I've just noticed that a resource is missing in System.Data.SQLite.Linq.dll since version 1.0.79.0. The missing resource causes an exception when calling the SQLiteProviderServices' ISQLiteSchemaExtensions.BuildTempSchema implementation. Hope this will help Mathieu TAUZIN

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

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

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Nico Williams Envoyé : lundi 19 mars 2012 16:10 À : General Discussion of SQLite Database Objet : Re: [sqlite] Join-source issue when using sub '(' join-source ')' On Mon, Mar 19, 2012 at 10:02 AM, TAUZIN Mathieu <mtau..

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

bjet : Re: [sqlite] Join-source issue when using sub '(' join-source ')' On Mon, Mar 19, 2012 at 12:03:44PM +0000, TAUZIN Mathieu scratched on the wall: > Hi, > > According to the documentation on SELECT statements > http://www.sqlite.org/lang_select.html > It seems possible

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

Thanks, This syntax works but it is not documented... it looks like a short hand for a subquery, interesting !. Mathieu -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Simon Davies Envoyé : lundi 19 mars 2012 14:24 À :

Re: [sqlite] Join-source issue when using sub '(' join-source ')'

:03pm, TAUZIN Mathieu <mtau...@cegid.fr> wrote: > Or without subjoin... > SELECT Orders.OrderID > FROM Customers > INNER JOIN Orders >ON Customers.CustomerID = Orders.CustomerID > LEFT OUTER JOIN InternationalOrders >

[sqlite] Join-source issue when using sub '(' join-source ')'

Hi, According to the documentation on SELECT statements http://www.sqlite.org/lang_select.html It seems possible to write join chains as A join (B join C). (using a '(' join-source ')' single-source ) But on the well known NorthwindEF database this query ... SELECT Orders.OrderID FROM