112 lines
3.9 KiB
Markdown
112 lines
3.9 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
|
|
.timer 192319231923
|
|
.width -(pi() + '' || ('true')) -(ifnull(jsonb_remove(substr(1.7976931348623157e+308, -2, 1), '$.key'), 2) + 0.0) -3
|
|
.open
|
|
ATTACH DATABASE (':memory:' || '') AS aux76;
|
|
-- -separator ","
|
|
|
|
CREATE /**/ TABLE T (
|
|
a TEXT,
|
|
b TEXT,
|
|
c REAL
|
|
);
|
|
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
|
SELECT a,b,c,
|
|
RANK() OVER (PARTITION BY a OrDEr BY c DESC) AS d FROM T;
|
|
SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid;
|
|
DETACH DATABASE aux76;
|
|
REINDEX;
|
|
INSERT OR IGNORE INTO T VALUES ('', '', '');
|
|
ANALYZE T;
|
|
INSERT OR IGNORE INTO T VALUES ('', NULL, -3);
|
|
VACUUM main;
|
|
.width -(pi() + '' || ('true')) -(2 + 0.0) -3
|
|
.open
|
|
ATTACH DATABASE (':memory:' || '') AS aux76;
|
|
-- -separator ","
|
|
|
|
CREATE /**/ TABLE T (
|
|
a TEXT,
|
|
b TEXT,
|
|
c REAL
|
|
);
|
|
INSERT INTO T VALUES ('a','b',5.0), ('a','c',5.0), ('b','d',-8.25);
|
|
SELECT a,b,c,
|
|
RANK() OVER (PARTITION BY a OrDEr BY c DESC) AS d FROM T;
|
|
SELECT * FROM T AS a RIGHT OUTER JOIN T AS b ON a.rowid = b.rowid;
|
|
DETACH DATABASE aux76;
|
|
REINDEX;
|
|
INSERT OR IGNORE INTO T VALUES ('', '', '');
|
|
ANALYZE T;
|
|
INSERT OR IGNORE INTO T VALUES ('', NULL, -3);
|
|
VACUUM main;
|
|
|
|
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
Run Time: real 0.000 user 0.000236 sys 0.000000
|
|
Run Time: real 0.000 user 0.000133 sys 0.000000
|
|
Run Time: real 0.000 user 0.000034 sys 0.000000
|
|
a b 5.0 1 a c 5.0 1 b d -8.25 1 Run Time: real 0.000 user 0.000156 sys 0.000000
|
|
a b 5.0 a b 5.0 a c 5.0 a c 5.0 b d -8.25 b d -8.25 Run Time: real 0.000 user 0.000100 sys 0.000000
|
|
Run Time: real 0.000 user 0.000010 sys 0.000000
|
|
Run Time: real 0.000 user 0.000003 sys 0.000000
|
|
Run Time: real 0.000 user 0.000020 sys 0.000000
|
|
Run Time: real 0.000 user 0.000105 sys 0.000000
|
|
Run Time: real 0.000 user 0.000012 sys 0.000000
|
|
Run Time: real 0.000 user 0.000311 sys 0.000000
|
|
Run Time: real 0.000 user 0.000067 sys 0.000000
|
|
Run Time: real 0.000 user 0.000060 sys 0.000000
|
|
Run Time: real 0.000 user 0.000024 sys 0.000000
|
|
a b 5.0 1 a c 5.0 1 b d -8.25 1 Run Time: real 0.000 user 0.000099 sys 0.000000
|
|
a b 5.0 a b 5.0 a c 5.0 a c 5.0 b d -8.25 b d -8.25 Run Time: real 0.000 user 0.000084 sys 0.000000
|
|
Run Time: real 0.000 user 0.000008 sys 0.000000
|
|
Run Time: real 0.000 user 0.000003 sys 0.000000
|
|
Run Time: real 0.000 user 0.000013 sys 0.000000
|
|
Run Time: real 0.000 user 0.000095 sys 0.000000
|
|
Run Time: real 0.000 user 0.000012 sys 0.000000
|
|
Run Time: real 0.000 user 0.000262 sys 0.000000
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
Run Time: real 0.000130 user 0.000143 sys 0.000000
|
|
Run Time: real 0.000065 user 0.000065 sys 0.000000
|
|
Run Time: real 0.000022 user 0.000022 sys 0.000000
|
|
a b 5.0 1 a c 5.0 1 b d -8.25 1 Run Time: real 0.000108 user 0.000108 sys 0.000000
|
|
a b 5.0 a b 5.0 a c 5.0 a c 5.0 b d -8.25 b d -8.25 Run Time: real 0.000053 user 0.000053 sys 0.000000
|
|
Run Time: real 0.000004 user 0.000004 sys 0.000000
|
|
Run Time: real 0.000002 user 0.000002 sys 0.000000
|
|
Run Time: real 0.000008 user 0.000009 sys 0.000000
|
|
Run Time: real 0.000052 user 0.000052 sys 0.000000
|
|
Run Time: real 0.000005 user 0.000005 sys 0.000000
|
|
Run Time: real 0.000149 user 0.000149 sys 0.000000
|
|
Run Time: real 0.000022 user 0.000023 sys 0.000000
|
|
Run Time: real 0.000019 user 0.000019 sys 0.000000
|
|
Run Time: real 0.000010 user 0.000010 sys 0.000000
|
|
a b 5.0 1 a c 5.0 1 b d -8.25 1 Run Time: real 0.000038 user 0.000038 sys 0.000000
|
|
a b 5.0 a b 5.0 a c 5.0 a c 5.0 b d -8.25 b d -8.25 Run Time: real 0.000046 user 0.000046 sys 0.000000
|
|
Run Time: real 0.000003 user 0.000003 sys 0.000000
|
|
Run Time: real 0.000001 user 0.000001 sys 0.000000
|
|
Run Time: real 0.000004 user 0.000004 sys 0.000000
|
|
Run Time: real 0.000029 user 0.000029 sys 0.000000
|
|
Run Time: real 0.000003 user 0.000004 sys 0.000000
|
|
Run Time: real 0.000090 user 0.000091 sys 0.000000
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
-ascii
|
|
```
|
|
|