On 2017-03-09 09:35:00, "Dan Kennedy" <danielk1...@gmail.com> 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
CREATE TABLE test(id integer primary key) WITHOUT ROWID;
INSERT INTO test(id) VALUES('ook');
However, SQLite happily accepts the second statement. Is there some
trick to it that's not obvious?
Leave out the WITHOUT ROWID.
Ah, exactly what I needed. Thanks!
Out of curiosity, can you provide some insight as to why it does not
produce a mismatch for a WITHOUT ROWID table?
(apologies if my messages come out looking yucky; I'm still looking a
mail client that isn't awful dealing with mailing lists. :( )
sqlite-users mailing list