summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp-dynamic.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/sp-dynamic.result')
-rw-r--r--mysql-test/r/sp-dynamic.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/sp-dynamic.result b/mysql-test/r/sp-dynamic.result
index 7309ba4c765..9fa3bea1108 100644
--- a/mysql-test/r/sp-dynamic.result
+++ b/mysql-test/r/sp-dynamic.result
@@ -220,6 +220,7 @@ id name
call p1()|
ERROR HY000: Unknown prepared statement handler (stmt) given to EXECUTE
drop procedure p1|
+set sql_mode= ''|
create procedure p1()
begin
declare a char(10);
@@ -232,6 +233,7 @@ call p1()|
ERROR 42S22: Unknown column 'a' in 'field list'
call p1()|
ERROR 42S22: Unknown column 'a' in 'field list'
+set sql_mode= DEFAULT|
drop procedure p1|
create procedure p1()
begin