Re: [sqlite] Producing SQLITE_MISMATCH

2017-03-09 Thread J. King
On 2017-03-09 09:59:25, "Dan Kennedy" wrote: On 03/09/2017 09:39 PM, J. King wrote: Out of curiosity, can you provide some insight as to why it does not produce a mismatch for a WITHOUT ROWID table? The main b-tree in which data for a "rowid table" - any table that is

Re: [sqlite] Producing SQLITE_MISMATCH

2017-03-09 Thread Dan Kennedy
On 03/09/2017 09:39 PM, J. King wrote: On 2017-03-09 09:35:00, "Dan Kennedy" wrote: On 03/09/2017 09:23 PM, J. King wrote: I'm trying to write a minimal test case to produce an SQLITE_MISMATCH response. The documentation suggests the following should be sufficient:

Re: [sqlite] Producing SQLITE_MISMATCH

2017-03-09 Thread Dan Kennedy
On 03/09/2017 09:23 PM, J. King wrote: I'm trying to write a minimal test case to produce an SQLITE_MISMATCH response. The documentation suggests the following should be sufficient: CREATE TABLE test(id integer primary key) WITHOUT ROWID; INSERT INTO test(id) VALUES('ook'); However, SQLite

Re: [sqlite] Producing SQLITE_MISMATCH

2017-03-09 Thread J. King
On 2017-03-09 09:35:00, "Dan Kennedy" wrote: On 03/09/2017 09:23 PM, J. King wrote: I'm trying to write a minimal test case to produce an SQLITE_MISMATCH response. The documentation suggests the following should be sufficient: CREATE TABLE test(id integer primary