1 2 3 4 5 6
CREATE VIRTUAL TABLE t1 USING fts3(a); INSERT INTO t1 VALUES('test renaming the table'); INSERT INTO t1 VALUES(' after it has been written'); INSERT INTO t1 VALUES(' actually other stuff instead');