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 <danielk1...@gmail.com> wrote: > > 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)" identifiers represent a > duplicate column name. CHECK constraints will not work with > either fts3 or rtree virtual tables. If they are parsed at > all, they will probably not do what you are expecting. > > Dan. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Benoit Mortgat 20, avenue Marcel Paul 69200 VĂ©nissieux, France +33 6 17 15 41 58 +33 4 27 11 61 23 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users