Re: [sqlite] R*Tree insert error ...

January 18, 2012 11:51:41 AM Subject: Re: [sqlite] R*Tree insert error ... On 18/01/2012 18:04, Dan Kennedy wrote: > One possibility is that you're hitting one of the r-tree tables > built-in constraints by specifying a record with (minval > maxval) > for one or more of the dimen

Re: [sqlite] R*Tree insert error ...

On 18/01/2012 18:04, Dan Kennedy wrote: One possibility is that you're hitting one of the r-tree tables built-in constraints by specifying a record with (minval > maxval) for one or more of the dimensions. Rearranging the bind parameters for match minx,miny,maxx,maxy layout I now get this

Re: [sqlite] R*Tree insert error ...

Hello Dan Are you using sqlite3_prepare() or sqlite3_prepare_v2()? If the former, try switching to prepare_v2() then checking the error message again. The former. I've switched to V2. One possibility is that you're hitting one of the r-tree tables built-in constraints by specifying a record

Re: [sqlite] R*Tree insert error ...

On 01/19/2012 12:42 AM, g...@novadsp.com wrote: On 18/01/2012 16:41, Richard Hipp wrote: What does sqlite3_errmsg() say? 'SQL logic error or missing database' Are you using sqlite3_prepare() or sqlite3_prepare_v2()? If the former, try switching to prepare_v2() then checking the error

Re: [sqlite] R*Tree insert error ...

On 18/01/2012 16:41, Richard Hipp wrote: What does sqlite3_errmsg() say? 'SQL logic error or missing database' I should perhaps add this set of inserts is running inside a transaction with a WAL enabled database. There is only one write thread active. All other inserts (save R*Tree) work

Re: [sqlite] R*Tree insert error ...

On Wed, Jan 18, 2012 at 11:15 AM, g...@novadsp.com wrote: > One more oddity. Can anyone help? > > 1. Create a 2D index as per documentation: > > "CREATE VIRTUAL TABLE gps_index USING rtree(id,minX, maxX,minY, maxY)" > > 2. Create a statement using a binding string: > > "INSERT

[sqlite] R*Tree insert error ...

One more oddity. Can anyone help? 1. Create a 2D index as per documentation: "CREATE VIRTUAL TABLE gps_index USING rtree(id,minX, maxX,minY, maxY)" 2. Create a statement using a binding string: "INSERT INTO gps_index VALUES(last_insert_rowid(), ?, ?, ?, ?)" 3. Bind values. Binding indices

[sqlite] R*Tree insert error ...

One more oddity. Can anyone help? 1. Create a 2D index as per documentation: "CREATE VIRTUAL TABLE gps_index USING rtree(id,minX, maxX,minY, maxY)" 2. Create a statement using a binding string: "INSERT INTO gps_index VALUES(last_insert_rowid(), ?, ?, ?, ?)" 3. Bind values. Binding indices