Is the following intended to be legal and possible for a contentless fts table: to do multiple inserts with the same docid, but to different columns?
It seems to work, and I like it, but it wasn't entirely expected. sqlite> CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b); sqlite> INSERT INTO t1(docid, a) VALUES (1, "avery"); sqlite> INSERT INTO t1(docid, b) VALUES (1, "billy"); sqlite> SELECT docid FROM t1 WHERE a MATCH 'avery'; 1 sqlite> SELECT docid FROM t1 WHERE b MATCH 'avery'; sqlite> SELECT docid FROM t1 WHERE b MATCH 'billy'; 1 sqlite> SELECT docid FROM t1 WHERE t1 MATCH 'billy'; 1 sqlite> SELECT docid FROM t1 WHERE t1 MATCH 'avery'; 1 Thanks, James _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users