On 1/11/07, Ohad Eder-Pressman <[EMAIL PROTECTED]> wrote:
inserts work
once i update my fts1 table and then select data from it, i get gibberish.
anybody seen something like this ?
Anything is possible - suggest you indicate the version you're using,
and provide an SQL script which demonstrates the problem. For
instance, something like:
CREATE VIRTUAL TABLE t USING fts1(content);
INSERT INTO t (rowid, content) VALUES (1, 'this is a test');
UPDATE t SET content = 'that was a test' WHERE rowid = 1;
-- The following is returning 'gibberish here' for me:
SELECT content FROM t WHERE rowid = 1;
Or just copy one of the files like test/fts1a.test, and modify it to
show what you mean.
-scott
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
