diff options
| author | Nirbhay Choubey <nirbhay@mariadb.com> | 2017-01-16 20:46:30 -0500 |
|---|---|---|
| committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2017-01-16 20:46:30 -0500 |
| commit | 50438a49c99824b12bdb4a3d25fd86ed41f42ebb (patch) | |
| tree | fd1a7621598ef1c9b5a6d4fef61b30fcc0a70b6d /mysql-test/t/sp_notembedded.test | |
| parent | 01aeda194ad4d3a26a69afdb65359e4641897ed4 (diff) | |
| download | mariadb-git-bb-10.2-mdev7635.part1.tar.gz | |
MDEV-7635: Update tests to adapt to the new default sql_mode (part 4)bb-10.2-mdev7635.part1
Diffstat (limited to 'mysql-test/t/sp_notembedded.test')
| -rw-r--r-- | mysql-test/t/sp_notembedded.test | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/t/sp_notembedded.test b/mysql-test/t/sp_notembedded.test index c620f415e22..ccdc670c2bc 100644 --- a/mysql-test/t/sp_notembedded.test +++ b/mysql-test/t/sp_notembedded.test @@ -98,6 +98,7 @@ begin end if; return 1; end| +set sql_mode = ''| create procedure bug10100p(prm int, inout res int) begin set res = res * prm; @@ -112,6 +113,7 @@ begin call bug10100p(prm, res); select res; end| +set sql_mode = default| # a procedure which use tables and recursion create table t3 (a int)| @@ -303,7 +305,7 @@ set session low_priority_updates=default; # # Bug#44798 MySQL engine crashes when creating stored procedures with execute_priv=N # -INSERT INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, +INSERT IGNORE INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, |