Aloha, While testing the new full text search feature, I noticed the following:
SQLite version 3.3.8 Enter ".help" for instructions sqlite> CREATE TABLE a (data TEXT); sqlite> INSERT INTO a VALUES ('some data'); sqlite> CREATE VIRTUAL TABLE b USING fts1 (data TEXT); sqlite> INSERT INTO b (ROWID, data) SELECT ROWID, data FROM a; SQL error: datatype mismatch sqlite> Is this intended to work, or is it another exception in what can be done to fts1/virtual tables vs. real tables, similar to how ALTER TABLE doesn't work? BTW, great work... I'm looking forward to fts2. Thanks. - glen ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------