Re: [sqlite] [BUG; 3.7.13] ANALYZE leads to a wrong query plan for RTrees

2013-12-10 Thread skywind mailing lists
Am 10.12.2013 um 10:59 schrieb Dan Kennedy : > On 12/10/2013 02:44 PM, skywind mailing lists wrote: >> This is an example that the ANALYZE command leads to a wrong query plan for >> RTrees: >> >> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); >>

Re: [sqlite] [BUG; 3.7.13] ANALYZE leads to a wrong query plan for RTrees

2013-12-10 Thread Dan Kennedy
On 12/10/2013 02:44 PM, skywind mailing lists wrote: This is an example that the ANALYZE command leads to a wrong query plan for RTrees: CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,

[sqlite] [BUG; 3.7.13] ANALYZE leads to a wrong query plan for RTrees

2013-12-09 Thread skywind mailing lists
This is an example that the ANALYZE command leads to a wrong query plan for RTrees: CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude); CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude, FromLongitude,TillLongitude); INSERT INTO A VALUES(1,0,0,0); INSERT