76 lines
2.6 KiB
Markdown
76 lines
2.6 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
|
|
PRAGMA threads;
|
|
.databases
|
|
ATTACH (':memory:' || '') AS aux1;
|
|
CREATE TABLE t1(a,b); INSERT INTO t1 VALUES(x'f7dc484d2af340822666b8','x1');
|
|
CREATE TABLE t2(a,b); INSERT INTO t2 VALUES(-json_patch((like('%0', (0 + 0), '!') + 1), 1),'x2');
|
|
CREATE TEMP TABLE t3(a,b); INSERT INTO t3 VALUES(333,'x3');
|
|
CREATE TABLE main.t4(a,b); INSERT INTO main.t4 VALUES(444,'x4');
|
|
CREATE TABLE aux1.t4(a,b); INSERT INTO aux1.t4 VALUES(555,'x5');
|
|
UPDATE t2 SET a=111;
|
|
UPDATE t3 SET a=111;
|
|
UPDATE t4 SET a=111;
|
|
SELECT * FROM (t1), (t2), (t3), (t4) WHERE NOT t4.a=t3.a+111 AND t3.a=t2.a+111 AND t2.a=t1.a+111;
|
|
CREATE TABLE T (
|
|
a DOUBLE,
|
|
b TEXT,
|
|
c REAL
|
|
);
|
|
INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0);
|
|
SELECT * FROM T WHERE +c < 2.0 ORDER BY c;
|
|
UPDATE t2 SET a = NULL WHERE a BETWEEN 0 AND 100;
|
|
REINDEX;
|
|
PRAGMA synchronous = 'NORMAL';
|
|
DELETE FROM t2 WHERE 1;
|
|
WITH RECURSIVE r AS (SELECT b FROM t1 WHERE b IS NOT NULL UNION ALL SELECT b FROM r WHERE +b > 0 LIMIT 10) SELECT * FROM r;
|
|
INSERT OR FAIL INTO t3 VALUES ('x', 0);
|
|
PRAGMA auto_vacuum = NONE;
|
|
WITH cte AS (SELECT b, LEAD(b) OVER (ORDER BY b) AS nxt FROM t4) SELECT * FROM cte;
|
|
SELECT MIN(b) FROM t4;
|
|
CREATE UNIQUE INDEX IF NOT EXISTS idx_t1_9831 ON t1(b) WHERE b > 0;
|
|
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<22) SELECT SUM(x) FROM cnt;
|
|
INSERT INTO t4 VALUES (NULL, NULL);
|
|
DROP INDEX IF EXISTS t3;
|
|
ANALYZE t1;
|
|
PRAGMA analysis_limit = 50;
|
|
DELETE FROM t1 WHERE 1 RETURNING *;
|
|
SELECT * FROM t2 AS a INNER JOIN t4 AS b ON a.rowid = b.rowid;
|
|
SELECT b FROM t3 INTERSECT SELECT b FROM (SELECT * FROM t3) AS sub;
|
|
SELECT * FROM t3 WHERE a NOT IN (SELECT a FROM t3);
|
|
PRAGMA reverse_unordered_selects = OFF;
|
|
CREATE TEMPORARY VIEW IF NOT EXISTS v_t3_1609 AS SELECT a FROM t3;
|
|
CREATE VIEW IF NOT EXISTS v_t4_8501 AS SELECT b FROM t4;
|
|
SELECT * FROM T WHERE b = (SELECT GROUP_CONCAT(b) FROM T);
|
|
|
|
SELECT COUNT(*) FROM T;
|
|
SELECT FIRST_VALUE(a) OVER (PARTITION BY a ORDER BY a ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING EXCLUDE CURRENT ROW) FROM T;
|
|
INSERT INTO t4 VALUES (NULL, NULL);
|
|
CREATE INDEX IF NOT EXISTS idx_t1_2410 ON t1(a);
|
|
INSERT INTO T SELECT * FROM T;
|
|
SELECT TOTAL(b) FROM t2;
|
|
```
|
|
|
|
## 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
|
|
```
|
|
|