mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-13 12:28:30 +00:00
49 lines
1.2 KiB
Plaintext
49 lines
1.2 KiB
Plaintext
|
|
CREATE TABLE t1(a, b, c);
|
|
CREATE INDEX t1b ON t1(b);
|
|
INSERT INTO t1 VALUES('one', 1, 1);
|
|
INSERT INTO t1 VALUES('two', 1, 2);
|
|
INSERT INTO t1 VALUES('three', 1, 3);
|
|
INSERT INTO t1 VALUES('four', 2, 1);
|
|
INSERT INTO t1 VALUES('five', 2, 2);
|
|
INSERT INTO t1 VALUES('six', 2, 3);
|
|
INSERT INTO t1 VALUES('seven', 3, 1);
|
|
INSERT INTO t1 VALUES('eight', 3, 2);
|
|
INSERT INTO t1 VALUES('nine', 3, 3);
|
|
|
|
WITH s(i) AS (
|
|
SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<10000
|
|
) INSERT INTO t1 SELECT NULL, NULL, NULL FROM s;
|
|
CREATE VIRTUAL TABLE e1 USING echo(t1);
|
|
|
|
|
|
SELECT a FROM e1 WHERE (b, c) = (2, 2)
|
|
|
|
|
|
SELECT a FROM e1 WHERE (b, c) > (2, 2)
|
|
|
|
|
|
SELECT a FROM e1 WHERE (b, c) >= (2, 2)
|
|
|
|
|
|
SELECT a FROM e1 WHERE (b, c) BETWEEN (1, 2) AND (2, 3)
|
|
|
|
|
|
SELECT a FROM e1 WHERE (b, c) IN ( VALUES(2, 2) )
|
|
|
|
|
|
CREATE TABLE t2(a, b, c);
|
|
CREATE INDEX t2b ON t2(b);
|
|
INSERT INTO t2 VALUES('one', 1, 1);
|
|
INSERT INTO t2 VALUES('two', 1, 2);
|
|
INSERT INTO t2 VALUES('three', 1, 3);
|
|
|
|
WITH s(i) AS (
|
|
SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<10000
|
|
) INSERT INTO t2 SELECT NULL, NULL, NULL FROM s;
|
|
CREATE VIRTUAL TABLE e2 USING echo_v2(t2);
|
|
|
|
|
|
SELECT a FROM e2 WHERE (b, c) IN ( VALUES(1, 3) )
|
|
|