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_a0aafcd0-e770-4878-a376-88b6cd9875a8_unexpected_error.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

46 KiB
Raw Permalink Blame History

Summary

**No review yet**

Minimized query

PRAGMA read_uncommitted = 1;
.once log.txt
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
DROP TABLE t0;
PRAGMA writable_schema = ON;
BEGIN DEFERRED;
-- json_remove({v}, '$.key', '$[0]')

-- SUM

.import corrupt001.db main
PRAGMA empty_result_callbacks = TRUE;
.width
CREATE TABLE [t1](a DOUB PRIMARY KEY, b TEXT, c INT, d INT);
-- substr({v}, 100)

INSERT INTO t1 VALUES (unixepoch((abs('123') + CAST(sin(round(concat_ws('|', 'a', NULL, 'b'))) AS ANY))) ->> '$.key', 'Wernher', sign(randomblob(unistr('Test\u0041\u0042'))), iif(x'20ca', json_object('k', json(json_extract(strftime('%s', (jsonb_array(((0 - 0) + 100)) + 0.0)), '$.key', '$[0]'))), 100));
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2

SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE NOT NOT (NOT NOT NOT (NOT NOT (NOT +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123))) ;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT /**/ COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t3 VALUES ('x', 'x') ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
UPDATE t3 SET c4 = -47;
INSERT INTO t1 SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t2_7080 BEFORE INSERT ON t2 BEGIN SELECT RAISE(ABORT, 'abort'); END;
CREATE  INDEX IF NOT EXISTS idx_t2_2305 ON t2((c2 + 1)) WHERE c2 IS NOT NULL;
ALTER TABLE t1 DROP COLUMN c1;
INSERT INTO t3 VALUES (NULL, 1) ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
ALTER TABLE t2 RENAME TO t2_r5897;
CREATE TRIGGER IF NOT EXISTS trg_t3_1559 BEFORE UPDATE OF c3 ON t3 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1;
WITH cte AS (SELECT c2, ROW_NUMBER() OVER (ORDER BY c2) AS rn FROM t2) SELECT * FROM cte WHERE rn <= 5;
.width
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (unixepoch(1) ->> '$.key', 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2

SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE NOT +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
CREATE TEMPORARY TABLE t0(x, y, z);
SELECT -99999999999999999999999999999999999999999999999999;
SELECT * FROM sqlite_temp_master WHERE sql GLOB '000[]***';
DROP TABLE t0;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t3 VALUES ('x', 'x') ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
UPDATE t3 SET c4 = -47;
INSERT INTO t1 SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t2_7080 BEFORE INSERT ON t2 BEGIN SELECT RAISE(ABORT, 'abort'); END;
CREATE  INDEX IF NOT EXISTS idx_t2_2305 ON t2((c2 + 1)) WHERE c2 IS NOT NULL;
ALTER TABLE t1 DROP COLUMN c1;
INSERT INTO t3 VALUES (NULL, 1) ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
ALTER TABLE t2 RENAME TO t2_r5897;
CREATE TRIGGER IF NOT EXISTS trg_t3_1559 BEFORE UPDATE OF c3 ON t3 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1;
WITH cte AS (SELECT c2, ROW_NUMBER() OVER (ORDER BY c2) AS rn FROM t2) SELECT * FROM cte WHERE rn <= 5;
.width
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (unixepoch(1) ->> '$.key', 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2

SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE NOT +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t3 VALUES ('x', 'x') ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
UPDATE t3 SET c4 = -47;
INSERT INTO t1 SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t2_7080 BEFORE INSERT ON t2 BEGIN SELECT RAISE(ABORT, 'abort'); END;
CREATE  INDEX IF NOT EXISTS idx_t2_2305 ON t2((c2 + 1)) WHERE c2 IS NOT NULL;
ALTER TABLE t1 DROP COLUMN c1;
INSERT INTO t3 VALUES (NULL, 1) ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
ALTER TABLE t2 RENAME TO t2_r5897;
CREATE TRIGGER IF NOT EXISTS trg_t3_1559 BEFORE UPDATE OF c3 ON t3 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1;
WITH cte AS (SELECT c2, ROW_NUMBER() OVER (ORDER BY c2) AS rn FROM t2) SELECT * FROM cte WHERE rn <= 5;
.width
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (unixepoch(1) ->> '$.key', 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2

SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE NOT +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t3 VALUES ('x', 'x') ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
UPDATE t3 SET c4 = -47;
INSERT INTO t1 SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t2_7080 BEFORE INSERT ON t2 BEGIN SELECT RAISE(ABORT, 'abort'); END;
CREATE  INDEX IF NOT EXISTS idx_t2_2305 ON t2((c2 + 1)) WHERE c2 IS NOT NULL;
ALTER TABLE t1 DROP COLUMN c1;
INSERT INTO t3 VALUES (NULL, 1) ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
ALTER TABLE t2 RENAME TO t2_r5897;
CREATE TRIGGER IF NOT EXISTS trg_t3_1559 BEFORE UPDATE OF c3 ON t3 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1;
WITH cte AS (SELECT c2, ROW_NUMBER() OVER (ORDER BY c2) AS rn FROM t2) WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM cte WHERE rn <= 5;
.width
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (unixepoch(1) ->> '$.key', 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE TABLE T (
  A VARCHAR(20),
  B VARCHAR(10),
  C INTEGER,
  PRIMARY KEY (A, B)
);
INSERT INTO T VALUES ('a', 'p', -2147483648);
INSERT INTO T VALUES ('b', 'q', 100);
INSERT INTO T VALUES ('b', 'r', 200);
INSERT INTO T VALUES ('c', 's', 300);
INSERT INTO T VALUES ('d', 't', 2147483647);
INSERT INTO T VALUES ('b', 't', 50);
SELECT A, COUNT(*) AS D, SUM(C) AS E FROM T GROUP BY A HAVING COUNT(*) > 1;
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2

SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE NOT +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t3 VALUES ('x', 'x') ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
UPDATE t3 SET c4 = -47;
INSERT INTO t1 SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t2_7080 BEFORE INSERT ON t2 BEGIN SELECT RAISE(ABORT, 'abort'); END;
CREATE  INDEX IF NOT EXISTS idx_t2_2305 ON t2((c2 + 1)) WHERE c2 IS NOT NULL;
ALTER TABLE t1 DROP COLUMN c1;
INSERT INTO t3 VALUES (NULL, 1) ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
ALTER TABLE t2 RENAME TO t2_r5897;
CREATE TRIGGER IF NOT EXISTS trg_t3_1559 BEFORE UPDATE OF c3 ON t3 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1;
WITH cte AS (SELECT c2, ROW_NUMBER() OVER (ORDER BY c2) AS rn FROM t2) SELECT * FROM cte WHERE rn <= 5;
.width
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (unixepoch(1) ->> '$.key', 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2

SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE NOT +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t3 VALUES ('x', 'x') ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
UPDATE t3 SET c4 = -47;
INSERT INTO t1 SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t2_7080 BEFORE INSERT ON t2 BEGIN SELECT RAISE(ABORT, 'abort'); END;
CREATE  INDEX IF NOT EXISTS idx_t2_2305 ON t2((c2 + 1)) WHERE c2 IS NOT NULL;
ALTER TABLE t1 DROP COLUMN c1;
INSERT INTO t3 VALUES (NULL, 1) ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
ALTER TABLE t2 RENAME TO t2_r5897;
CREATE TRIGGER IF NOT EXISTS trg_t3_1559 BEFORE UPDATE OF c3 ON t3 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1;
WITH cte AS (SELECT c2, ROW_NUMBER() OVER (ORDER BY c2) AS rn FROM t2) SELECT * FROM cte WHERE rn <= 5;
.width
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (unixepoch(1) ->> '$.key', 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2

SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE NOT +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE	VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
((PRAGMA)) case_sensitive_like = FALSE;
PRAGMA synchronous = 'NORMAL';
PRAGMA parser_trace = YES;
.progress log(-(-(-(-(NULL)))), 3)
CREATE TABLE t1(c1);
INSERT INTO t1 VALUES(12),(123),(1234),(NULL),('abc');
CREATE TABLE t2(c2);
INSERT INTO t2 VALUES(44),(55),(123);
CREATE TABLE t3(c3,c4);
INSERT INTO t3 VALUES(66,1),(123,2),(77,3);
CREATE VIEW t4 AS SELECT c3 FROM t3;
CREATE VIEW t5 AS SELECT c3 FROM t3 ORDER BY c4;
SELECT * FROM t1, t2 WHERE +c1=(SELECT 123 INTERSECT SELECT c2 FROM t4) AND c1=123;
SELECT * FROM t1, t2 WHERE c1=(SELECT 123 INTERSECT SELECT c2 FROM t5) AND c1=123;
SELECT COUNT(*) FROM t3;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4914 ON t1(lower(c1)) WHERE c1 IS NOT NULL;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t3_9390 AS SELECT c4 FROM t3;
INSERT INTO t2 SELECT * FROM t2;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t3 VALUES ('x', 'x') ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
UPDATE t3 SET c4 = -47;
INSERT INTO t1 SELECT * FROM t1;
CREATE TRIGGER IF NOT EXISTS trg_t2_7080 BEFORE INSERT ON t2 BEGIN SELECT RAISE(ABORT, 'abort'); END;
CREATE  INDEX IF NOT EXISTS idx_t2_2305 ON t2((c2 + 1)) WHERE c2 IS NOT NULL;
ALTER TABLE t1 DROP COLUMN c1;
INSERT INTO t3 VALUES (NULL, 1) ON CONFLICT(c3) DO UPDATE SET c3 = excluded.c3, c4 = excluded.c4;
ALTER TABLE t2 RENAME TO t2_r5897;
CREATE TRIGGER IF NOT EXISTS trg_t3_1559 BEFORE UPDATE OF c3 ON t3 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM t1;
WITH cte AS (SELECT c2, ROW_NUMBER() OVER (ORDER BY c2) AS rn FROM t2) SELECT * FROM cte WHERE rn <= 5;
SELECT MAX(c3) FROM t3;
REINDEX;
ALTER TABLE t3 RENAME COLUMN c4 TO c4_r411;
SELECT * FROM t2 AS a FULL OUTER JOIN t1 AS b ON a.rowid = b.rowid;
SELECT COUNT(*) FROM t1;
SELECT * FROM t3 WHERE c4 IN (SELECT c4 FROM t3 WHERE c4 IN (SELECT c4 FROM t3));
CREATE TABLE T (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15),
  C BIGINT,
  UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', -9223372036854775808);
INSERT INTO T VALUES ('b', 'q', 4000);
INSERT INTO T VALUES ('c', 'r', 1700);
INSERT	INTO T VALUES ('d', 'r', 9223372036854775807);
INSERT INTO T VALUES ('e', 's', 0);
SELECT A, C FROM T WHERE C > 1200 AND C < 9999999999 ORDER BY C;
PRAGMA synchronous = '2';
UPDATE t1 SET c1 = c1 + 1 WHERE c1 IS NOT NULL RETURNING *;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<49) SELECT MAX(x) FROM cnt;
SELECT FIRST_VALUE(A) OVER (ORDER BY A) FROM T;
SELECT DENSE_RANK() OVER (PARTITION BY C ORDER BY C ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T;
COMMIT TRANSACTION;
INSERT INTO t2 DEFAULT VALUES;
ALTER TABLE t1 RENAME TO t1_r5777;
DELETE FROM t1 WHERE c1 > (SELECT AVG(c1) FROM t1);
PRAGMA secure_delete = NO;
WITH RECURSIVE multi(a, b) AS (VALUES(1, "x") UNION ALL SELECT a+1, "x" FROM multi WHERE a<53) SELECT * FROM multi;
WITH cte AS (SELECT * FROM t1 LIMIT 1) DELETE FROM t1 WHERE c1 IN (SELECT c1 FROM cte) AND 1=0;
DELETE FROM t1 WHERE rowid = 84;
SELECT * FROM t2 NATURAL JOIN T;
INSERT OR ABORT INTO t2 VALUES (0);
SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T);
WITH RECURSIVE self(x) AS (SELECT 1 UNION ALL SELECT x FROM self) SELECT * FROM self LIMIT 5;
WITH RECURSIVE r AS (SELECT * FROM T LIMIT 1 UNION ALL SELECT t.* FROM T t JOIN r ON t.B = r.B LIMIT 10) SELECT * FROM r;
ALTER TABLE T RENAME COLUMN A TO A_r2548;
ALTER TABLE t3 RENAME COLUMN c4 TO c4_r8161;
ALTER TABLE t3 RENAME TO t3_r2286;
DROP INDEX IF EXISTS t2;
DROP TABLE IF EXISTS t3;
WITH cte(x) AS (VALUES(1),(2),(3)) SELECT * FROM cte WHERE x > 1;
INSERT INTO t1 VALUES (1) ON CONFLICT(c1) DO UPDATE SET c1 = excluded.c1;
ALTER TABLE t1 RENAME COLUMN c1 TO c1_r1974;
SELECT * FROM t3 AS a RIGHT JOIN t1 AS b ON a.rowid = b.rowid;
SELECT * FROM (SELECT c1, COUNT(*) FROM t1 GROUP BY c1) AS sub;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t1 WHERE c1 = (SELECT MAX(c1) FROM t1));
SELECT COUNT(B) FROM T;
REINDEX t0;
UPDATE t3 SET c4 = NULL WHERE c4 IS NOT NULL;
CREATE TEMP  VIEW IF NOT EXISTS v_t0_4153 AS SELECT z FROM t0;
DROP TABLE IF EXISTS t2;
CREATE  INDEX IF NOT EXISTS idx_t1_6600 ON t1((c1 + 1)) WHERE c1 IS NOT NULL;
DROP TABLE IF EXISTS t1;
REINDEX;
ANALYZE t0;
SELECT COUNT(c2) FILTER (WHERE NULL) OVER (ORDER BY c2 RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM t2;
REINDEX;
UPDATE t1 SET c1 = json_object('k', c1) WHERE rowid = 1;
PRAGMA analysis_limit;
SELECT COUNT(x) FROM t0;
SELECT AVG(c2) FILTER (WHERE c2 != 0) OVER (ORDER BY c2 ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM t2;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_2997 ON t1((c1 + 1)) WHERE c1 IS NOT NULL;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t3_5553 ON t3(c4 COLLATE NOCASE) WHERE c4 > 0;
WITH cte AS (SELECT c1 FROM t1) SELECT * FROM cte;
INSERT INTO t3 DEFAULT VALUES;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT COUNT(*) FILTER (WHERE B IS NOT NULL), SUM(rowid) FILTER (WHERE B > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(B) FILTER (WHERE B > 0 AND B < 100), COUNT(*) FILTER (WHERE typeof(B) = "text") FROM T;
INSERT INTO t2 DEFAULT VALUES;
CREATE  VIEW IF NOT EXISTS v_t3_4335 AS SELECT c3 FROM t3;
ALTER TABLE t3 DROP COLUMN c3;
SELECT * FROM t2 AS a FULL JOIN t3 AS b ON a.rowid = b.rowid;
VACUUM;

SELECT COUNT(*) FROM t2;
SELECT SUM(c4) FROM t3;
WITH RECURSIVE tree(id, parent, depth) AS (VALUES(1, NULL, 0) UNION ALL SELECT id+1, id, depth+1 FROM tree WHERE depth<54) SELECT * FROM tree;
INSERT INTO t2 DEFAULT VALUES;
WITH cte AS (SELECT CASE WHEN c1 IS NULL THEN 0 ELSE c1 END AS val FROM t1) SELECT * FROM cte;
SELECT COUNT(*) FILTER (WHERE c3 IS NOT NULL), SUM(rowid) FILTER (WHERE c3 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c3) FILTER (WHERE c3 > 0 AND c3 < 100), COUNT(*) FILTER (WHERE typeof(c3) = "text") FROM t3;
SELECT * FROM t3 t1 RIGHT JOIN t3 t2 ON t1.c4 = (SELECT c4 FROM t3 WHERE c4 = t1.c4);
INSERT INTO t3 VALUES (NULL, NULL);

Actual output

CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
WARNING: writing to an imposter table will corrupt the "t1bc" index!
Braun|30|2
von|20|1
Braun|30
von|20

Expectation

Flag
Reference in New Issue View Git Blame Copy Permalink