## Summary **No review yet** ## Minimized query ```sql create temp table t1(x); CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; insert into t1 values('amx'); insert into t1 values('anx'); insert into t1 values('amy'); insert into t1 values('bmy'); select * from t1 where x like 'a__' intersect select * from t1 where x like '_m_' intersect select * from t1 where x like '__x'; ALTER TABLE t1 RENAME COLUMN x TO x_r2687; CREATE TEMP VIEW IF NOT EXISTS v_t1_5688 AS SELECT x FROM t1; CREATE TABLE T ( a TEXT, b REAL ); INSERT INTO T VALUES ('a',1.7976931348623157e+308), ('b',-200.5), ('c',9e999); SELECT a,b, LEAD(b,1) OVER (ORDER BY b DESC) AS c, NTILE(2) OVER (ORDER BY b DESC) AS d FROM T; SELECT * FROM t1; WITH a AS (SELECT * FROM T WHERE b IS NOT NULL), b AS (SELECT * FROM a WHERE b IS 0), c AS (SELECT * FROM b LIMIT 10) SELECT * FROM c; SELECT * FROM t1; CREATE TRIGGER IF NOT EXISTS trg_t1_2875 AFTER UPDATE OF x ON t1 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT * FROM T; PRAGMA wal_checkpoint('NOOP'); DELETE FROM T WHERE rowid = 35; CREATE TRIGGER IF NOT EXISTS trg_T_3662 AFTER DELETE ON T FOR EACH ROW BEGIN INSERT INTO T(a) VALUES (NULL); END; REINDEX t1; SELECT * FROM T CROSS JOIN t1; DELETE FROM T WHERE 0 RETURNING *; ``` ## Actual output ```sql amx c|Inf|1.79769313486232e+308|1 a|1.79769313486232e+308|-200.5|1 b|-200.5||2 amx anx amy bmy amx anx amy bmy a|1.79769313486232e+308 b|-200.5 c|Inf 0|-1|-1 a|1.79769313486232e+308|amx a|1.79769313486232e+308|anx a|1.79769313486232e+308|amy a|1.79769313486232e+308|bmy b|-200.5|amx b|-200.5|anx b|-200.5|amy b|-200.5|bmy c|Inf|amx c|Inf|anx c|Inf|amy c|Inf|bmy ``` ## Expectation ```sql ``` ## Flag ``` ```