[MDEV-11990] Wrong result for query with window function when all tables are optimized away - Jira

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                                 |

+--------------------------------------+

relates to

MDEV-13395 mysqld crash during executing Window Functions first_value/last_value

Ok to push.

Vicențiu Ciorbaru added a comment - 2017-05-03 16:06 Ok to push.

The fix for this bug was pushed into the 10.2 tree.

Igor Babaev (Inactive) added a comment - 2017-05-05 05:53 The fix for this bug was pushed into the 10.2 tree.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server