mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-16 11:28:45 +00:00
21 lines
594 B
Plaintext
21 lines
594 B
Plaintext
|
|
CREATE VIRTUAL TABLE t1 USING tcl("vtab_cmd 0");
|
|
|
|
|
|
CREATE TABLE ttt(a, b, c);
|
|
|
|
INSERT INTO ttt VALUES(1, 'two', 'three');
|
|
INSERT INTO ttt VALUES(2, 'one', 'two');
|
|
INSERT INTO ttt VALUES(3, 'three', 'one');
|
|
INSERT INTO ttt VALUES(4, 'y', 'one');
|
|
INSERT INTO ttt VALUES(5, 'x', 'two');
|
|
INSERT INTO ttt VALUES(6, 'y', 'three');
|
|
|
|
|
|
CREATE TABLE t2(x TEXT COLLATE nocase, y TEXT);
|
|
CREATE INDEX t2x ON t2(x COLLATE nocase);
|
|
CREATE INDEX t2y ON t2(y);
|
|
|
|
CREATE VIRTUAL TABLE t3 USING tcl('vvv_command')
|
|
CREATE VIRTUAL TABLE t4 USING tcl('yyy_command')
|