diff options
author | Igor Babaev <igor@askmonty.org> | 2017-10-23 15:35:10 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2017-10-23 15:35:10 -0700 |
commit | a1a79aa5760ff9595b0089ac6ad4ad917c109a03 (patch) | |
tree | a1279e7368d83bbb31833da31880092d654f792e /mysql-test/t/delete_returning.test | |
parent | acb336f75e9e5d3d4a35979b1d9229680d132c39 (diff) | |
download | mariadb-git-a1a79aa5760ff9595b0089ac6ad4ad917c109a03.tar.gz |
MDEV-13776 mysqld got signal 11 on delete returning
The method Field_iterator_table::create_item() must take into
account that it can be called when processing DELETE RETURNING.
Diffstat (limited to 'mysql-test/t/delete_returning.test')
-rw-r--r-- | mysql-test/t/delete_returning.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/delete_returning.test b/mysql-test/t/delete_returning.test index 3790d0905a5..4448a6bcccd 100644 --- a/mysql-test/t/delete_returning.test +++ b/mysql-test/t/delete_returning.test @@ -155,3 +155,18 @@ SELECT * FROM t1; DROP PROCEDURE p1; DROP TABLE t1; +--echo # +--echo # MDEV-13776: DELETE ... RETURNING with sql_mode='ONLY_FULL_GROUP_BY' +--echo # + +set @sql_mode_save= @@sql_mode; +set sql_mode='ONLY_FULL_GROUP_BY'; + +CREATE TABLE t1 (id INT); +INSERT INTO t1 VALUE(1),(2),(3); + +DELETE FROM t1 WHERE id > 2 RETURNING *; + +set sql_mode=@sql_mode_save; + +DROP TABLE t1; |