## Summary **No review yet** ## Minimized query ```sql CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c VARCHAR(1000)); CREATE INDEX t1b ON t1(b); INSERT INTO t1(a,b,c) values(1,2,'count.test cases for NOT INDEXED'); ANALYZE; UPDATE sqlite_stat1 SET stat='1000000 10' WHERE NOT NOT (idx='t1b') ; ANALYZE sqlite_master; SELECT count(1) FROM t1; CREATE TABLE t7(a INT,b TEXT,c BLOB,d REAL); CREATE TABLE t8(a INT,b TEXT,c BLOB,d REAL); CREATE INDEX t8a ON t8(a); SELECT * FROM t7 NATURAL JOIN t7; SELECT STRING_AGG(d, '|') FROM t8; ``` ## Actual output ```sql 1 ``` ## Expectation ```sql ``` ## Flag ``` ```