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_3ad62a8b-5990-4b23-94f5-9b7c01989f30_logic.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

18 KiB
Raw Permalink Blame History

Summary

**No review yet**

Minimized query

SAVEPOINT sp4770;
-- typeof(1.0)

.limit
SAVEPOINT sp9818;
ATTACH DATABASE ':memory:' AS aux84;
SAVEPOINT sp2531;
.check
SAVEPOINT sp9694;
PRAGMA encoding = 'UTF-8';
ATTACH DATABASE ':memory:' AS aux44;
CREATE TABLE main.main.`T` (
  a REAL,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (-(-(0)) + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b;
DETACH DATABASE aux44;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a);
INSERT INTO T VALUES (NULL, NULL, NULL);
INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, '');
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt;
ALTER TABLE T DROP COLUMN b;
DROP VIEW IF EXISTS T;
SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0);
ROLLBACK TO sp9694;
RELEASE sp9694;
ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000);
SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT COUNT(*) FROM T;
ROLLBACK TO sp2531;
RELEASE sp2531;
INSERT OR ABORT INTO T VALUES (6, 0, 0);
SELECT COUNT(*) FROM T;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt;
DETACH DATABASE aux84;
SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1);
ALTER TABLE T RENAME TO T_r9068;
CREATE TABLE T (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15),
  C BIGINT NOT NULL,
  UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', 3000);
INSERT INTO T VALUES ('b', 'q', 9223372036854775807);
INSERT INTO T VALUES ('c', 'r', 1700);
INSERT INTO T VALUES ('e', 'q', -9223372036854775808);
INSERT INTO T VALUES ('f', 'r', 0);
SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0;
ROLLBACK TRANSACTION TO SAVEPOINT sp9818;
RELEASE SAVEPOINT sp9818;
SELECT STRING_AGG(a, '|') FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T;
SELECT COUNT(*) FROM T;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
INSERT INTO T VALUES (NULL, NULL, NULL);
ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM;
SELECT * FROM T NATURAL JOIN T;
ANALYZE;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T VALUES (NULL, NULL, NULL);
WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte;
SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T;
ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE;
RELEASE sp4770;
PRAGMA short_column_names = OFF;
CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T);
SAVEPOINT sp4770;
.limit
SAVEPOINT sp9818;
ATTACH DATABASE ':memory:' AS aux84;
SAVEPOINT sp2531;
.check
SAVEPOINT sp9694;
PRAGMA encoding = 'UTF-8';
ATTACH DATABASE ':memory:' AS aux44;
CREATE TABLE main.main.`T` (
  a REAL,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b;
DETACH DATABASE aux44;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a);
INSERT INTO T VALUES (NULL, NULL, NULL);
INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, '');
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt;
ALTER TABLE T DROP COLUMN b;
DROP VIEW IF EXISTS T;
SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0);
ROLLBACK TO sp9694;
RELEASE sp9694;
ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000);
SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT COUNT(*) FROM T;
ROLLBACK TO sp2531;
RELEASE sp2531;
INSERT OR ABORT INTO T VALUES (6, 0, 0);
SELECT COUNT(*) FROM T;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt;
DETACH DATABASE aux84;
SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1);
ALTER TABLE T RENAME TO T_r9068;
CREATE TABLE T (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15),
  C BIGINT NOT NULL,
  UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', 3000);
