Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.3
-
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