SQLite

View Ticket
Login
Ticket Hash: 42d45a693e6a8d1321ba7b12dc1e1992e64bfa97
Title: Spurious log message from FTS3
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2010-03-15 19:28:20
Version Found In: 3.6.23
Description:
FTS3 is generating a spurious log message when a connection is established
to an existing table.  To see this, first create a virtual table:

<blockquote><pre>
CREATE VIRTUAL TABLE t1 USING fts3(x);
INSERT INTO t1 VALUES('hello world');
</pre></blockquote>

Then in a different shell, connect to the table and display its contents.

<blockquote><pre>
.log stdout
SELECT * FROM t1;
</pre></blockquote>

The ".log stdout" command to the shell causes log messages to be displayed
on standard output.  The spurious message is:  "no such table: main.t1_docsize"