INSERT INTO T VALUES ('b', 'q', 9223372036854775807);
INSERT INTO T VALUES ('c', 'r', 1700);
INSERT INTO T VALUES ('e', 'q', -9223372036854775808);
INSERT INTO T VALUES ('f', 'r', 0);
SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0;
ROLLBACK TRANSACTION TO SAVEPOINT sp9818;
RELEASE SAVEPOINT sp9818;
SELECT STRING_AGG(a, '|') FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T;
SELECT COUNT(*) FROM T;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
INSERT INTO T VALUES (NULL, NULL, NULL);
ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM;
SELECT * FROM T NATURAL JOIN T;
ANALYZE;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T VALUES (NULL, NULL, NULL);
WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte;
SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T;
ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE;
RELEASE sp4770;
PRAGMA short_column_names = OFF;
CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T);
SAVEPOINT sp4770;
.limit
SAVEPOINT sp9818;
ATTACH DATABASE ':memory:' AS aux84;
SAVEPOINT sp2531;
.check
SAVEPOINT sp9694;
PRAGMA encoding = 'UTF-8';
ATTACH DATABASE ':memory:' AS aux44;
CREATE TABLE main.main.`T` (
  a REAL,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b;
DETACH DATABASE aux44;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a);
INSERT INTO T VALUES (NULL, NULL, NULL);
INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, '');
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt;
ALTER TABLE T DROP COLUMN b;
DROP VIEW IF EXISTS T;
SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0);
ROLLBACK TO sp9694;
RELEASE sp9694;
ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000);
SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT COUNT(*) FROM T;
ROLLBACK TO sp2531;
RELEASE sp2531;
INSERT OR ABORT INTO T VALUES (6, 0, 0);
SELECT COUNT(*) FROM T;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt;
DETACH DATABASE aux84;
SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1);
ALTER TABLE T RENAME TO T_r9068;
CREATE TABLE T (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15),
  C BIGINT NOT NULL,
  UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', 3000);
INSERT INTO T VALUES ('b', 'q', 9223372036854775807);
INSERT INTO T VALUES ('c', 'r', 1700);
INSERT INTO T VALUES ('e', 'q', -9223372036854775808);
INSERT INTO T VALUES ('f', 'r', 0);
SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0;
ROLLBACK TRANSACTION TO SAVEPOINT sp9818;
RELEASE SAVEPOINT sp9818;
SELECT STRING_AGG(a, '|') FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T;
SELECT COUNT(*) FROM T;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
INSERT INTO T VALUES (NULL, NULL, NULL);
ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM;
SELECT * FROM T NATURAL JOIN T;
ANALYZE;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T VALUES (NULL, NULL, NULL);
WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte;
SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T;
ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE;
RELEASE sp4770;
PRAGMA short_column_names = OFF;
CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T);
SAVEPOINT sp4770;
.limit
SAVEPOINT sp9818;
ATTACH DATABASE ':memory:' AS aux84;
SAVEPOINT sp2531;
.check
SAVEPOINT sp9694;
PRAGMA encoding = 'UTF-8';
ATTACH DATABASE ':memory:' AS aux44;
CREATE TABLE main.main.`T` (
  a REAL,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b;
DETACH DATABASE aux44;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a);
INSERT INTO T VALUES (NULL, NULL, NULL);
INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, '');
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt;
ALTER TABLE T DROP COLUMN b;
DROP VIEW IF EXISTS T;
SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0);
ROLLBACK TO sp9694;
RELEASE sp9694;
ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000);
SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT COUNT(*) FROM T;
ROLLBACK TO sp2531;
RELEASE sp2531;
INSERT OR ABORT INTO T VALUES (6, 0, 0);
SELECT COUNT(*) FROM T;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt;
DETACH DATABASE aux84;
SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1);
ALTER TABLE T RENAME TO T_r9068;
CREATE TABLE T (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15),
  C BIGINT NOT NULL,
  UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', 3000);
INSERT INTO T VALUES ('b', 'q', 9223372036854775807);
INSERT INTO T VALUES ('c', 'r', 1700);
INSERT INTO T VALUES ('e', 'q', -9223372036854775808);
INSERT INTO T VALUES ('f', 'r', 0);
SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0;
ROLLBACK TRANSACTION TO SAVEPOINT sp9818;
RELEASE SAVEPOINT sp9818;
SELECT STRING_AGG(a, '|') FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T;
SELECT COUNT(*) FROM T;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
INSERT INTO T VALUES (NULL, NULL, NULL);
ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM;
SELECT * FROM T NATURAL JOIN T;
ANALYZE;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T VALUES (NULL, NULL, NULL);
WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte;
SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T;
ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE;
RELEASE sp4770;
PRAGMA short_column_names = OFF;
CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T);
SAVEPOINT sp4770;
.limit
SAVEPOINT sp9818;
ATTACH DATABASE ':memory:' AS aux84;
SAVEPOINT sp2531;
.check
SAVEPOINT sp9694;
PRAGMA encoding = 'UTF-8';
ATTACH DATABASE ':memory:' AS aux44;
CREATE TABLE main.main.`T` (
  a REAL,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (strftime('%s', if(coalesce(NULL, NULL, NULL) -> sqrt(datetime(-(-(CAST(x'2f' AS BLOB))))), typeof(NULL), (0 + 9145485036963515638))),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T) SELEC_m * FROM T) SELEC_m * FROM T WHERE NOT NOT (NOT NOT (+b < 2.0)) ORDER BY b;
