Re: [sqlite] Upon table creation, multiple CHECK constraints do not work with FTS3

2010-08-30 Thread Dan Kennedy
On Aug 30, 2010, at 12:22 PM, Benoit Mortgat wrote: Hello, The following table creation fails under latest release : CREATE VIRTUAL TABLE foo USING FTS3 ( bar TEXT, othercolumns TEXT, CHECK(1), CHECK(1) ); Error message: vtable constructor failed Maybe it thinks the two CHECK(1)

Re: [sqlite] Upon table creation, multiple CHECK constraints do not work with FTS3

2010-08-30 Thread Benoit Mortgat
The 1 expression was here only for simplification, but it also fails to run the statement whatever expressions are specified. Thank you for your answer. I now am aware that checks must be done by the upper-level application. Benoit On Mon, Aug 30, 2010 at 08:19, Dan Kennedy

[sqlite] Upon table creation, multiple CHECK constraints do not work with FTS3

2010-08-29 Thread Benoit Mortgat
Hello, The following table creation fails under latest release : CREATE VIRTUAL TABLE foo USING FTS3 ( bar TEXT, othercolumns TEXT, CHECK(1), CHECK(1) ); Error message: vtable constructor failed It is possible to bypass that error by concatenating the CHECKS with AND logic, which is what