## Summary **No review yet** ## Minimized query ```sql .dbconfig PRAGMA vdbe_listing = 1; ATTACH DATABASE ':memory:' AS aux89; PRAGMA user_version = ')'; .scanstats est BEGIN EXCLUSIVE TRANSACTION; SAVEPOINT sp1494; .nullvalue NULL32327d3-concat(5)36b-41de-a764-a6301986aeab SAVEPOINT sp8221; ATTACH DATABASE (':memory:' || '') AS aux42; SAVEPOINT sp6872; PRAGMA temp_store_directory; PRAGMA trusted_schema = NO; PRAGMA query_only; .exit .read CREATE TABLE t1(a BLOB, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array('{"a":1,"b":[1,2,3]}') FROM c WHERE NOT +i= 1; CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE a >= 2 ORDER BY b; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT /* octet_length('你好') */ RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; SELECT STRING_AGG(cnt) FROM t3; UPDATE t2 SET y = 31 WHERE rowid = 1 RETURNING *; SELECT * FROM t1 WHERE ax IN (SELECT ALL ax FROM t1); SELECT AVG(ax) FROM t1; UPDATE t2 SET y = NULL; INSERT INTO t2 SELECT * FROM t2; SELECT COUNT(*) FILTER (WHERE x IS NOT NULL), SUM(rowid) FILTER (WHERE x > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(x) FILTER (WHERE x > 0 OR x < 100), COUNT(*) FILTER (WHERE typeof(x) = "text") FROM t2; INSERT INTO t3 DEFAULT VALUES; SELECT * FROM t3 AS a JOIN t2 AS b ON a.rowid = b.rowid; SELECT SUM(ax) FROM t1; REINDEX t2; CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE a >= 2 ORDER BY b; ALTER TABLE t2 RENAME COLUMN x TO x_r564; CREATE TRIGGER IF NOT EXISTS trg_t3_155 AFTER UPDATE OF cnt ON t3 FOR EACH ROW BEGIN INSERT INTO t3(cnt) VALUES (NULL); END; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT * FROM t3) UPDATE t3 SET cnt = (SELECT cnt FROM cte LIMIT 1) WHERE 1=0; ALTER TABLE t2 DROP COLUMN x; PRAGMA cache_spill = TRUE; ALTER TABLE t2 ADD COLUMN extra_6078 DATE UNIQUE; INSERT INTO t1 VALUES ('x', 'x', NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, ax = excluded.ax, b = excluded.b; SELECT STRING_AGG(cnt, '|') FROM t3; INSERT INTO t3 SELECT * FROM t3; SELECT * FROM t2 WHERE (y) IN (SELECT y FROM t2); ROLLBACK TO sp6872; RELEASE sp6872; ALTER TABLE t1 DROP COLUMN b; SELECT x, (SELECT MIN(x) FROM t2) AS min_val FROM t2; ANALYZE; SELECT COUNT(*) FROM t3; UPDATE t1 SET a = 'x' WHERE a IS NOT NULL RETURNING *; CREATE TEMP VIEW IF NOT EXISTS v_T_8797 AS SELECT a FROM T; INSERT INTO t2 VALUES (NULL, NULL); VACUUM main; SELECT * FROM t1 AS a LEFT OUTER JOIN t2 AS b ON a.rowid = b.rowid; SELECT COUNT(*) FROM t3; ALTER TABLE T RENAME TO T_r1139; UPDATE T SET a = a + 1 WHERE a BETWEEN 0 AND 100 RETURNING *; CREATE INDEX IF NOT EXISTS idx_t3_1555 ON t3((cnt + 1)); DETACH DATABASE aux42; ROLLBACK TRANSACTION TO SAVEPOINT sp8221; RELEASE SAVEPOINT sp8221; SELECT COUNT(cnt) FROM t3; SELECT 0x0ACB29BM205381; SELECT sqlite_compileoption_used('我的天你是怎么了'); SELECT 1 >> -999999999999999999999999999; SELECT sqlite_compileoption_get($1); SELECT sqlite_version(); ROLLBACK TO sp1494; RELEASE sp1494; CREATE UNIQUE INDEX IF NOT EXISTS idx_t3_1306 ON t3(lower(cnt)) WHERE cnt IS NOT NULL; SELECT * FROM t1 CROSS JOIN t1; SELECT * FROM t2 AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; CREATE TRIGGER IF NOT EXISTS trg_t1_7369 AFTER UPDATE ON t1 BEGIN SELECT RAISE(FAIL, 'no'); END; CREATE TEMP VIEW IF NOT EXISTS v_t3_3889 AS SELECT cnt FROM t3; CREATE TEMP VIEW IF NOT EXISTS v_T_9461 AS SELECT a FROM T; ANALYZE; INSERT INTO t2 DEFAULT VALUES; VACUUM main; CREATE TABLE T1 ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL UNIQUE ); CREATE TABLE T2 ( A VARCHAR(10) PRIMARY KEY, X VARCHAR(15) NOT NULL, C BIGINT, FOREIGN KEY (X) REFERENCES T1(A) ); INSERT INTO T1 VALUES ('p', 'x'); INSERT INTO T1 VALUES ('q', 'y'); INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807); INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808); SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X; SELECT LAG(a, 2, a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; DROP TRIGGER IF EXISTS T2; ALTER TABLE t1 RENAME COLUMN b TO b_r1471; END; SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T; SELECT * FROM T1 WHERE B IN (SELECT B FROM T1 t2 WHERE t2.B = T1.B); INSERT INTO t3 VALUES (NULL); INSERT INTO t2 SELECT * FROM t2; ANALYZE; DELETE FROM T2 WHERE 0 RETURNING *; INSERT INTO t2 VALUES (NULL, NULL); INSERT INTO t2 VALUES (1, 1) ON CONFLICT(x) DO UPDATE SET x = excluded.x, y = excluded.y; ALTER TABLE T2 RENAME COLUMN C TO C_r424; ALTER TABLE t2 RENAME TO t2_r5459; WITH RECURSIVE vals(x) AS (SELECT b FROM T WHERE b IS NOT NULL UNION ALL SELECT b FROM T WHERE b IS NOT NULL LIMIT 10) SELECT * FROM vals; PRAGMA user_version = 999; .scanstats est BEGIN EXCLUSIVE TRANSACTION; SAVEPOINT sp1494; .nullvalue NULL32327d3-concat(5)36b-41de-a764-a6301986aeab SAVEPOINT sp8221; ATTACH DATABASE (':memory:' || '') AS aux42; SAVEPOINT sp6872; PRAGMA temp_store_directory; PRAGMA trusted_schema = NO; PRAGMA query_only; .exit .read CREATE TABLE t1(a BLOB, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array('{"a":1,"b":[1,2,3]}') FROM c WHERE NOT +i= 1; CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE a >= 2 ORDER BY b; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT /* octet_length('你好') */ RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; SELECT STRING_AGG(cnt) FROM t3; UPDATE t2 SET y = 31 WHERE rowid = 1 RETURNING *; SELECT * FROM t1 WHERE ax IN (SELECT ALL ax FROM t1); SELECT AVG(ax) FROM t1; UPDATE t2 SET y = NULL; INSERT INTO t2 SELECT * FROM t2; SELECT COUNT(*) FILTER (WHERE x IS NOT NULL), SUM(rowid) FILTER (WHERE x > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(x) FILTER (WHERE x > 0 OR x < 100), COUNT(*) FILTER (WHERE typeof(x) = "text") FROM t2; INSERT INTO t3 DEFAULT VALUES; SELECT * FROM t3 AS a JOIN t2 AS b ON a.rowid = b.rowid; SELECT SUM(ax) FROM t1; REINDEX t2; CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE a >= 2 ORDER BY b; ALTER TABLE t2 RENAME COLUMN x TO x_r564; CREATE TRIGGER IF NOT EXISTS trg_t3_155 AFTER UPDATE OF cnt ON t3 FOR EACH ROW BEGIN INSERT INTO t3(cnt) VALUES (NULL); END; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT * FROM t3) UPDATE t3 SET cnt = (SELECT cnt FROM cte LIMIT 1) WHERE 1=0; ALTER TABLE t2 DROP COLUMN x; PRAGMA cache_spill = TRUE; ALTER TABLE t2 ADD COLUMN extra_6078 DATE UNIQUE; INSERT INTO t1 VALUES ('x', 'x', NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, ax = excluded.ax, b = excluded.b; SELECT STRING_AGG(cnt, '|') FROM t3; INSERT INTO t3 SELECT * FROM t3; SELECT * FROM t2 WHERE (y) IN (SELECT y FROM t2); ROLLBACK TO sp6872; RELEASE sp6872; ALTER TABLE t1 DROP COLUMN b; SELECT x, (SELECT MIN(x) FROM t2) AS min_val FROM t2; ANALYZE; SELECT COUNT(*) FROM t3; UPDATE t1 SET a = 'x' WHERE a IS NOT NULL RETURNING *; CREATE TEMP VIEW IF NOT EXISTS v_T_8797 AS SELECT a FROM T; INSERT INTO t2 VALUES (NULL, NULL); VACUUM main; SELECT * FROM t1 AS a LEFT OUTER JOIN t2 AS b ON a.rowid = b.rowid; SELECT COUNT(*) FROM t3; ALTER TABLE T RENAME TO T_r1139; UPDATE T SET a = a + 1 WHERE a BETWEEN 0 AND 100 RETURNING *; CREATE INDEX IF NOT EXISTS idx_t3_1555 ON t3((cnt + 1)); DETACH DATABASE aux42; ROLLBACK TRANSACTION TO SAVEPOINT sp8221; RELEASE SAVEPOINT sp8221; SELECT COUNT(cnt) FROM t3; SELECT 0x0ACB29BM205381; SELECT sqlite_compileoption_used('我的天你是怎么了'); SELECT 1 >> -999999999999999999999999999; SELECT sqlite_compileoption_get($1); SELECT sqlite_version(); ROLLBACK TO sp1494; RELEASE sp1494; CREATE UNIQUE INDEX IF NOT EXISTS idx_t3_1306 ON t3(lower(cnt)) WHERE cnt IS NOT NULL; SELECT * FROM t1 CROSS JOIN t1; SELECT * FROM t2 AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; CREATE TRIGGER IF NOT EXISTS trg_t1_7369 AFTER UPDATE ON t1 BEGIN SELECT RAISE(FAIL, 'no'); END; CREATE TEMP VIEW IF NOT EXISTS v_t3_3889 AS SELECT cnt FROM t3; CREATE TEMP VIEW IF NOT EXISTS v_T_9461 AS SELECT a FROM T; ANALYZE; INSERT INTO t2 DEFAULT VALUES; VACUUM main; CREATE TABLE T1 ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL UNIQUE ); CREATE TABLE T2 ( A VARCHAR(10) PRIMARY KEY, X VARCHAR(15) NOT NULL, C BIGINT, FOREIGN KEY (X) REFERENCES T1(A) ); INSERT INTO T1 VALUES ('p', 'x'); INSERT INTO T1 VALUES ('q', 'y'); INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807); INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808); SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X; SELECT LAG(a, 2, a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; DROP TRIGGER IF EXISTS T2; ALTER TABLE t1 RENAME COLUMN b TO b_r1471; END; SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T; SELECT * FROM T1 WHERE B IN (SELECT B FROM T1 t2 WHERE t2.B = T1.B); INSERT INTO t3 VALUES (NULL); INSERT INTO t2 SELECT * FROM t2; ANALYZE; DELETE FROM T2 WHERE 0 RETURNING *; INSERT INTO t2 VALUES (NULL, NULL); INSERT INTO t2 VALUES (1, 1) ON CONFLICT(x) DO UPDATE SET x = excluded.x, y = excluded.y; ALTER TABLE T2 RENAME COLUMN C TO C_r424; ALTER TABLE t2 RENAME TO t2_r5459; WITH RECURSIVE vals(x) AS (SELECT b FROM T WHERE b IS NOT NULL UNION ALL SELECT b FROM T WHERE b IS NOT NULL LIMIT 10) SELECT * FROM vals; PRAGMA user_version = 999; .scanstats est BEGIN EXCLUSIVE TRANSACTION; SAVEPOINT sp1494; .nullvalue NULL32327d3-concat(5)36b-41de-a764-a6301986aeab SAVEPOINT sp8221; ATTACH DATABASE (':memory:' || '') AS aux42; SAVEPOINT sp6872; PRAGMA temp_store_directory; PRAGMA trusted_schema = NO; PRAGMA query_only; .exit .read CREATE TABLE t1(a BLOB, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array('{"a":1,"b":[1,2,3]}') FROM c WHERE NOT +i= 1; CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; CREATE TABLE T1 ( A VARCHAR(20), X VARCHAR(10), PRIMARY KEY (A, X) ); CREATE TABLE T2 ( A VARCHAR(20), Y VARCHAR(10), PRIMARY KEY (A, Y) ); INSERT INTO T1 VALUES ('a', 'm'); INSERT INTO T1 VALUES ('b', 'n'); INSERT INTO T1 VALUES ('c', 'o'); INSERT INTO T2 VALUES ('b', 'k'); SELECT A FROM T1 EXCEPT SELECT A FROM T2; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE a >= 2 ORDER BY b; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(NULL), trim('hello', NULL)))))) UNION ALL SELECT i+json_group_array(1) FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT /* octet_length('你好') */ RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; .read CREATE TABLE t1(a TEXT, ax INTEGER, b INT, PRIMARY KEY(a,ax)) WITHOUT ROWID; WITH RECURSIVE c(i) AS (VALUES(-(-(degrees(round(exp(123.456), 2))))) UNION ALL SELECT i+1 FROM c WHERE i<10) INSERT INTO t1(a,ax,b) SELECT printf('%02x',i+160), random(), i FROM c; CREATE INDEX t1a ON t1(a); CREATE TABLE `t2`(x,y); CREATE TABLE t3(cnt); WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4) INSERT INTO t3(cnt) SELECT i FROM c; SELECT count(*) FROM t1; SELECT COUNT(*) FROM t1; CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_2608 ON t2((y + 1)); SELECT * FROM t1 WHERE b = ANY (SELECT b FROM t1); CREATE TRIGGER IF NOT EXISTS trg_t3_3604 AFTER UPDATE ON t3 BEGIN SELECT RAISE(IGNORE); END; INSERT INTO t3 DEFAULT VALUES; SELECT COUNT(*) FROM t3; SELECT * FROM t2 CROSS JOIN t2; PRAGMA cell_size_check = YES; INSERT INTO t3 SELECT * FROM t3; WITH a AS (SELECT * FROM t1), b AS (SELECT * FROM a), c AS (SELECT * FROM b), d AS (SELECT * FROM c) SELECT * FROM d; CREATE INDEX IF NOT EXISTS idx_t2_3584 ON t2(lower(x)) WHERE x IS NOT NULL; VACUUM; SELECT STRING_AGG(cnt) FROM t3; UPDATE t2 SET y = 31 WHERE rowid = 1 RETURNING *; SELECT * FROM t1 WHERE ax IN (SELECT ALL ax FROM t1); SELECT AVG(ax) FROM t1; UPDATE t2 SET y = NULL; INSERT INTO t2 SELECT * FROM t2; SELECT COUNT(*) FILTER (WHERE x IS NOT NULL), SUM(rowid) FILTER (WHERE x > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(x) FILTER (WHERE x > 0 OR x < 100), COUNT(*) FILTER (WHERE typeof(x) = "text") FROM t2; INSERT INTO t3 DEFAULT VALUES; SELECT * FROM t3 AS a JOIN t2 AS b ON a.rowid = b.rowid; SELECT SUM(ax) FROM t1; REINDEX t2; CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE a >= 2 ORDER BY b; ALTER TABLE t2 RENAME COLUMN x TO x_r564; CREATE TRIGGER IF NOT EXISTS trg_t3_155 AFTER UPDATE OF cnt ON t3 FOR EACH ROW BEGIN INSERT INTO t3(cnt) VALUES (NULL); END; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT * FROM t3) UPDATE t3 SET cnt = (SELECT cnt FROM cte LIMIT 1) WHERE 1=0; ALTER TABLE t2 DROP COLUMN x; PRAGMA cache_spill = TRUE; ALTER TABLE t2 ADD COLUMN extra_6078 DATE UNIQUE; INSERT INTO t1 VALUES ('x', 'x', NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, ax = excluded.ax, b = excluded.b; SELECT STRING_AGG(cnt, '|') FROM t3; INSERT INTO t3 SELECT * FROM t3; SELECT * FROM t2 WHERE (y) IN (SELECT y FROM t2); ROLLBACK TO sp6872; RELEASE sp6872; ALTER TABLE t1 DROP COLUMN b; SELECT x, (SELECT MIN(x) FROM t2) AS min_val FROM t2; ANALYZE; SELECT COUNT(*) FROM t3; UPDATE t1 SET a = 'x' WHERE a IS NOT NULL RETURNING *; CREATE TEMP VIEW IF NOT EXISTS v_T_8797 AS SELECT a FROM T; INSERT INTO t2 VALUES (NULL, NULL); VACUUM main; SELECT * FROM t1 AS a LEFT OUTER JOIN t2 AS b ON a.rowid = b.rowid; SELECT COUNT(*) FROM t3; ALTER TABLE T RENAME TO T_r1139; UPDATE T SET a = a + 1 WHERE a BETWEEN 0 AND 100 RETURNING *; CREATE INDEX IF NOT EXISTS idx_t3_1555 ON t3((cnt + 1)); DETACH DATABASE aux42; ROLLBACK TRANSACTION TO SAVEPOINT sp8221; RELEASE SAVEPOINT sp8221; SELECT COUNT(cnt) FROM t3; SELECT 0x0ACB29BM205381; SELECT sqlite_compileoption_used('我的天你是怎么了'); SELECT 1 >> -999999999999999999999999999; SELECT sqlite_compileoption_get($1); SELECT sqlite_version(); ROLLBACK TO sp1494; RELEASE sp1494; CREATE UNIQUE INDEX IF NOT EXISTS idx_t3_1306 ON t3(lower(cnt)) WHERE cnt IS NOT NULL; SELECT * FROM t1 CROSS JOIN t1; SELECT * FROM t2 AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; CREATE TRIGGER IF NOT EXISTS trg_t1_7369 AFTER UPDATE ON t1 BEGIN SELECT RAISE(FAIL, 'no'); END; CREATE TEMP VIEW IF NOT EXISTS v_t3_3889 AS SELECT cnt FROM t3; CREATE TEMP VIEW IF NOT EXISTS v_T_9461 AS SELECT a FROM T; ANALYZE; INSERT INTO t2 DEFAULT VALUES; VACUUM main; CREATE TABLE T1 ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL UNIQUE ); CREATE TABLE T2 ( A VARCHAR(10) PRIMARY KEY, X VARCHAR(15) NOT NULL, C BIGINT, FOREIGN KEY (X) REFERENCES T1(A) ); INSERT INTO T1 VALUES ('p', 'x'); INSERT INTO T1 VALUES ('q', 'y'); INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807); INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808); SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X; SELECT LAG(a, 2, a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T; DROP TRIGGER IF EXISTS T2; ALTER TABLE t1 RENAME COLUMN b TO b_r1471; END; SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T; SELECT * FROM T1 WHERE B IN (SELECT B FROM T1 t2 WHERE t2.B = T1.B); INSERT INTO t3 VALUES (NULL); INSERT INTO t2 SELECT * FROM t2; ANALYZE; DELETE FROM T2 WHERE 0 RETURNING *; INSERT INTO t2 VALUES (NULL, NULL); INSERT INTO t2 VALUES (1, 1) ON CONFLICT(x) DO UPDATE SET x = excluded.x, y = excluded.y; ALTER TABLE T2 RENAME COLUMN C TO C_r424; ALTER TABLE t2 RENAME TO t2_r5459; WITH RECURSIVE vals(x) AS (SELECT b FROM T WHERE b IS NOT NULL UNION ALL SELECT b FROM T WHERE b IS NOT NULL LIMIT 10) SELECT * FROM vals; UPDATE T2 SET C = json_object('k', C) RETURNING *; CREATE VIEW IF NOT EXISTS v_T_1682 AS SELECT a FROM T; SELECT * FROM t1; SELECT GROUP_CONCAT(y) OVER (ORDER BY y GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM t2; REINDEX t2; DROP INDEX IF EXISTS T2; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<84) SELECT * FROM cnt; CREATE INDEX IF NOT EXISTS idx_T2_3109 ON T2((X + 1)); ALTER TABLE T2 RENAME TO T2_r7045; DETACH DATABASE aux89; VACUUM; REINDEX t3; SELECT COUNT(*) FROM T; UPDATE t2 SET x = CURRENT_TIMESTAMP WHERE 1; SELECT GROUP_CONCAT(cnt) FROM t3; WITH cte AS (SELECT * FROM T1) SELECT * FROM cte JOIN T1 ON cte.A = T1.A; INSERT INTO t2 DEFAULT VALUES; DELETE FROM T WHERE 0 RETURNING *; SELECT * FROM t3; ALTER TABLE t3 DROP COLUMN cnt; INSERT OR ROLLBACK INTO T VALUES (10, 0); SELECT TOTAL(A) FROM T2; CREATE TABLE T ( a INTEGER, b REAL, c REAL ); INSERT INTO T VALUES (1,2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0); WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d; ``` ## Actual output ```sql .dbconfig defensive off dqs_ddl on dqs_dml on enable_fkey off enable_qpsg off enable_trigger on enable_view on fts3_tokenizer off legacy_alter_table off legacy_file_format off load_extension on no_ckpt_on_close off reset_database off trigger_eqp off trusted_schema on writable_schema off PRAGMA vdbe_listing = 1; ATTACH DATABASE ':memory:' AS aux89; PRAGMA user_version = ')'; .scanstats est BEGIN EXCLUSIVE TRANSACTION; SAVEPOINT sp1494; .nullvalue NULL32327d3-concat(5)36b-41de-a764-a6301986aeab SAVEPOINT sp8221; ATTACH DATABASE (':memory:' || '') AS aux42; SAVEPOINT sp6872; PRAGMA temp_store_directory; PRAGMA trusted_schema = NO; PRAGMA query_only; 0 .exit ``` ## Expectation ```sql .dbconfig attach_create on attach_write on comments on defensive on dqs_ddl off dqs_dml off enable_fkey off enable_qpsg off enable_trigger on enable_view on fts3_tokenizer off legacy_alter_table off legacy_file_format off load_extension on no_ckpt_on_close off reset_database off reverse_scanorder off stmt_scanstatus off trigger_eqp off trusted_schema off writable_schema off PRAGMA vdbe_listing = 1; ATTACH DATABASE ':memory:' AS aux89; PRAGMA user_version = ')'; .scanstats est BEGIN EXCLUSIVE TRANSACTION; SAVEPOINT sp1494; .nullvalue NULL32327d3-concat(5)36b-41de-a764-a6301986aeab SAVEPOINT sp8221; ATTACH DATABASE (':memory:' || '') AS aux42; SAVEPOINT sp6872; PRAGMA temp_store_directory; PRAGMA trusted_schema = NO; PRAGMA query_only; 0 .exit ``` ## Flag ``` -echo ```