76 lines
1.5 KiB
Markdown
76 lines
1.5 KiB
Markdown
## Summary
|
|
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**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
|
|
|
|
```
|
|
|
|
```
|
|
|