Re: [sqlite] R*Tree constraint error when inserting valid data

2013-06-27 Thread Tobias Kolb
OK, I tried the SQLite command line tool 3.7.17 and inserted all 1 million records without any error. Then I cleared the table, ran the same SQL again in SQLite Studio and *bang* same error. Seems to be a problem of SQLite Studio. Anyway, I'm glad thats no bug in SQLite and my problem is solved. @

Re: [sqlite] R*Tree constraint error when inserting valid data

2013-06-27 Thread Yan Seiner
Tobias Kolb wrote: Hi, I'm currently experimenting with the R*Tree support in SQLite. I have to collect some log data over a timespan and save it linked to the area (not the exact path, just a minimum bounding rect around) it was collected (min/max latitude and min/max longitude). Based on this

Re: [sqlite] R*Tree constraint error when inserting valid data

2013-06-27 Thread Tobias Kolb
No, there isn't. I just copy/pasted the insert out of my long script. Insert 1 to 472 works well, #473 was just the first one that fails. Hm, maybe the problem is SQLiteStudio? I'll check the command line tool of SQLite... 2013/6/27 Dan Kennedy > On 06/27/2013 09:19 PM, Tobias Kolb wrote: > >>

Re: [sqlite] R*Tree constraint error when inserting valid data

2013-06-27 Thread Dan Kennedy
On 06/27/2013 09:19 PM, Tobias Kolb wrote: Hi, I'm currently experimenting with the R*Tree support in SQLite. I have to collect some log data over a timespan and save it linked to the area (not the exact path, just a minimum bounding rect around) it was collected (min/max latitude and min/max lo

[sqlite] R*Tree constraint error when inserting valid data

2013-06-27 Thread Tobias Kolb
Hi, I'm currently experimenting with the R*Tree support in SQLite. I have to collect some log data over a timespan and save it linked to the area (not the exact path, just a minimum bounding rect around) it was collected (min/max latitude and min/max longitude). Based on this data I want to do ran