0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-13 06:15:17 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/select9.test
2024-05-27 12:59:10 +02:00

14 lines
277 B
Plaintext

CREATE TABLE t61(a);
CREATE TABLE t62(b);
INSERT INTO t61 VALUES(111);
INSERT INTO t62 VALUES(222);
SELECT a FROM t61 WHERE 0 UNION SELECT b FROM t62;
SELECT a FROM t61 WHERE 0 UNION ALL SELECT b FROM t62;
SELECT a FROM t61 UNION SELECT b FROM t62 WHERE 0;