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]
-----------------------------------------------------------------------------
