## Summary **No review yet** ## Minimized query ```sql CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (-10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,'a',1.25), (2,'b',-3.5), (3,'c',9e999); WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0; PRAGMA analysis_limit; -- PERCENT_RANK() PRAGMA full_column_names = YES; PRAGMA query_only = 7698233414002707256; .mode CREATE TABLE T1 ( A VARCHAR(10) PRIMARY KEY, B VARCHAR(15) UNIQUE, C BIGINT ); CREATE TABLE T2 ( X VARCHAR(20) PRIMARY KEY, A VARCHAR(10), FOREIGN KEY (A) REFERENCES T1(A) ); INSERT INTO T1 VALUES ('a', 'p', 9999999999999); INSERT INTO T1 VALUES ('b', 'q', -9999999999999); INSERT INTO T2 VALUES ('m', 'a'); INSERT INTO T2 VALUES ('n', 'b'); SELECT T2.X, T1.C FROM T2 INNER JOIN T1 ON T2.A = T1.A WHERE T1.C > -1000000000000; DELETE FROM T2 WHERE A > (SELECT AVG(A) FROM T2) RETURNING *; REINDEX T2; CREATE INDEX IF NOT EXISTS idx_T2_3616 ON T2(lower(X)) WHERE X > 0; INSERT INTO T1 VALUES (NULL, NULL, NULL); CREATE UNIQUE INDEX IF NOT EXISTS idx_T2_745 ON T2((X + 1)) WHERE X > 0; SELECT * FROM T1 NATURAL JOIN T1; SELECT * FROM T1; ANALYZE T1; CREATE TEMPORARY VIEW IF NOT EXISTS v_T1_7264 AS SELECT C FROM T1; CREATE VIEW IF NOT EXISTS v_T2_7482 AS SELECT X FROM T2; INSERT INTO T2 VALUES (NULL, NULL); CREATE TEMP VIEW IF NOT /**/ EXISTS v_T1_8172 AS SELECT A FROM T1; ``` ## Actual output ```sql -Inf|a|1.25 3|c|Inf 0 current output mode: list m|9999999999999 m|a n|b a|p|9999999999999 b|q|-9999999999999 a|p|9999999999999 b|q|-9999999999999 || ``` ## Expectation ```sql -Inf|a|1.25 3|c|Inf 0 current output mode: list --escape ascii m|9999999999999 m|a n|b a|p|9999999999999 b|q|-9999999999999 a|p|9999999999999 b|q|-9999999999999 || ``` ## Flag ``` ```