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_c6bddf6d-7e32-47b5-b5e4-17dbeb6804cc_unexpected_error.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

15 KiB
Raw Permalink Blame History

Summary

**No review yet**

Minimized query

PRAGMA reverse_unordered_selects = NO;
PRAGMA short_column_names = TRUE;
.databases
SAVEPOINT sp5671;
.once log.txt
ATTACH DATABASE '' || (':memory:') AS aux78;
.limit
CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (ifnull(timediff(concat_ws(',', CAST(upper(-(-(-json_array_length(strftime('%s', sinh(lower('HELLO'))))))) AS INT2), 2, 3), 1), 2),1.0);
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
INSERT OR REPLACE INTO T1
SELECT * FROM T2;
SELECT * FROM T1;
PRAGMA writable_schema = YES;
SAVEPOINT sp6649;
ATTACH DATABASE ':memory:' AS aux69;
.quit
.trace
CREATE TABLE main.T (
  a DOUBLE,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (CAST(json_array_length(if(CAST(-(-(length(randomblob(CAST(mod(1.7976931348623157e+308, 1465368752231950166) AS INTEGER))))) AS TINYINT), 1, 0, 1, 0, 1), '$') AS NUMERIC),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
ATTACH DATABASE ':memory:' AS aux86;
PRAGMA full_column_names = YES;
DROP TABLE IF EXISTS _m;
CREATE TABLE t1 (c0, c1 REAL PRIMARY KEY);
INSERT INTO t1(c0, c1) VALUES ('{', -(-(1))), (0, 0);
UPDATE t1 SET c0 = NULL;
UPDATE OR REPLACE t1 SET c1 = 1;
SELECT DISTINCT * FROM t1 WHERE NOT NOT (NOT NOT (t1.c0 IS NULL)) ;
PRAGMA integrity_check;
SELECT COUNT(*) FROM t1;
SELECT * FROM t1;
DETACH DATABASE aux86;
REINDEX;
ALTER TABLE T ADD COLUMN extra_5481 BLOB NOT NULL DEFAULT 0;
SELECT COUNT(*) FROM T;
CREATE TABLE T (
  a TEXT,
  b TEXT
);
INSERT INTO T VALUES ('a','b'), ('c','d');
SELECT * FROM T WHERE +a = REPLACE('a;',';','') AND b = 'b';
CREATE TABLE T1 (
  A VARCHAR(15) PRIMARY KEY,
  B VARCHAR(30) NOT NULL UNIQUE
);
CREATE TABLE T2 (
  A VARCHAR(10) PRIMARY KEY,
  X VARCHAR(15) NOT NULL,
  C BIGINT,
  FOREIGN KEY (X) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('p', 'x');
INSERT INTO T1 VALUES ('q', 'y');
INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807);
INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808);
SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X;
SELECT LAG(c0, 2, 'default') OVER (PARTITION BY c0 ORDER BY c0 ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1;
SELECT * FROM t1;
CREATE  VIEW IF NOT EXISTS v_t1_6883 AS SELECT c1 FROM t1;
ALTER TABLE t1 ADD COLUMN extra_3184 INT2 COLLATE NOCASE;
SELECT * FROM t1;
REINDEX;
SELECT c, COUNT(*) FROM T GROUP BY c HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
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;
PRAGMA temp_store = 'MEMORY';
VACUUM main;
SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE 1 = 0);
SELECT * FROM T1 WHERE A <> ANY (SELECT A FROM T1);
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t1_5592 AS SELECT c0 FROM t1;
REINDEX T2;
UPDATE T SET b = json_object('k', b);
DETACH DATABASE aux69;
DROP INDEX IF EXISTS T1;
SELECT STRING_AGG(C) FROM T2;
ROLLBACK TO sp6649;
RELEASE sp6649;
INSERT OR ABORT INTO T2 VALUES ('x', -9, -9);
SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1;
ALTER TABLE T RENAME COLUMN b TO b_r9085;
INSERT INTO t1 DEFAULT VALUES;
SELECT GROUP_CONCAT(A, '|') FROM T2;
INSERT OR ROLLBACK INTO T1 VALUES (6, '');
WITH RECURSIVE tree(id, path) AS (VALUES(1, "/1") UNION ALL SELECT id+1, path || "/" || (id+1) FROM tree WHERE id<14) SELECT * FROM tree;
CREATE  VIEW IF NOT EXISTS v_T1_7673 AS SELECT B FROM T1;
SELECT COUNT(*) FILTER (WHERE B IS NOT NULL), SUM(rowid) FILTER (WHERE B > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(B) FILTER (WHERE B > 0 AND B < 100), COUNT(*) FILTER (WHERE typeof(B) = "text") FROM T1;
CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (1,1.0);
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
INSERT OR REPLACE INTO T1
SELECT * FROM T2;
SELECT * FROM T1;
SELECT COUNT(c) FROM T;
UPDATE T SET a = a + 1 WHERE 1;
ALTER TABLE T ADD COLUMN extra_6983 DATETIME DEFAULT CURRENT_TIMESTAMP;
INSERT INTO T2 VALUES (NULL, NULL);
.limit
CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (ifnull(timediff(concat_ws(',', CAST(upper(1) AS INT2), 2, 3), 1), 2),1.0);
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
INSERT OR REPLACE INTO T1
SELECT * FROM T2;
SELECT * FROM T1;
PRAGMA writable_schema = YES;
SAVEPOINT sp6649;
ATTACH DATABASE ':memory:' AS aux69;
.quit
.trace
CREATE TABLE T (
  a DOUBLE,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (CAST(json_array_length(if(CAST(-(-(length(randomblob(CAST(mod(1.7976931348623157e+308, 1465368752231950166) AS INTEGER))))) AS TINYINT), 1, 0, 1, 0, 1), '$') AS NUMERIC),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
ATTACH DATABASE ':memory:' AS aux86;
PRAGMA full_column_names = YES;
DROP TABLE IF EXISTS _m;
CREATE TABLE t1 (c0, c1 REAL PRIMARY KEY);
INSERT INTO t1(c0, c1) VALUES ('{', -(-(1))), (0, 0);
UPDATE t1 SET c0 = NULL;
UPDATE OR REPLACE t1 SET c1 = 1;
SELECT DISTINCT * FROM t1 WHERE NOT NOT (t1.c0 IS NULL);
PRAGMA integrity_check;
SELECT COUNT(*) FROM t1;
SELECT * FROM t1;
DETACH DATABASE aux86;
REINDEX;
ALTER TABLE T ADD COLUMN extra_5481 BLOB NOT NULL DEFAULT 0;
SELECT COUNT(*) FROM T;
CREATE TABLE T1 (
  A VARCHAR(15) PRIMARY KEY,
  B VARCHAR(30) NOT NULL UNIQUE
);
CREATE TABLE T2 (
  A VARCHAR(10) PRIMARY KEY,
  X VARCHAR(15) NOT NULL,
  C BIGINT,
  FOREIGN KEY (X) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('p', 'x');
INSERT INTO T1 VALUES ('q', 'y');
INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807);
INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808);
SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X;
SELECT LAG(c0, 2, 'default') OVER (PARTITION BY c0 ORDER BY c0 ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1;
SELECT * FROM t1;
CREATE  VIEW IF NOT EXISTS v_t1_6883 AS SELECT c1 FROM t1;
ALTER TABLE t1 ADD COLUMN extra_3184 INT2 COLLATE NOCASE;
SELECT * FROM t1;
REINDEX;
SELECT c, COUNT(*) FROM T GROUP BY c HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
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;
PRAGMA temp_store = 'MEMORY';
VACUUM main;
SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE 1 = 0);
SELECT * FROM T1 WHERE A <> ANY (SELECT A /**/ FROM T1);
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t1_5592 AS SELECT c0 FROM t1;
REINDEX T2;
UPDATE T SET b = json_object('k', b);
DETACH DATABASE aux69;
DROP INDEX IF EXISTS T1;
SELECT STRING_AGG(C) FROM T2;
ROLLBACK TO sp6649;
RELEASE sp6649;
INSERT OR ABORT INTO T2 VALUES ('x', -9, -9);
SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1;
ALTER TABLE T RENAME COLUMN b TO b_r9085;
INSERT INTO t1 DEFAULT VALUES;
SELECT GROUP_CONCAT(A, '|') FROM T2;
INSERT OR ROLLBACK INTO T1 VALUES (6, '');
WITH RECURSIVE tree(id, path) AS (VALUES(1, "/1") UNION ALL SELECT id+1, path || "/" || (id+1) FROM tree WHERE id<14) SELECT * FROM tree;
CREATE  VIEW IF NOT EXISTS v_T1_7673 AS SELECT B FROM T1;
SELECT COUNT(*) FILTER (WHERE B IS NOT NULL), SUM(rowid) FILTER (WHERE B > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(B) FILTER (WHERE B > 0 AND B < 100), COUNT(*) FILTER (WHERE typeof(B) = "text") FROM T1;
CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (1,1.0);
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
INSERT OR REPLACE INTO T1
SELECT * FROM T2;
SELECT * FROM T1;
SELECT COUNT(c) FROM T;
UPDATE T SET a = a + 1 WHERE 1;
ALTER TABLE T ADD COLUMN extra_6983 DATETIME DEFAULT CURRENT_TIMESTAMP;
INSERT INTO T2 VALUES (NULL, NULL);
.limit
CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (ifnull(timediff(concat_ws(',', CAST(upper(1) AS INT2), 2, 3), 1), 2),1.0);
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
INSERT OR REPLACE INTO T1
SELECT * FROM T2;
SELECT * FROM T1;
PRAGMA writable_schema = YES;
SAVEPOINT sp6649;
ATTACH DATABASE ':memory:' AS aux69;
.quit
.trace
CREATE TABLE T (
  a DOUBLE,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (CAST(json_array_length(if(CAST(-(-(length(randomblob(CAST(mod(1.7976931348623157e+308, 1465368752231950166) AS INTEGER))))) AS TINYINT), 1, 0, 1, 0, 1), '$') AS NUMERIC),'a',3.14), (1,'b',-7.75), (2,'c',-9e999);
WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT b,a,c,
RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T;
ATTACH DATABASE ':memory:' AS aux86;
PRAGMA full_column_names = YES;
DROP TABLE IF EXISTS _m;
CREATE TABLE t1 (c0, c1 REAL PRIMARY KEY);
INSERT INTO t1(c0, c1) VALUES ('{', -(-(1))), (0, 0);
UPDATE t1 SET c0 = NULL;
UPDATE OR REPLACE t1 SET c1 = 1;
SELECT DISTINCT * FROM t1 WHERE NOT NOT (t1.c0 IS NULL);
PRAGMA integrity_check;
SELECT COUNT(*) FROM t1;
SELECT * FROM t1;
DETACH DATABASE aux86;
REINDEX;
ALTER TABLE T ADD COLUMN extra_5481 BLOB NOT NULL DEFAULT 0;
SELECT COUNT(*) FROM T;
CREATE TABLE T1 (
  A VARCHAR(15) PRIMARY KEY,
  B VARCHAR(30) NOT NULL UNIQUE
);
CREATE TABLE T2 (
  A VARCHAR(10) PRIMARY KEY,
  X VARCHAR(15) NOT NULL,
  C BIGINT,
  FOREIGN KEY (X) REFERENCES T1(A)
);
INSERT INTO T1 /* .recover */ VALUES ('p', 'x');
INSERT INTO T1 VALUES ('q', 'y');
INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807);
INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808);
SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X;
SELECT LAG(c0, 2, 'default') OVER (PARTITION BY c0 ORDER BY c0 ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM t1;
SELECT * FROM t1;
CREATE  VIEW IF NOT EXISTS v_t1_6883 AS SELECT c1 FROM t1;
ALTER TABLE t1 ADD COLUMN extra_3184 INT2 COLLATE NOCASE;
SELECT * FROM t1;
REINDEX;
SELECT c, COUNT(*) FROM T GROUP BY c HAVING COUNT(*) = (SELECT COUNT(*) FROM T);
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;
PRAGMA temp_store = 'MEMORY';
VACUUM main;
SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE 1 = 0);
SELECT * FROM T1 WHERE A <> ANY (SELECT A FROM T1);
CREATE TEMPORARY  VIEW IF NOT EXISTS v_t1_5592 AS SELECT c0 FROM t1;
REINDEX T2;
UPDATE T SET b = json_object('k', b);
DETACH DATABASE aux69;
DROP INDEX IF EXISTS T1;
SELECT STRING_AGG(C) FROM T2;
ROLLBACK TO sp6649;
RELEASE sp6649;
INSERT OR ABORT INTO T2 VALUES ('x', -9, -9);
SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1;
ALTER TABLE T RENAME COLUMN b TO b_r9085;
INSERT INTO t1 DEFAULT VALUES;
SELECT GROUP_CONCAT(A, '|') FROM T2;
INSERT OR ROLLBACK INTO T1 VALUES (6, '');
WITH RECURSIVE tree(id, path) AS (VALUES(1, "/1") UNION ALL SELECT id+1, path || "/" || (id+1) FROM tree WHERE id<14) SELECT * FROM tree;
CREATE  VIEW IF NOT EXISTS v_T1_7673 AS SELECT B FROM T1;
SELECT COUNT(*) FILTER (WHERE B IS NOT NULL), SUM(rowid) FILTER (WHERE B > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(B) FILTER (WHERE B > 0 AND B < 100), COUNT(*) FILTER (WHERE typeof(B) = "text") FROM T1;
CREATE TABLE T1 (
  a INTEGER,
  b REAL
);
CREATE TABLE T2 (
  a INTEGER,
  b REAL
);
INSERT INTO T1 VALUES (1,1.0);
INSERT INTO T2 VALUES (1,-1.0),(2,9e999);
INSERT OR REPLACE INTO T1
SELECT * FROM T2;
SELECT * FROM T1;
SELECT COUNT(c) FROM T;
UPDATE T SET a = a + 1 WHERE 1;
ALTER TABLE T ADD COLUMN extra_6983 DATETIME DEFAULT CURRENT_TIMESTAMP;
INSERT INTO T2 VALUES (NULL, NULL);
VACUUM;
CREATE  VIEW IF NOT EXISTS v_T2_6393 AS SELECT a FROM T2;
ALTER TABLE T1 RENAME COLUMN b TO b_r8651;
SELECT LEAD(a) OVER (ORDER BY a) FROM T1;
ALTER TABLE T DROP COLUMN a;
SELECT * FROM T1 AS a INNER JOIN T1 AS b ON a.rowid = b.rowid;
CREATE TABLE T1 (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15) UNIQUE,
  C INTEGER
);
CREATE TABLE T2 (
  X VARCHAR(20) PRIMARY KEY,
  A VARCHAR(10) NOT NULL UNIQUE,
  FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', -2147483648);
INSERT INTO T1 VALUES ('b', 'q', 2147483647);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.B, T1.C FROM T2, T1 WHERE T2.A = T1.A AND T1.C >= 0;
SELECT * FROM t1 WHERE c1 IN (SELECT c1 FROM t1 t2 WHERE t2.c1 = t1.c1);
SELECT * FROM T2 AS a INNER JOIN T AS b ON a.rowid = b.rowid;
DETACH DATABASE aux78;
SELECT COUNT(*) FILTER (WHERE c1 IS NOT NULL), SUM(rowid) FILTER (WHERE c1 > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(c1) FILTER (WHERE c1 > 0 AND c1 < 100), COUNT(*) FILTER (WHERE typeof(c1) = "text") FROM t1;
UPDATE T2 SET A = 'x';
PRAGMA cache_spill = NO;
INSERT INTO T2 SELECT * FROM T2;
VACUUM main;
CREATE VIRTUAL TABLE T
USING fts5(a,b);
INSERT INTO T VALUES ('a','b c'), ('d','e f');
SELECT a,b FROM T WHERE T MATCH 'b';
SELECT * FROM T1 WHERE EXISTS (SELECT 1 FROM T1 WHERE C > 0);
ROLLBACK TRANSACTION TO SAVEPOINT sp5671;
RELEASE SAVEPOINT sp5671;
ALTER TABLE T DROP COLUMN a;
SELECT A, (SELECT MIN(A) FROM T2) AS min_val FROM T2;
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 T1;
SELECT * FROM T1 WHERE A IN (SELECT A FROM T1 WHERE A IN (SELECT A FROM T1));
ALTER TABLE t1 ADD COLUMN extra_514 DATE DEFAULT (abs(random()) % 1000);
SELECT SUM(A) FROM T1;
ALTER TABLE t1 RENAME TO t1_r1859;
SELECT COUNT(*) FROM t1;
SELECT MAX(c0) FROM t1;
SELECT NTILE(1) OVER (PARTITION BY X ORDER BY X ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T2;
CREATE TEMP  VIEW IF NOT EXISTS v_T_8701 AS SELECT b FROM T;
REINDEX;
INSERT INTO t1 SELECT * FROM t1;
SELECT * FROM t1;
SELECT STRING_AGG(a, '|') FROM T;
SELECT * FROM T1;
SELECT GROUP_CONCAT(X, '|') FROM T2;
ALTER TABLE T2 DROP COLUMN A;
INSERT INTO T VALUES (NULL, NULL, NULL);

Actual output

main: "" r/w
              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
1|-1.0
2|Inf

Expectation

Flag
Reference in New Issue View Git Blame Copy Permalink