Yes, it is this one. With the new script I gave in my last mail it has changed to
SELECT * FROM Pylones P JOIN Lignes L ON L.lig_id = P.lig_id JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 1; And the expected result is : 1 1 1 BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 1 916798.875000 916798.875000 6508700.000000 6508700.000000 2 1 2 BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 2 917132.625000 917132.625000 6509169.000000 6509169.000000 3 1 3 BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 3 917228.875000 917228.875000 6509615.500000 6509615.500000 4 1 3 bis BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 4 917147.437500 917147.437500 6510600.500000 6510600.500000 5 1 5 BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 5 917130.812500 917130.812500 6511282.500000 6511282.500000 6 1 6 BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 6 916891.312500 916891.312500 6511604.000000 6511604.000000 7 1 7 BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 7 916613.125000 916613.125000 6512076.000000 6512076.000000 With System.Data.Sqlite 3.8.5 and an index on Pylones.lig_id the result is only : 1 1 1 BLOB sz=60 GEOMETRY 1 Ligne 1 BLOB sz=160 GEOMETRY 1 916798.875000 916798.875000 6508700.000000 6508700.000000 -----Message d'origine----- De : [email protected] [mailto:[email protected]] De la part de Joe Mistachkin Envoyé : lundi 28 juillet 2014 23:11 À : 'General Discussion of SQLite Database' Objet : Re: [sqlite] System.Data.Sqlite Eric DAVID wrote: > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 3; > Is the above query the one that has the issue? What is the output you expect from it? -- Joe Mistachkin _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
