mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
30 lines
608 B
Plaintext
30 lines
608 B
Plaintext
|
|
CREATE TABLE t1(a TEXT, b);
|
|
INSERT INTO t1 VALUES('hello', 0);
|
|
INSERT INTO t1 VALUES('world', 0);
|
|
|
|
CREATE TABLE t2(x TEXT);
|
|
INSERT INTO t2 VALUES('hello');
|
|
INSERT INTO t2 VALUES('world');
|
|
|
|
CREATE TABLE t3(y);
|
|
INSERT INTO t3 VALUES(1000);
|
|
|
|
|
|
SELECT 1000 = y FROM t3
|
|
|
|
|
|
SELECT 1000 IN (SELECT x FROM t2), 1000 = y FROM t3
|
|
|
|
|
|
SELECT 0 IN (SELECT a), (SELECT a LIMIT 0) FROM t1
|
|
|
|
|
|
SELECT 0 IN (SELECT a) FROM t1 WHERE a = 'hello' OR (SELECT a LIMIT 0);
|
|
|
|
|
|
CREATE TABLE v0(v1 VARCHAR0);
|
|
INSERT INTO v0 VALUES(2), (3);
|
|
SELECT 0 IN(SELECT v1) FROM v0 WHERE v1 = 2 OR(SELECT v1 LIMIT 0);
|
|
|