## Summary **No review yet** ## Minimized query ```sql PRAGMA auto_vacuum = 0; PRAGMA foreign_keys = 1; .width x'6d5546a801fb3b334f0c6344a9f7' format('' || ('%f'), CAST(1.7976931348623157e+308 AS INT)) 3 CREATE TABLE main.T ( a CHARACTER(20), b TEXT, c REAL ); INSERT INTO T VALUES ((CAST(CAST(9223372036854775808 AS CHARINT) AS FLOAT) + 1),'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE NOT c <= 2.0 ORDER BY c; SELECT AVG(c) FROM T; DELETE FROM T WHERE rowid = 92; CREATE TABLE T1 ( a INTEGER, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (1,1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; WITH RECURSIVE self(x) AS (SELECT 1 UNION ALL SELECT x FROM self) SELECT * FROM self LIMIT 5; SELECT COUNT(*) FROM T; SELECT STRING_AGG(a, '|') FROM T; ANALYZE T; ANALYZE T; SELECT a FROM T INTERSECT SELECT a FROM (SELECT * FROM T) AS sub; SELECT COUNT(*) FROM T; ``` ## Actual output ```sql -0.75 1|1.0 1|-1.0 2|Inf 1 1 1 1 1 3 2 3 9.22337203685478e+18 3 ``` ## Expectation ```sql ``` ## Flag ``` ```