ast-project/part1/results/3/bug_99dedd8f-49c3-40b3-badf-3d5d994f6697_logic.md

Summary

**No review yet**

Minimized query

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';
PRAGMA count_changes = YES;
PRAGMA index_list(users);
PRAGMA encoding;
.limit
CREATE TABLE t5(a INT, b INT);
CREATE UNIQUE INDEX t5x ON t5(a+b);
INSERT INTO t5(a,b) VALUES(CAST(unixepoch(substr(0, 100)) AS DOUB),0),(1,0),(1,1),(0,3);
CREATE TEMP TABLE out AS SELECT DISTINCT a+b FROM t5;
CREATE TABLE t6a(x INTEGER PRIMARY KEY);
INSERT INTO t6a VALUES(1);
CREATE TABLE t6b(y INTEGER PRIMARY KEY);
INSERT INTO t6b VALUES(2),(3);
SELECT DISTINCT x, x FROM t6a, t6b;
SELECT * FROM out ORDER BY 1;

CREATE  INDEX IF NOT EXISTS idx_t5_5638 ON t5((b + 1)) WHERE NOT NOT (b > 0) ;
DROP TABLE IF EXISTS t6b;
SELECT * FROM t6a WHERE EXISTS (SELECT 1 FROM t6a WHERE 1 = 0);
ALTER TABLE t5 RENAME COLUMN b TO b_r7147;

Actual output

a|b
UTF-8
              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
4
1
2
1|1

1
2
3

Expectation

a|b
UTF-8
              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
4
1
2
1|1

1
2
3

Flag