admin/ast-project
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
ast-project/part1/results/1/bug_8f358b35-e52a-438e-be08-8286b338fa3f_logic.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

1794 lines
74 KiB
Markdown
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
## 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
ATTACH DATABASE ':memory:' AS aux62;
.width 1 2 3
.progress 3
SAVEPOINT sp6691;
.schema
ATTACH DATABASE ':memory:' AS aux19;
-- PRAGMA encoding = 'UTF-16le';
PRAGMA query_only = '>';
PRAGMA case_sensitive_like = NO;
-- PRAGMA checkpoint_fullsync = OFF;
.open random-json.db
PRAGMA journal_mode = 'WAL';
PRAGMA index_info(idx1);
PRAGMA analysis_limit;
BEGIN DEFERRED;
ATTACH DATABASE ':memory:' AS aux66;
.exit jsonb_remove(exp(json_patch((json_remove(if(-(-(json_set(x'05e7ec1070228174d7c828', '$.key', -x'ccb57c'))), likely(timediff(NULL, CAST(json_array_length((-(-(NULL)) * coalesce(NULL, NULL, NULL)), '$') AS CHARACTER(-0)))timediff(NULL, NULL))/cos(octet_length(sqlite_compileoption_get(-sin(x'f5ee330d')))), 0)) + 9999), '{"key": null}')), '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SEleCt b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
CREATE TABLE T (
A VARCHAR(15) PRIMARY KEY,
B VARCHAR(30) NOT NULL,
C BIGINT UNIQUE
);
INSERT INTO T VALUES ('a', 'x', -9223372036854775808);
INSERT INTO T VALUES ('b', 'y', -1000000);
INSERT INTO T VALUES ('c', 'y', 0);
INSERT INTO T VALUES ('d', 'y', 42);
INSERT INTO T VALUES ('e', 'x', 9223372036854775807);
INSERT INTO T VALUES ('f', 'z', 2147483648);
SELECT * FROM T WHERE C > 0 ORDER BY C DESC;
UPDATE T SET b == '' WHERE NOT NOT NOT (NOT NOT (rowid = 1)) ;
SELECT TOTAL(b) FROM T;
INSERT AND ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIn T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
DROP TABLE t0;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
SELECT * FROM (SELECT * FROM T) AS t1 JOIN (SELECT * FROM T) AS t2 ON t1.a = t2.a;
DROP INDEX IF EXISTS T;
DETACH DATABASE aux66;
WITH RECURSIVE multi(a, b) AS (VALUES(1, 1.0) UNION ALL SELECT a+1, b*0.5 FROM multi WHERE a<99) SELECT * FROM multi;
COMMIT;
CREATE TEMP VIEW IF NOT EXISTS v_T_1870 AS SELECT a FROM T;
VACUUM;
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
CREATE TABLE T (
a TEXT,
b TEXT,
c REAL
);
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
INSERT INTO T VALUES (1, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
REINDEX T;
UPDATE T SET a = 'x';
CREATE UNIQUE INDEX IF NOT EXISTS idx_T_6537 ON T((b + 1));
INSERT INTO T SELECT * FROM T;
UPDATE T SET c = 45 WHERE c BETWEEN 0 AND 100;
CREATE TABLE T1 (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) UNIQUE,
C INTEGER
);
CREATE TABLE T2 (
X VARCHAR(20) PRIMARY KEY,
A VARCHAR(10) NOT NULL UNIQUE,
FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', -2147483648);
INSERT INTO T1 VALUES ('b', 'q', 2147483647);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.B, T1.C FROM T2, T1 WHERE T2.A = T1.A AND T1.C >= 0;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT COUNT(*) FROM T1;
SELECT * FROM T AS a LEFT JOIN T1 AS b ON a.rowid = b.rowid;
INSERT INTO T1 DEFAULT VALUES;
SELECT * FROM T;
PRAGMA analysis_limit;
BEGIN DEFERRED;
ATTACH DATABASE ':memory:' AS aux66;
.exit jsonb_remove(exp(json_patch((json_remove(if(-(-(0)), 1/0, 0)) + 9999), '{"key": null}')), '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b == '' WHERE NOT NOT (rowid = 1) ;
SELECT TOTAL(b) FROM T;
INSERT or ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
SELECT * FROM (SELECT * FROM T) AS t1 JOIN (SELECT * FROM T) AS t2 ON t1.a = t2.a;
DROP INDEX IF EXISTS T;
DETACH DATABASE aux66;
WITH RECURSIVE multi(a, b) AS (VALUES(1, 1.0) UNION ALL SELECT a+1, b*0.5 FROM multi WHERE a<99) SELECT * FROM multi;
COMMIT;
CREATE TEMP VIEW IF NOT EXISTS v_T_1870 AS SELECT a FROM T;
VACUUM;
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
CREATE TABLE T (
a TEXT,
b TEXT,
c REAL
);
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
INSERT INTO T VALUES (1, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
REINDEX T;
UPDATE T SET a = 'x';
CREATE UNIQUE INDEX IF NOT EXISTS idx_T_6537 ON T((b + 1));
INSERT INTO T SELECT * FROM T;
UPDATE T SET c = 45 WHERE c BETWEEN 0 AND 100;
CREATE TABLE T1 (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) UNIQUE,
C INTEGER
);
CREATE TABLE T2 (
X VARCHAR(20) PRIMARY KEY,
A VARCHAR(10) NOT NULL UNIQUE,
FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', -2147483648);
INSERT INTO T1 VALUES ('b', 'q', 2147483647);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.B, T1.C FROM T2, T1 WHERE T2.A = T1.A AND T1.C >= 0;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT COUNT(*) FROM T1;
SELECT * FROM T AS a LEFT JOIN T1 AS b ON a.rowid = b.rowid;
INSERT INTO T1 DEFAULT VALUES;
SELECT * FROM T;
PRAGMA analysis_limit;
BEGIN DEFERRED;
ATTACH DATABASE ':memory:' AS aux66;
.exit jsonb_remove(exp(json_patch((json_remove(if(-(-(0)), 1/0, 0)) + 9999), '{"key": null}')), '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b == '' WHERE NOT NOT (rowid = 1) ;
SELECT TOTAL(b) FROM T;
INSERT or ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
SELECT * FROM (SELECT * FROM T) AS t1 JOIN (SELECT * FROM T) AS t2 ON t1.a = t2.a;
DROP INDEX IF EXISTS T;
DETACH DATABASE aux66;
WITH RECURSIVE multi(a, b) AS (VALUES(1, 1.0) UNION ALL SELECT a+1, b*0.5 FROM multi WHERE a<99) SELECT * FROM multi;
COMMIT;
CREATE TEMP VIEW IF NOT EXISTS v_T_1870 AS SELECT a FROM T;
VACUUM;
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
CREATE TABLE T (
a TEXT,
b TEXT,
c REAL
);
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
INSERT INTO T VALUES (1, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
REINDEX T;
UPDATE T SET a = 'x';
CREATE UNIQUE INDEX IF NOT EXISTS idx_T_6537 ON T((b + 1));
INSERT INTO T SELECT * FROM T;
UPDATE T SET c = 45 WHERE c BETWEEN 0 AND 100;
CREATE TABLE T1 (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) UNIQUE,
C INTEGER
);
CREATE TABLE T2 (
X VARCHAR(20) PRIMARY KEY,
A VARCHAR(10) NOT NULL UNIQUE,
FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', -2147483648);
INSERT INTO T1 VALUES ('b', 'q', 2147483647);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.B, T1.C FROM T2, T1 WHERE T2.A = T1.A AND T1.C >= 0;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT COUNT(*) FROM T1;
SELECT * FROM T AS a LEFT JOIN T1 AS b ON a.rowid = b.rowid;
INSERT INTO T1 DEFAULT VALUES;
SELECT * FROM T;
PRAGMA analysis_limit;
BEGIN DEFERRED;
ATTACH DATABASE ':memory:' AS aux66;
.exit jsonb_remove(exp(json_patch((json_remove(if(-(-(0)), 1/0, 0)) + 9999), '{"key": null}')), '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b == '' WHERE NOT NOT (rowid = 1) ;
SELECT TOTAL(b) FROM T;
INSERT or ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
SELECT * FROM (SELECT * FROM T) AS t1 JOIN (SELECT * FROM T) AS t2 ON t1.a = t2.a;
DROP INDEX IF EXISTS T;
DETACH DATABASE aux66;
WITH RECURSIVE multi(a, b) AS (VALUES(1, 1.0) UNION ALL SELECT a+1, b*0.5 FROM multi WHERE a<99) SELECT * FROM multi;
COMMIT;
CREATE TEMP VIEW IF NOT EXISTS v_T_1870 AS SELECT a FROM T;
VACUUM;
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
CREATE TABLE T (
a TEXT,
b TEXT,
c REAL
);
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
INSERT INTO T VALUES (1, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
REINDEX T;
UPDATE T SET a = 'x';
CREATE UNIQUE INDEX IF NOT EXISTS idx_T_6537 ON T((b + 1));
INSERT INTO T SELECT * FROM T;
UPDATE T SET c = 45 WHERE c BETWEEN 0 AND 100;
CREATE TABLE T1 (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) UNIQUE,
C INTEGER
);
CREATE TABLE T2 (
X VARCHAR(20) PRIMARY KEY,
A VARCHAR(10) NOT NULL UNIQUE,
FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', -2147483648);
INSERT INTO T1 VALUES ('b', 'q', 2147483647);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.B, T1.C FROM T2, T1 WHERE T2.A = T1.A AND T1.C >= 0;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT COUNT(*) FROM T1;
SELECT * FROM T AS a LEFT JOIN T1 AS b ON a.rowid = b.rowid;
INSERT INTO T1 DEFAULT VALUES;
SELECT * FROM T;
PRAGMA analysis_limit;
BEGIN DEFERRED;
ATTACH DATABASE ':memory:' AS aux66;
.exit jsonb_remove(exp(json_patch((json_remove(if(-(-(0)), 1/0, 0)) + 9999), '{"key": null}')), '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b == '' WHERE NOT NOT (rowid = 1) ;
SELECT TOTAL(b) FROM T;
INSERT or ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
.exit jsonb_remove(9999, '$.key')
SAVEPOINT sp3629;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES ((jsonb_object('k', 1) * 1),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
UPDATE T SET b = '' WHERE rowid = 1;
SELECT TOTAL(b) FROM T;
INSERT OR ABORT INTO T VALUES ('', NULL, 'x');
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
CREATE TEMP VIEW IF NOT EXISTS v_T_8716 AS SELECT b FROM T;
ROLLBACK TO sp3629;
RELEASE sp3629;
ALTER TABLE T DROP COLUMN b;
ANALYZE /* jsonb_array({v}) */ T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA hard_heap_limit = 50000000;
SELECT * FROM T AS a LEFT JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_1002 DOUB DEFAULT NULL;
SELECT * FROM T WHERE b = (SELECT COUNT(*) FROM T);
INSERT INTO T SELECT * FROM T;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b);
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
PRAGMA read_uncommitted = TRUE;
SELECT SUM(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T DEFAULT VALUES;
SELECT MAX(a) FROM T;
SELECT * FROM (SELECT * FROM T) AS t1 JOIN (SELECT * FROM T) AS t2 ON t1.a = t2.a;
DROP INDEX IF EXISTS T;
DETACH DATABASE aux66;
WITH RECURSIVE multi(a, b) AS (VALUES(1, 1.0) UNION ALL SELECT a+1, b*0.5 FROM multi WHERE a<99) SELECT * FROM multi;
COMMIT;
CREATE TEMP VIEW IF NOT EXISTS v_T_1870 AS SELECT a FROM T;
VACUUM;
SELECT COUNT(*) FILTER (WHERE c IS NOT NULL), SUM(rowid) FILTER (WHERE c > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c) FILTER (WHERE c > 0 AND c < 100), COUNT(*) FILTER (WHERE typeof(c) = "text") FROM T;
CREATE TABLE T (
a TEXT,
b TEXT,
c REAL
);
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
SELECT a,b,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
INSERT INTO T VALUES (1, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
REINDEX T;
UPDATE T SET a = 'x';
CREATE UNIQUE INDEX IF NOT EXISTS idx_T_6537 ON T((b + 1));
INSERT INTO T SELECT * FROM T;
UPDATE T SET c = 45 WHERE c BETWEEN 0 AND 100;
CREATE TABLE T1 (
A VARCHAR(10) PRIMARY KEY,
B VARCHAR(15) UNIQUE,
C INTEGER
);
CREATE TABLE T2 (
X VARCHAR(20) PRIMARY KEY,
A VARCHAR(10) NOT NULL UNIQUE,
FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', -2147483648);
INSERT INTO T1 VALUES ('b', 'q', 2147483647);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.B, T1.C FROM T2, T1 WHERE T2.A = T1.A AND T1.C >= 0;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT COUNT(*) FROM T1;
SELECT * FROM T AS a LEFT JOIN T1 AS b ON a.rowid = b.rowid;
INSERT INTO T1 DEFAULT VALUES;
SELECT * FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
ALTER TABLE T1 RENAME TO T1_r7888;
INSERT INTO T VALUES (1, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
VACUUM;
SELECT * FROM T2 AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T1 RENAME COLUMN A TO A_r1257;
INSERT OR REPLACE INTO T1 VALUES ('x', 0, '');
WITH cte AS (SELECT A FROM T2) SELECT * FROM cte;
CREATE TEMPORARY VIEW IF NOT EXISTS v_T_595 AS SELECT c FROM T;
PRAGMA writable_schema = 1;
SELECT COUNT(*) FROM T;
SELECT A, (SELECT MIN(A) FROM T2) AS min_val FROM T2;
SELECT * FROM T;
PRAGMA vdbe_trace = 0;
INSERT INTO T1 SELECT * FROM T1;
SELECT * FROM T CROSS JOIN T;
DELETE FROM T2 WHERE rowid = 48 RETURNING *;
INSERT INTO T VALUES (NULL, NULL, NULL);
CREATE TEMP VIEW IF NOT EXISTS v_T_9407 AS SELECT b FROM T;
ALTER TABLE T2 ADD COLUMN extra_5922 SMALLINT COLLATE RTRIM;
DETACH DATABASE aux19;
PRAGMA writable_schema = RESET;
PRAGMA parser_trace = NO;
WITH RECURSIVE fib(a,b) AS (VALUES(1,1) UNION ALL SELECT b, a+b FROM fib WHERE b<1000) SELECT a FROM fib;
ALTER TABLE T DROP COLUMN a;
ANALYZE T2;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<56), filtered AS (SELECT * FROM cnt WHERE x > 28) SELECT * FROM filtered;
SELECT LAG(c, 2, c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
SELECT * FROM (SELECT * FROM T1) AS sub;
INSERT INTO T2 SELECT * FROM T2;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<50) SELECT SUM(x) FROM cnt;
VACUUM main;
SELECT COUNT(*) FROM T1;
INSERT INTO T VALUES (NULL, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
ANALYZE;
PRAGMA recursive_triggers = FALSE;
ALTER TABLE T2 DROP COLUMN A;
CREATE INDEX IF NOT EXISTS idx_T1_8687 ON T1(B COLLATE NOCASE);
SELECT COUNT(*) FROM T1;
SELECT COUNT(*) FROM T1;
CREATE VIEW IF NOT EXISTS v_T1_7545 AS SELECT C FROM T1;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T);
ALTER TABLE T1 RENAME TO T1_r3037;
SELECT STRING_AGG(B, '|') FROM T1;
INSERT INTO T VALUES (1, 'x', NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
ALTER TABLE T ADD COLUMN extra_2569 DATETIME DEFAULT CURRENT_TIMESTAMP;
VACUUM main;
PRAGMA full_column_names = 1;
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 T2;
INSERT INTO T2 SELECT * FROM T2;
SELECT COUNT(*) FROM T;
CREATE TABLE T (
a INTEGER,
b TEXT,
c REAL
);
INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0);
SELECT * FROM T WHERE c < 2.0 ORDER BY c;
SELECT TOTAL(A) FROM T1;
INSERT INTO T2 VALUES ('x', 1) ON CONFLICT(X) DO UPDATE SET X = excluded.X, A = excluded.A;
INSERT OR ROLLBACK INTO T1 VALUES (-10, '', 0);
UPDATE T2 SET A = json_object('k', A) WHERE A BETWEEN 0 AND 100;
INSERT INTO T1 VALUES (NULL, 1, 'x') ON CONFLICT(A) DO UPDATE SET A = excluded.A, B = excluded.B, C = excluded.C;
RELEASE sp6691;
CREATE TEMPORARY VIEW IF NOT EXISTS v_T2_9665 AS SELECT A FROM T2;
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 T2;
SELECT * FROM T2 WHERE A = (SELECT SUM(A) FROM T2);
SELECT * FROM T1 AS a RIGHT OUTER JOIN T2 AS b ON a.rowid = b.rowid;
SELECT COUNT(*) FROM T;
INSERT INTO T2 DEFAULT VALUES;
UPDATE T1 SET C = 'x' WHERE C BETWEEN 0 AND 100;
INSERT INTO T1 VALUES (1, 'x', 1) ON CONFLICT(A) DO UPDATE SET A = excluded.A, B = excluded.B, C = excluded.C;
DETACH DATABASE aux62;
DROP INDEX IF EXISTS T2;
INSERT INTO T2 SELECT * FROM T2;
ANALYZE;
```
## Actual output
```sql
Progress 1
Progress 2
Progress 3
Progress 4
Progress 5
Progress 6
Progress 7
Progress 8
Progress 9
Progress 10
Progress 11
Progress 12
Progress 13
Progress 14
Progress 15
Progress 16
Progress 17
Progress 18
Progress 19
Progress 20
wal
0
```
## Expectation
```sql
Progress 1
Progress 2
Progress 3
Progress 4
Progress 5
Progress 6
Progress 7
Progress 8
Progress 9
Progress 10
Progress 11
Progress 12
Progress 13
Progress 14
Progress 15
Progress 16
Progress 17
Progress 18
Progress 19
Progress 20
Progress 21
Progress 22
wal
0
```
## Flag
```
-nullvalue "NU11"
```
Reference in New Issue View Git Blame Copy Permalink