## Summary
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**

## Minimized query

```sql
PRAGMA 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;
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);
```

## Actual output

```sql
Progress 1
Progress 2
https://yewtu.be/watch?v=dQw4w9WgXcQ
```

## Expectation

```sql
Progress 1
Progress 2
Progress 3
https://yewtu.be/watch?v=dQw4w9WgXcQ
```

## Flag

```

```

