admin/ast-project
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
ast-project/part1/results/3/bug_7733e175-71b9-4d03-acb8-bc2b1a19e34b_logic.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

1207 lines
40 KiB
Markdown
Raw Permalink Blame History

## Summary
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
## Minimized query
```sql
PRAGMA wal_checkpoint('RESTART');
ATTACH DATABASE ':memory:' AS aux49;
ATTACH DATABASE ':memory:' AS aux83;
-- nullif({v}, NULL)
SAVEPOINT sp9100;
-- .progress 3
.separator >_<
PRAGMA automatic_index = x'd70a7d030c6017';
-- >
ATTACH DATABASE '' || (':memory:') AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(lower(NULL), ' '));
INSERT INTO t8a VALUES('two', x'94885576523c9b01c4fc9fb4c8f7e470');
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(sinh(soundex('Rupert')),(log(x'5499cb73', 0) + 111));
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
ATTACH DATABASE ':memory:' AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
INSERT INTO T SELECT * FROM T;
CREATE TABLE T1 (
A VARCHAR(20),
X VARCHAR(10),
PRIMARY KEY (A, X),
UNIQUE (X)
);
CREATE TABLE T2 (
A VARCHAR(20),
Y VARCHAR(10) UNIQUE,
PRIMARY KEY (A, Y)
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T2 VALUES ('b', 'k');
SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A;
PRAGMA parser_trace = NO;
ANALYZE;
.separator >_<
PRAGMA automatic_index = 1;
ATTACH DATABASE '' || (':memory:') AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
ATTACH DATABASE ':memory:' AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
INSERT INTO T SELECT * FROM T;
CREATE TABLE T1 (
A VARCHAR(20),
X VARCHAR(10),
PRIMARY KEY (A, X),
UNIQUE (X)
);
CREATE TABLE T2 (
A VARCHAR(20),
Y VARCHAR(10) UNIQUE,
PRIMARY KEY (A, Y)
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T2 VALUES ('b', 'k');
SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A;
PRAGMA parser_trace = NO;
ANALYZE;
.separator >_<
PRAGMA automatic_index = 1;
ATTACH DATABASE '' || (':memory:') AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
ATTACH DATABASE ':memory:' AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
INSERT INTO T SELECT * FROM T;
CREATE TABLE T1 (
A VARCHAR(20),
X VARCHAR(10),
PRIMARY KEY (A, X),
UNIQUE (X)
);
CREATE TABLE T2 (
A VARCHAR(20),
Y VARCHAR(10) UNIQUE,
PRIMARY KEY (A, Y)
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T2 VALUES ('b', 'k');
SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A;
PRAGMA parser_trace = NO;
ANALYZE;
.separator >_<
PRAGMA automatic_index = 1;
ATTACH DATABASE '' || (':memory:') AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
ATTACH DATABASE ':memory:' AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
INSERT INTO T SELECT * FROM T;
CREATE TABLE T1 (
A VARCHAR(20),
X VARCHAR(10),
PRIMARY KEY (A, X),
UNIQUE (X)
);
CREATE TABLE T2 (
A VARCHAR(20),
Y VARCHAR(10) UNIQUE,
PRIMARY KEY (A, Y)
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T2 VALUES ('b', 'k');
SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A;
PRAGMA parser_trace = NO;
ANALYZE;
.separator >_<
PRAGMA automatic_index = 1;
ATTACH DATABASE '' || (':memory:') AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
ATTACH DATABASE ':memory:' AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
CREATE TABLE T (
A VARCHAR(20),
B VARCHAR(10),
PRIMARY KEY (A, B)
);
INSERT INTO T VALUES ('a', 'p');
INSERT INTO T VALUES ('a', 'q');
INSERT INTO T VALUES ('b', 'q');
INSERT INTO T VALUES ('c', 'r');
INSERT INTO T VALUES ('b', 'r');
INSERT INTO T VALUES ('b', 't');
SELECT B, COUNT(DISTINCT A) AS D FROM T GROUP BY B ORDER BY D DESC, B ASC;
INSERT INTO T SELECT * FROM T;
CREATE TABLE T1 (
A VARCHAR(20),
X VARCHAR(10),
PRIMARY KEY (A, X),
UNIQUE (X)
);
CREATE TABLE T2 (
A VARCHAR(20),
Y VARCHAR(10) UNIQUE,
PRIMARY KEY (A, Y)
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T2 VALUES ('b', 'k');
SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A;
PRAGMA parser_trace = NO;
ANALYZE;
.separator >_<
PRAGMA automatic_index = 1;
ATTACH DATABASE '' || (':memory:') AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
ATTACH DATABASE ':memory:' AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
INSERT INTO T SELECT * FROM T;
CREATE TABLE T1 (
A VARCHAR(20),
X VARCHAR(10),
PRIMARY KEY (A, X),
UNIQUE (X)
);
CREATE TABLE T2 (
A VARCHAR(20),
Y VARCHAR(10) UNIQUE,
PRIMARY KEY (A, Y)
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T2 VALUES ('b', 'k');
SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A;
PRAGMA parser_trace = NO;
ANALYZE;
.separator >_<
PRAGMA automatic_index = 1;
ATTACH DATABASE '' || (':memory:') AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
ATTACH DATABASE ':memory:' AS aux97;
.cd
.prompt
.eqp auto
BEGIN DEFERRED TRANSACTION;
-- PRAGMA vdbe_debug = TRUE;
CREATE TABLE t8a(a,b);
CREATE TABLE t8b(x);
INSERT INTO t8a VALUES('one', -(-(glob('1', 'hello'))));
INSERT INTO t8a VALUES('one', json_pretty(2, ' '));
INSERT INTO t8a VALUES('two', 3);
INSERT INTO t8a VALUES('one', NULL);
INSERT INTO t8b(rowid,x) VALUES(1,111);
CREATE TABLE T (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) NOT NULL,
C DOUBLE PRECISION
);
INSERT INTO T VALUES ('a', 'p', -1.7976931348623157e+308);
INSERT INTO T VALUES ('b', 'q', -0.000000001);
INSERT INTO T VALUES ('c', 'r', 0.0);
INSERT INTO T VALUES ('d', 's', 3.14159265358979);
INSERT INTO T VALUES ('e', 't', 1.7976931348623157e+308);
INSERT INTO T VALUES ('f', 't', 750.25);
SELECT B, AVG(C) AS D, MIN(C) AS E, MAX(C) AS F FROM T GROUP BY B;
INSERT INTO t8b(rowid,x) VALUES(2,222);
INSERT INTO t8b(rowid,x) VALUES(3,333);
SELECT a, count(b) FROM t8a, t8b WHERE +b!=t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b=+t8b.rowid GROUP BY a ORDER BY a;
SELECT a, count(b) FROM t8a, t8b WHERE b<x GROUP BY a ORDER BY a;
SELECT * FROM t8b AS a RIGHT JOIN t8b AS b ON a.rowid = b.rowid;
DELETE FROM t8a WHERE rowid = 34;
END;
SELECT * FROM t8a AS a FULL OUTER JOIN t8b AS b ON a.rowid = b.rowid;
ANALYZE T;
SELECT * FROM t8a AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b SELECT * FROM t8b;
INSERT INTO t8b VALUES (NULL);
CREATE TRIGGER IF NOT EXISTS trg_t8a_4474 BEFORE UPDATE OF b ON t8a BEGIN INSERT INTO t8a(b) VALUES (NULL); END;
CREATE TABLE T1 (
a INTEGER,
b TEXT
);
CREATE TABLE T2 (
a INTEGER,
b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
SELECT GROUP_CONCAT(b,',')
FROM T2
WHERE T2.a=T1.a
) AS c
FROM T1;
UPDATE t8b SET x = x + 1 WHERE x IS NOT NULL;
WITH cte AS (SELECT * FROM t8a) SELECT * FROM cte LEFT JOIN t8a ON cte.a = t8a.a;
CREATE INDEX IF NOT EXISTS idx_t8b_9299 ON t8b((x + 1)) WHERE x > 0;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_647 AS SELECT a FROM T1;
SELECT AVG(a) FROM T1;
WITH cte AS (SELECT * FROM T1) SELECT * FROM cte c1 JOIN cte c2 ON c1.b = c2.b;
INSERT INTO T1 VALUES (NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT GROUP_CONCAT(b) FROM T1;
DETACH DATABASE aux97;
SELECT * FROM t8a CROSS JOIN T;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
INSERT INTO T SELECT * FROM T;
CREATE TABLE T1 (
A VARCHAR(20),
X VARCHAR(10),
PRIMARY KEY (A, X),
UNIQUE (X)
);
CREATE TABLE T2 (
A VARCHAR(20),
Y VARCHAR(10) UNIQUE,
PRIMARY KEY (A, Y)
);
INSERT INTO T1 VALUES ('a', 'm');
INSERT INTO T1 VALUES ('b', 'n');
INSERT INTO T2 VALUES ('b', 'k');
SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A;
PRAGMA parser_trace = NO;
ANALYZE;
SELECT * FROM t8a AS a FULL JOIN t8a AS b ON a.rowid = b.rowid;
ROLLBACK TO sp9100;
RELEASE sp9100;
SELECT Y FROM T2 UNION SELECT Y FROM (SELECT * FROM T2) AS sub;
CREATE TEMP VIEW IF NOT EXISTS v_t8a_9991 AS SELECT b FROM t8a;
VACUUM;
SELECT PERCENT_RANK() OVER (ORDER BY A RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T2;
ALTER TABLE t8b RENAME COLUMN x TO x_r3867;
INSERT INTO t8b VALUES ('x') ON CONFLICT(x) DO UPDATE SET x = excluded.x;
ALTER TABLE t8a RENAME COLUMN a TO a_r820;
INSERT INTO t8a VALUES (1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
DROP TRIGGER IF EXISTS T2;
SELECT * FROM t8b;
DELETE FROM t8b WHERE 1;
creATE VIRTUAL TABLE t0 USING fts3("x", "y", "z");
DROP TABLE t0;
CREATE TEMPORARY VIEW IF NOT EXISTS v_T_6660 AS SELECT B FROM T;
DELETE FROM T2 WHERE rowid = 51;
DELETE FROM T2 WHERE A IS NULL RETURNING *;
SELECT COUNT(*) FROM T;
INSERT INTO t8b SELECT * FROM t8b;
DETACH DATABASE aux83;
SELECT SUM(C) FILTER (WHERE C > 0) OVER (ORDER BY C RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM T;
DETACH DATABASE aux49;
CREATE TEMPORARY VIEW IF NOT EXISTS v_T1_6168 AS SELECT A FROM T1;
INSERT INTO t0 VALUES (1, 1, NULL) ON CONFLICT(x) DO UPDATE SET x = excluded.x, y = excluded.y, z = excluded.z;
WITH n AS NOT MATERIALIZED (SELECT A FROM T2) SELECT * FROM n;
SELECT * FROM t8a;
INSERT INTO t8b VALUES (NULL);
WITH cte AS (SELECT "123" AS x) SELECT x + 0 FROM cte;
REINDEX t8a;
SELECT * FROM T2 AS a LEFT OUTER JOIN t8b AS b ON a.rowid = b.rowid;
CREATE TRIGGER IF NOT EXISTS trg_T_4445 AFTER DELETE ON T FOR EACH ROW BEGIN INSERT INTO T(C) VALUES (NULL); END;
ALTER TABLE t8a ADD COLUMN extra_7317 NCHAR(55);
ANALYZE T;
ANALYZE;
ALTER TABLE T2 RENAME COLUMN Y TO Y_r3830;
```
## Actual output
```sql
3.39.0 2022-05-10 23:28:12 764b71267e0b31ff7eaf2a0def7526a1a02dce4d5b456dea060d97ed342ealt1
```
## Expectation
```sql
3.51.1 2025-11-28 17:28:25 281fc0e9afc38674b9b0991943b9e9d1e64c6cbdb133d35f6f5c87ff6af38a88 (64-bit)
```
## Flag
```
-version
```
Reference in New Issue View Git Blame Copy Permalink