## Summary **No review yet** ## Minimized query ```sql PRAGMA max_page_count; CREATE TABLE T ( A VARCHAR(15) PRIMARY KEY, B VARCHAR(30) NOT NULL, C TINYINT UNIQUE ); INSERT INTO T VALUES ('a', 'x', -9223372036854775808); INSERT INTO T VALUES ('b', 'y', -1000000); INSERT INTO T VALUES ('c', 'y', 0); INSERT INTO T VALUES ('d', 'y', 42); INSERT INTO T VALUES ('e', 'x', 9223372036854775807); INSERT INTO T VALUES ('f', 'z', 2147483648); SELECT * FROM T WHERE C > 0 ORDER BY C DESC; CREATE INDEX IF NOT EXISTS idx_T_2458 ON T(lower(C)) WHERE C > 0; CREATE INDEX IF NOT EXISTS idx_T_3289 ON T(C COLLATE NOCASE) WHERE C IS NOT NULL; SELECT * FROM T WHERE (C) IN (SELECT C FROM T); ``` ## Actual output ```sql 1073741823 e|x|9223372036854775807 f|z|2147483648 d|y|42 a|x|-9223372036854775808 b|y|-1000000 c|y|0 d|y|42 f|z|2147483648 e|x|9223372036854775807 ``` ## Expectation ```sql 4294967294 e|x|9223372036854775807 f|z|2147483648 d|y|42 a|x|-9223372036854775808 b|y|-1000000 c|y|0 d|y|42 f|z|2147483648 e|x|9223372036854775807 ``` ## Flag ``` ```