diff options
Diffstat (limited to 'mysql-test/main/win.result')
| -rw-r--r-- | mysql-test/main/win.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index a1f20a62..1c3be0bd 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -4496,5 +4496,18 @@ NULL DROP FUNCTION f; DROP TABLE t; # +# MDEV-31296: Crash in Item_func::fix_fields when prepared statement +# with subqueries and window function is executed with +# sql_mode = ONLY_FULL_GROUP_BY +# +CREATE TABLE t1 ( a INT, i INT) ; +CREATE TABLE t2 ( a INT); +INSERT INTO t2 VALUES (4000); +SET SESSION sql_mode = "ONLY_FULL_GROUP_BY"; +EXECUTE IMMEDIATE "SELECT SUM(i) OVER (ORDER BY i) FROM t1 NATURAL JOIN t2"; +SUM(i) OVER (ORDER BY i) +# Clean up +DROP TABLE t1, t2; +# # End of 10.6 tests # |