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_afc0eb95-288c-4eed-b0cb-3322fcc558fc_logic.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

17 KiB
Raw Permalink Blame History

Summary

**No review yet**

Minimized query

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;

Actual output

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

Expectation

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

Flag
Reference in New Issue View Git Blame Copy Permalink