DETACH DATABASE aux44;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a);
INSERT INTO T VALUES (NULL, NULL, NULL);
INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, '');
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE +x<21) SELECT * FROM cnt;
ALTER TABLE T DROP COLUMN b;
DROP VIEW IF EXISTS T;
SELECT ROW_NUMBER() OVER (ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
INSERT OR ROLLBACK INTO T VALUES (-2, NULL, 0);
ROLLBACK TO sp9694;
RELEASE sp9694;
ALTER TABLE T ADD COLUMN extra_4532 UNSIGNED BIG INT DEFAULT (abs(random()) % 1000);
SELECT a, COUNT(*) FROM T GROUP BY a HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
CREATE TRIGGER IF NOT EXISTS trg_T_7371 BEFORE UPDATE ON T FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT COUNT(*) FROM T;
ROLLBACK TO sp2531;
RELEASE sp2531;
INSERT OR ABORT INTO T VALUES (6, 0, 0);
SELECT COUNT(*) FROM T;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION SELECT x+1 FROM cnt WHERE x<8) SELECT * FROM cnt;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<0) SELECT * FROM cnt;
DETACH DATABASE aux84;
SELECT * FROM T t1 JOIN T t2 ON t1.a = (SELECT a FROM T LIMIT 1);
ALTER TABLE T RENAME TO T_r9068;
CREATE TABLE T (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15),
  C BIGINT NOT NULL,
  UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', 3000);
INSERT INTO T VALUES ('b', 'q', 9223372036854775807);
INSERT INTO T VALUES ('c', 'r', 1700);
INSERT INTO T VALUES ('e', 'q', -9223372036854775808);
INSERT INTO T VALUES ('f', 'r', 0);
SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0;
ROLLBACK TRANSACTION TO SAVEPOINT sp9818;
RELEASE SAVEPOINT sp9818;
SELECT STRING_AGG(a, '|') FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
SELECT LEAD(a, 1, NULL) OVER (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
SELECT RANK() OVER (ORDER BY c GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM T;
SELECT COUNT(*) FROM T;
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
INSERT INTO T VALUES (NULL, NULL, NULL);
ALTER TABLE T ADD COLUMN extra_9504 DOUBLE COLLATE RTRIM;
SELECT * FROM T NATURAL JOIN T;
ANALYZE;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T DEFAULT VALUES;
INSERT INTO T VALUES (NULL, NULL, NULL);
WITH cte AS (SELECT CASE WHEN a > 0 THEN "pos" ELSE "neg" END AS sign FROM T) SELECT * FROM cte;
SELECT FIRST_VALUE(c) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T;
ALTER TABLE T ADD COLUMN extra_5697 BIGINT COLLATE NOCASE;
RELEASE sp4770;
PRAGMA short_column_names = OFF;
CREATE TRIGGER IF NOT EXISTS trg_T_534 AFTER UPDATE OF A ON T BEGIN SELECT RAISE(FAIL, 'no'); END;
SELECT * FROM T WHERE C = (SELECT GROUP_CONCAT(C) FROM T);

ALTER TABLE T RENAME TO T_r7047;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T WHERE EXISTS (SELECT 1 FROM T));
CREATE  INDEX IF NOT EXISTS idx_T_4760 ON T(lower(A));
INSERT INTO T DEFAULT VALUES;
DROP TABLE IF EXISTS T;

Actual output

length 1000000000
          sql_length 1000000000
              column 2000
          expr_depth 1000
     compound_select 500
             vdbe_op 250000000
        function_arg 127
            attached 10
 like_pattern_length 50000
     variable_number 32766
       trigger_depth 1000
      worker_threads 0

Expectation

length 1000000000
          sql_length 1000000000
              column 2000
          expr_depth 1000
     compound_select 500
             vdbe_op 250000000
        function_arg 1000
            attached 10
 like_pattern_length 50000
     variable_number 32766
       trigger_depth 1000
      worker_threads 0

Flag
Reference in New Issue View Git Blame Copy Permalink