## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux54; -- LEAD({c}, 2, 'default') CREATE TABLE T ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (-iif(NULL, likelihood(4041010528813953889, 0.5), 4041010528813953889),'a',40.5,-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) > 5 AND ABS(d) > 5; WITH RECURSIVE empty(x) AS (SELECT 1 WHERE 1=0 UNION ALL SELECT x+1 FROM empty WHERE x<10) SELECT * FROM empty; SELECT * FROM T AS a RIGHT JOIN T AS b ON a.rowid = b.rowid; SELECT COUNT(*) FROM T; DETACH DATABASE aux54; SELECT COUNT(*) FROM T; UPDATE T SET a = a + 1 WHERE rowid = 1; UPDATE T SET a = json_object('k', a) WHERE a IS NOT NULL RETURNING *; UPDATE T SET a = a + 1; DELETE FROM T WHERE 0; SELECT * FROM T; ``` ## Actual output ```sql a b c -4041010528813953889|a|40.5|-70.0|-4041010528813953889|a|40.5|-70.0 2|b|-10.25|20.5|2|b|-10.25|20.5 3|c|Inf|-Inf|3|c|Inf|-Inf 3 3 {"k":-4041010528813953888}|a|40.5|-70 {"k":2}|b|-10.25|20.5 {"k":3}|c|Inf|-Inf 1|a|40.5|-70.0 1|b|-10.25|20.5 1|c|Inf|-Inf ``` ## Expectation ```sql a b c -4041010528813953889|a|40.5|-70.0|-4041010528813953889|a|40.5|-70.0 2|b|-10.25|20.5|2|b|-10.25|20.5 3|c|Inf|-Inf|3|c|Inf|-Inf 3 3 {"k":-4041010528813953888}|a|40.5|-70.0 {"k":2}|b|-10.25|20.5 {"k":3}|c|Inf|-Inf 1|a|40.5|-70.0 1|b|-10.25|20.5 1|c|Inf|-Inf ``` ## Flag ``` ```