## Summary **No review yet** ## Minimized query ```sql PRAGMA reverse_unordered_selects = ON; PRAGMA max_page_count; PRAGMA case_sensitive_like = OFF; PRAGMA writable_schema = NO; .quit DROP TABLE IF EXISTS t1; CREATE TABLE t1(a int, b int); INSERT INTO t1 VALUES(glob(NULL, NULL),2),(1,18),(2,19); SELECT x, y FROM (SELECT 98 AS x, 99 AS y UNION SELECT a AS x, sum(b) AS y FROM t1 GROUP BY /* PRAGMA secure_delete = TRUE; */ a) AS w WHERE y>=20 ORDER BY +x; SELECT x, y FROM (SELECT a AS x, sum(b) AS y FROM t1 GROUP BY a UNION SELECT 98 AS x, 99 AS y) AS w WHERE y>=20 ORDER BY +x; DROP VIEW IF EXISTS t1; INSERT INTO t1 VALUES (NULL, NULL); CREATE TABLE T1 ( A VARCHAR(20), X VARCHAR(10), PRIMARY KEY (A, X), UNIQUE (X) ); CREATE TABLE T2 ( A VARCHAR(20), Y VARCHAR(10) UNIQUE, PRIMARY KEY (A, Y) ); INSERT INTO T1 VALUES ('a', 'm'); INSERT INTO T1 VALUES ('b', 'n'); INSERT INTO T2 VALUES ('b', 'k'); SELECT A FROM T1 UNION ALL SELECT A FROM T2 ORDER BY A; INSERT INTO T2 VALUES (NULL, NULL); ALTER TABLE T2 ADD COLUMN extra_2116 NUMERIC DEFAULT 0; REINDEX; UPDATE T2 SET A = 'x' WHERE A IS NOT NULL RETURNING *; SELECT * FROM (SELECT Y, COUNT(*) FROM T2 GROUP BY Y) AS sub; ALTER TABLE t1 DROP COLUMN b; SELECT LAG(X, 0) OVER (PARTITION BY X ORDER BY X ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T1; SELECT 0x0ACB29BM205381; SELECT sqlite_compileoption_used('我的天你是怎么了'); SELECT 1 >> -999999999999999999999999999; SELECT sqlite_compileoption_get($1); SELECT sqlite_version(); SELECT LEAD(X, 1, NULL) OVER (PARTITION BY X ORDER BY X ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T1; ``` ## Actual output ```sql 1073741823 ``` ## Expectation ```sql 4294967294 ``` ## Flag ``` ```