64 lines
1.8 KiB
Markdown
64 lines
1.8 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 schema_version = 5;
|
|
CREATE TABLE A (A1 DOUBLE, A2 TEXT COLLATE NOCASE, A3 DOUBLE);
|
|
-- glob('[0-9]', '5')
|
|
|
|
-- concat_ws('|', NULL, 'a', 'b')
|
|
|
|
INSERT INTO A VALUES(acosh(39136),'ABC',1201900000);
|
|
INSERT INTO A VALUES(39136,'ABC',1207000000);
|
|
SELECT typeof(sum(a3)) FROM a;
|
|
SELECT typeof(sum(a3)) FROM a GROUP BY a1;
|
|
|
|
SELECT * FROM A AS a RIGHT OUTER JOIN A AS b ON a.rowid = b.rowid;
|
|
WITH cte(a, b, c) AS (SELECT A3, A3, A3 FROM A) SELECT a, b, c FROM cte;
|
|
CREATE TRIGGER IF NOT EXISTS trg_A_6440 BEFORE UPDATE OF A3 ON A BEGIN SELECT RAISE(ROLLBACK, 'rb'); END;
|
|
INSERT INTO A SELECT * FROM A;
|
|
ALTER TABLE A ADD COLUMN extra_6320 REAL COLLATE NOCASE;
|
|
SELECT MIN(A3) FROM A;
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
SQLite version 3.39.0 2022-05-10 23:28:12
|
|
Enter ".help" for usage hints.
|
|
sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> real
|
|
sqlite> real
|
|
real
|
|
sqlite> sqlite> 11.2679452188836|ABC|1201900000.0|11.2679452188836|ABC|1201900000.0
|
|
39136.0|ABC|1207000000.0|39136.0|ABC|1207000000.0
|
|
sqlite> 1201900000.0|1201900000.0|1201900000.0
|
|
1207000000.0|1207000000.0|1207000000.0
|
|
sqlite> sqlite> sqlite> sqlite> 1201900000.0
|
|
sqlite>
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
SQLite version 3.51.1 2025-11-28 17:28:25
|
|
Enter ".help" for usage hints.
|
|
sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> real
|
|
sqlite> real
|
|
real
|
|
sqlite> sqlite> 11.2679452188836|ABC|1201900000.0|11.2679452188836|ABC|1201900000.0
|
|
39136.0|ABC|1207000000.0|39136.0|ABC|1207000000.0
|
|
sqlite> 1201900000.0|1201900000.0|1201900000.0
|
|
1207000000.0|1207000000.0|1207000000.0
|
|
sqlite> sqlite> sqlite> sqlite> 1201900000.0
|
|
sqlite>
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
-interactive
|
|
```
|
|
|