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)
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
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