## Summary **No review yet** ## Minimized query ```sql .timer 192319231923 .width -(pi() + '' || ('true')) -(ifnull(jsonb_remove(substr(1.7976931348623157e+308, -2, 1), '$.key'), 2) + 0.0) -3 .open ATTACH DATABASE (':memory:' || '') AS aux76; -- -separator "," CREATE /**/ TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25); SELECT a,b,c, RANK() OVER (PARTITION BY a OrDEr BY c DESC) AS d FROM T; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; DETACH DATABASE aux76; REINDEX; INSERT OR IGNORE INTO T VALUES ('', '', ''); ANALYZE T; INSERT OR IGNORE INTO T VALUES ('', NULL, -3); VACUUM main; .width -(pi() + '' || ('true')) -(2 + 0.0) -3 .open ATTACH DATABASE (':memory:' || '') AS aux76; -- -separator "," CREATE /**/ TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25); SELECT a,b,c, RANK() OVER (PARTITION BY a OrDEr BY c DESC) AS d FROM T; SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid; DETACH DATABASE aux76; REINDEX; INSERT OR IGNORE INTO T VALUES ('', '', ''); ANALYZE T; INSERT OR IGNORE INTO T VALUES ('', NULL, -3); VACUUM main; ``` ## Actual output ```sql Run Time: real 0.000 user 0.000236 sys 0.000000 Run Time: real 0.000 user 0.000133 sys 0.000000 Run Time: real 0.000 user 0.000034 sys 0.000000 ab5.01ac5.01bd-8.251Run Time: real 0.000 user 0.000156 sys 0.000000 ab5.0ab5.0ac5.0ac5.0bd-8.25bd-8.25Run Time: real 0.000 user 0.000100 sys 0.000000 Run Time: real 0.000 user 0.000010 sys 0.000000 Run Time: real 0.000 user 0.000003 sys 0.000000 Run Time: real 0.000 user 0.000020 sys 0.000000 Run Time: real 0.000 user 0.000105 sys 0.000000 Run Time: real 0.000 user 0.000012 sys 0.000000 Run Time: real 0.000 user 0.000311 sys 0.000000 Run Time: real 0.000 user 0.000067 sys 0.000000 Run Time: real 0.000 user 0.000060 sys 0.000000 Run Time: real 0.000 user 0.000024 sys 0.000000 ab5.01ac5.01bd-8.251Run Time: real 0.000 user 0.000099 sys 0.000000 ab5.0ab5.0ac5.0ac5.0bd-8.25bd-8.25Run Time: real 0.000 user 0.000084 sys 0.000000 Run Time: real 0.000 user 0.000008 sys 0.000000 Run Time: real 0.000 user 0.000003 sys 0.000000 Run Time: real 0.000 user 0.000013 sys 0.000000 Run Time: real 0.000 user 0.000095 sys 0.000000 Run Time: real 0.000 user 0.000012 sys 0.000000 Run Time: real 0.000 user 0.000262 sys 0.000000 ``` ## Expectation ```sql Run Time: real 0.000130 user 0.000143 sys 0.000000 Run Time: real 0.000065 user 0.000065 sys 0.000000 Run Time: real 0.000022 user 0.000022 sys 0.000000 ab5.01ac5.01bd-8.251Run Time: real 0.000108 user 0.000108 sys 0.000000 ab5.0ab5.0ac5.0ac5.0bd-8.25bd-8.25Run Time: real 0.000053 user 0.000053 sys 0.000000 Run Time: real 0.000004 user 0.000004 sys 0.000000 Run Time: real 0.000002 user 0.000002 sys 0.000000 Run Time: real 0.000008 user 0.000009 sys 0.000000 Run Time: real 0.000052 user 0.000052 sys 0.000000 Run Time: real 0.000005 user 0.000005 sys 0.000000 Run Time: real 0.000149 user 0.000149 sys 0.000000 Run Time: real 0.000022 user 0.000023 sys 0.000000 Run Time: real 0.000019 user 0.000019 sys 0.000000 Run Time: real 0.000010 user 0.000010 sys 0.000000 ab5.01ac5.01bd-8.251Run Time: real 0.000038 user 0.000038 sys 0.000000 ab5.0ab5.0ac5.0ac5.0bd-8.25bd-8.25Run Time: real 0.000046 user 0.000046 sys 0.000000 Run Time: real 0.000003 user 0.000003 sys 0.000000 Run Time: real 0.000001 user 0.000001 sys 0.000000 Run Time: real 0.000004 user 0.000004 sys 0.000000 Run Time: real 0.000029 user 0.000029 sys 0.000000 Run Time: real 0.000003 user 0.000004 sys 0.000000 Run Time: real 0.000090 user 0.000091 sys 0.000000 ``` ## Flag ``` -ascii ```