CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2); CREATE TABLE t1(x, y); INSERT INTO t1 VALUES(1, 2); SELECT name FROM sqlite_master ORDER BY 1; SELECT * FROM t1; SELECT * FROM rt; SELECT name FROM sqlite_master ORDER BY 1; CREATE VIRTUAL TABLE ft USING fts5(x); CREATE TABLE t1(x, y); INSERT INTO t1 VALUES(1, 2); SELECT name FROM sqlite_master ORDER BY 1; SELECT name FROM sqlite_master ORDER BY 1; CREATE VIRTUAL TABLE ft USING fts3(x); CREATE TABLE t1(x, y); INSERT INTO t1 VALUES(1, 2); SELECT name FROM sqlite_master ORDER BY 1; SELECT name FROM sqlite_master ORDER BY 1;