diff options
Diffstat (limited to 'mysql-test/main/set_statement.test')
| -rw-r--r-- | mysql-test/main/set_statement.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/set_statement.test b/mysql-test/main/set_statement.test index cc361553cfd..0687644abc6 100644 --- a/mysql-test/main/set_statement.test +++ b/mysql-test/main/set_statement.test @@ -1130,3 +1130,19 @@ while ($1) --enable_query_log --echo # @rnd should be 0 select @rnd; + +create table t (a int); +SET sql_mode=ORACLE; +SET STATEMENT myisam_sort_buffer_size=800000 FOR OPTIMIZE TABLE t; +SET sql_mode=default; +SET STATEMENT myisam_sort_buffer_size=800000 FOR OPTIMIZE TABLE t; +drop table t; + + +--echo # +--echo # MDEV-18358: Server crash when using SET STATEMENT max_statement_time +--echo # +SET sql_mode=ORACLE; +SET STATEMENT max_statement_time=30 FOR DELETE FROM mysql.user where user = 'unknown'; +SET sql_mode=default; +SET STATEMENT max_statement_time=30 FOR DELETE FROM mysql.user where user = 'unknown'; |