diff options
Diffstat (limited to 'mysql-test/r/win.result')
| -rw-r--r-- | mysql-test/r/win.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/win.result b/mysql-test/r/win.result index 018dba8ad50..394d9b852bb 100644 --- a/mysql-test/r/win.result +++ b/mysql-test/r/win.result @@ -3880,5 +3880,18 @@ a sum(a) bit_or(a) OVER (ORDER BY b) NULL NULL 0 DROP TABLE t1; # +# MDEV-23438: Assertion `!field->is_null()' failed in my_decimal::my_decimal fails +# in ONLY_FULL_GROUP_BY mode +# +CREATE TABLE t1(a INT, b DECIMAL(10, 0) NOT NULL); +SET @save_sql_mode= @@sql_mode; +SET sql_mode='ONLY_FULL_GROUP_BY'; +SELECT a, sum(a), bit_or(a) OVER (ORDER BY b) FROM t1; +ERROR 42000: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause +SELECT sum(a), last_value(b) OVER () FROM t1; +ERROR 42000: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause +SET sql_mode= @save_sql_mode; +DROP TABLE t1; +# # End of 10.2 tests # |