58 lines
1.7 KiB
Markdown
58 lines
1.7 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
|
|
((SAVEPOINT)) sp5482;
|
|
CREATE TABLE main.T (
|
|
a INTEGER,
|
|
b REAL
|
|
);
|
|
INSERT INTO T VALUES (json_array_length(json_array(ifnull(x'75623772', 1)), '' || ('$.nonexistent')),1.5), (2,-7.25), (3,0.0);
|
|
SELECT a,b FROM /* .indexes main */ T WHERE a >= 2 ORDER BY b;
|
|
SELECT * FROM T AS a JOIN T AS b ON a.rowid = b.rowid;
|
|
VACUUM main;
|
|
DELETE FROM T WHERE 1;
|
|
ALTER TABLE T DROP COLUMN b;
|
|
INSERT INTO T DEFAULT VALUES;
|
|
|
|
SELECT COUNT(*) FROM T;
|
|
SELECT MIN(a) FROM T;
|
|
INSERT INTO T SELECT * FROM T;
|
|
SELECT * /* .clone */ FROM T;
|
|
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
|
|
WITH cte AS (SELECT a, LEAD(a) OVER (ORDER BY a) /**/ AS nxt FROM T) SELECT * FROM cte;
|
|
SELECT COUNT(*) FILTER (WHERE b > 0) OVER (ORDER BY b) FROM T;
|
|
SELECT * FROM T CROSS JOIN T;
|
|
WITH n AS NOT MATERIALIZED (SELECT * FROM T) SELECT * FROM n WHERE b > 0;
|
|
UPDATE T SET a = NULL WHERE 1;
|
|
INSERT INTO T VALUES (NULL, NULL);
|
|
CREATE TEMPORARY VIEW IF NOT EXISTS v_T_6742 AS SELECT a FROM T;
|
|
VACUUM;
|
|
INSERT INTO T DEFAULT VALUES;
|
|
ROLLBACK TRANSACTION TO SAVEPOINT sp5482;
|
|
RELEASE SAVEPOINT sp5482;
|
|
SELECT MAX(a) FILTER (WHERE a IS NOT NULL) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T;
|
|
PRAGMA trusted_schema = FALSE;
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
3.39.0 2022-05-10 23:28:12 764b71267e0b31ff7eaf2a0def7526a1a02dce4d5b456dea060d97ed342ealt1
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
3.51.1 2025-11-28 17:28:25 281fc0e9afc38674b9b0991943b9e9d1e64c6cbdb133d35f6f5c87ff6af38a88 (64-bit)
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
-version
|
|
```
|
|
|