Here is the list of all sql statements in the file Base.sql, included INSERT Statements. I think the issue comes from the index idx_Pylones_lig_id.
Eric DAVID -----Message d'origine----- De : [email protected] [mailto:[email protected]] De la part de Joe Mistachkin Envoyé : lundi 28 juillet 2014 23:59 À : 'General Discussion of SQLite Database' Objet : Re: [sqlite] System.Data.Sqlite Eric DAVID wrote: > > 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; > So far, I'm unable to reproduce your results here. Could you please provide the list of all SQL statements used to get the database into the state where the issue is seen, including any INSERT statements used to populate it with the test data. -- 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
