On 08/17/2011 10:10 PM, George Brink wrote: > I think this is a bug... If you trying to create FTS3/FTS4 table, make > sure that column name in FTS table is not the same as the table name. > > C:\Projects>sqlite3 aaa > SQLite version 3.7.7.1 2011-06-28 17:39:05 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create virtual table abc using fts3(abc text); > Error: vtable constructor failed: abc > sqlite> create virtual table abc using fts3(abcd text); > sqlite> .exit
It's because of the "hidden column". See the first paragraph under the second example block here: http://www.sqlite.org/fts3.html#section_1_4 Docs should be updated to say that you can't create a column with the same name as the table. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users