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
