Re: [sqlite] fts3 table name cannot be the same as column name

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 >

[sqlite] fts3 table name cannot be the same as column name

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