## Summary **No review yet** ## Minimized query ```sql PRAGMA checkpoint_fullsync; PRAGMA case_sensitive_like = 1; PRAGMA collation_list; .scanstats est CREATE TABLE t51(x, y); CREATE TABLE t52(x, y); CREATE VIEW v5 as SELECT x, y FROM t51 UNION ALL SELECT x, y FROM t52; CREATE INDEX t51x ON t51(x); CREATE INDEX t52x ON t52(x); SELECT * FROM v5 WHERE x='12345' ORDER BY y; SELECT x, y FROM v5 WHERE x='12345' ORDER BY y; SELECT x, y FROM v5 WHERE +x='12345' ORDER BY y; CREATE VIEW IF NOT EXISTS v_t51_8940 AS SELECT x FROM t51; SELECT FIRST_VALUE(y) OVER (PARTITION BY y ORDER BY y GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM t51; WITH RECURSIVE fib(a,b) AS (VALUES(1,1) UNION ALL SELECT b, a+b FROM fib WHERE b<1000) SELECT a FROM fib; ``` ## Actual output ```sql 0|decimal 1|uint 2|RTRIM 3|NOCASE 4|BINARY 1 1 2 3 5 8 13 21 34 55 89 144 233 377 610 987 ``` ## Expectation ```sql 0|decimal 1|BINARY 2|NOCASE 3|RTRIM 4|uint 1 1 2 3 5 8 13 21 34 55 89 144 233 377 610 987 ``` ## Flag ``` ```