admin/ast-project
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
ast-project/part1/results/2/bug_bffb99cc-9e99-4630-ac7a-29ecb54bdeab_logic.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

1946 lines
85 KiB
Markdown
Raw Permalink Blame History

## Summary
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
## Minimized query
```sql
.clone new_db
PRAGMA defer_foreign_keys = 1;
BEGIN DEFERRED;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (1, '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 application_id = 10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a BIGINT,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a CROSS JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
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 OR a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub; /* ifnull({v}, {v}) */ ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T DROP COLUMN a;
CREATE INDEX IF NOT EXISTS idx_T_3012 ON T(c COLLATE NOCASE);
WITH cte AS (SELECT * FROM T WHERE a IS NOT NULL) SELECT * FROM cte;
SELECT GROUP_CONCAT(c, '.') FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
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;
SELECT AVG(a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T DROP COLUMN a;
CREATE INDEX IF NOT EXISTS idx_T_3012 ON T(c COLLATE NOCASE);
WITH cte AS (SELECT * FROM T WHERE a IS NOT NULL) SELECT * FROM cte;
SELECT GROUP_CONCAT(c, '.') FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
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;
SELECT AVG(a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T DROP COLUMN a;
CREATE INDEX IF NOT EXISTS idx_T_3012 ON T(c COLLATE NOCASE);
WITH cte AS (SELECT * FROM T WHERE a IS NOT NULL) SELECT * FROM cte;
SELECT GROUP_CONCAT(c, '.') FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
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;
SELECT AVG(a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T DROP COLUMN a;
CREATE INDEX IF NOT EXISTS idx_T_3012 ON T(c COLLATE NOCASE);
WITH cte AS (SELECT * FROM T WHERE a IS NOT NULL) SELECT * FROM cte;
SELECT GROUP_CONCAT(c, '.') FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
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;
SELECT AVG(a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
PRAGMA application_id = 2.2250738585072014e-308;
.progress 1
BEGIN DEFERRED;
.print https://yewtu.be/watch?v=dQw4w9WgXcQ
.exit (9999 - 0)
.dbconfig
PRAGMA count_changes = YES;
PRAGMA fullsync = FALSE;
.separator >_<
PRAGMA fullfsync;
PRAGMA wal_autocheckpoint;
PRAGMA cache_spill;
.timer on
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (sqrt('#'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
CREATE INDEX IF NOT EXISTS idx_T_9600 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T DROP COLUMN c;
PRAGMA analysis_limit;
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T ADD COLUMN extra_747 INT COLLATE NOCASE;
CREATE VIEW IF NOT EXISTS v_T_1966 AS SELECT a FROM T;
ALTER TABLE T ADD COLUMN extra_7698 ANY NOT NULL DEFAULT 0;
SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT * FROM (SELECT * FROM T) AS sub;
SELECT * FROM (SELECT b, COUNT(*) FROM T GROUP BY b) AS sub;
ALTER TABLE T RENAME COLUMN b TO b_r6106;
SELECT * FROM T WHERE c = (SELECT MAX(c) FROM T WHERE c = (SELECT MAX(c) FROM T));
REINDEX T;
ALTER TABLE T ADD COLUMN extra_9321 BLOB DEFAULT (random());
ROLLBACK;
INSERT OR FAIL INTO T VALUES ('x', 0, -1);
SELECT * FROM T;
DELETE FROM T WHERE c IS NULL;
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;
DROP INDEX IF EXISTS T;
PRAGMA read_uncommitted = 0;
CREATE TEMP VIEW IF NOT EXISTS v_T_3569 AS SELECT a FROM T;
ALTER TABLE T DROP COLUMN c;
SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid;
ALTER TABLE T DROP COLUMN a;
CREATE INDEX IF NOT EXISTS idx_T_3012 ON T(c COLLATE NOCASE);
WITH cte AS (SELECT * FROM T WHERE a IS NOT NULL) SELECT * FROM cte;
SELECT GROUP_CONCAT(c, '.') FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
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;
SELECT AVG(a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
SELECT * FROM T WHERE c IN (SELECT c FROM T);
INSERT INTO T VALUES (NULL, NULL, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
DELETE FROM T WHERE b IS NULL;
SELECT * FROM T WHERE b IN (SELECT b FROM T LIMIT 1);
ALTER TABLE T DROP COLUMN c;
INSERT INTO T SELECT * FROM T;
INSERT INTO T VALUES (1, 'x', 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
PRAGMA checkpoint_fullsync = 1;
DELETE FROM T WHERE a IS NULL RETURNING *;
SELECT LAG(a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T;
PRAGMA trusted_schema;
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T);
WITH RECURSIVE pair(a,b) AS (VALUES(0,1) UNION ALL SELECT b, a+b FROM pair WHERE b<100) SELECT * FROM pair;
SELECT PERCENT_RANK() OVER (ORDER BY c ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T;
INSERT INTO t1 VALUES (NULL, NULL, NULL, NULL);
SELECT MAX(c) FROM T;
PRAGMA case_sensitive_like = TRUE;
DELETE FROM t1 WHERE 0 RETURNING *;
SELECT * FROM T WHERE c <> ANY (SELECT c FROM T);
WITH cte AS (SELECT c, SUM(c) AS total FROM T GROUP BY c) SELECT * FROM cte ORDER BY total DESC;
SELECT * FROM T;
COMMIT;
INSERT OR REPLACE INTO t1 VALUES (0, 0, '', -7);
ANALYZE T;
CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_6499 AS SELECT b FROM t1;
```
## Actual output
```sql
1
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|3
Wernher|10|1
von|20|2
Braun|30
Wernher|10
von|20
```
## Expectation
```sql
1
CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
Braun|30|3
Wernher|10|1
von|20|2
Braun|30
Wernher|10
von|20
```
## Flag
```
-cmd "SELECT 1;"
```
Reference in New Issue View Git Blame Copy Permalink