ast-project/part1/results/3/bug_d60b1a04-9f17-44a8-bfcc-e9fcd485d27b_logic.md

Summary

**No review yet**

Minimized query

BEGIN EXCLUSIVE;
PRAGMA trusted_schema;
PRAGMA writable_schema = 1;
PRAGMA read_uncommitted = ON;
.import corrupt001.db main
CREATE TABLE t1(a INTEGER PRIMARY KEY,R);
CREATE TABLE t2(x UNIQUE);
CREATE VIEW v1a(z,y) AS SELECT x IS NULL, x FROM t2;
SELECT a,(+a)b,(+a)b,(+a)b,NOT EXISTS(SELECT null FROM t2),CASE z WHEN 487 THEN 992 WHEN 391 THEN 203 WHEN 10 THEN '?k<D Q' END,'' FROM t1 LEFT JOIN v1a ON z=b;

INSERT INTO t1 SELECT * FROM t1;
END;
PRAGMA trusted_schema = YES;

Actual output

1

Expectation

0

Flag