Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2.3
-
Fix Version/s: 10.2.6
-
Component/s: Optimizer - Window functions
-
Labels:None
Description
For the following table
create table t1 (id int);
|
insert into t1 values (1), (2), (3), (2);
|
the query
select sum(max(id)) over (order by max(id)) from t1;
|
returns the correct result:
MariaDB [test]> select sum(max(id)) over (order by max(id)) from t1;
|
+--------------------------------------+
|
| sum(max(id)) over (order by max(id)) |
|
+--------------------------------------+
|
| 3 |
|
+--------------------------------------+
|
However after creation of an index on t1(id) the same query returns a wrong result:
|
MariaDB [test]> create index idx on t1(id);
|
Query OK, 0 rows affected (0.05 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
 |
MariaDB [test]> select sum(max(id)) over (order by max(id)) from t1;
|
+--------------------------------------+
|
| sum(max(id)) over (order by max(id)) |
|
+--------------------------------------+
|
| NULL |
|
+--------------------------------------+
|
Attachments
Issue Links
- relates to
-
MDEV-13395 mysqld crash during executing Window Functions first_value/last_value
-
- Closed
-