diff options
author | Varun Gupta <varun.gupta@mariadb.com> | 2020-08-10 14:11:58 +0530 |
---|---|---|
committer | Varun Gupta <varun.gupta@mariadb.com> | 2020-08-13 12:24:14 +0530 |
commit | 696edd9e7e4119cb54fa1019b0dc7eebbfce31d6 (patch) | |
tree | e819f7605c443c1067281a722e10f3a3ca34e841 /storage/innobase/include/thr0loc.h | |
parent | c6686d2cd65dc31b9ec56ef695e8d2f4dc34e48f (diff) | |
download | mariadb-git-10.2-varun.tar.gz |
MDEV-23438: Assertion `!field->is_null()' failed in my_decimal::my_decimal fails in ONLY_FULL_GROUP_BY mode10.2-varun
The issue here is query with aggregate function and non-aggregate field
in the SELECT LIST with ONLY_FULL_GROUP_BY was not disallowed.
In ONLY_FULL_GROUP_BY mode non-aggregate fields are only allowed inside an
aggregate functions or the non-aggregate fields are part of the GROUP BY clause.
In the query for the failing assert the non-aggregate field was inside
a WINDOW function and the window function was treated as an aggregate function
and so no error was thrown.
The fix would be to make sure to mark that a non-aggregate field is used inside a
window function and not an aggregate function and throw an error then.
Diffstat (limited to 'storage/innobase/include/thr0loc.h')
0 files changed, 0 insertions, 0 deletions