diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-08-09 10:36:26 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-05 15:02:39 +0400 |
| commit | 0281757e824bfac4d68b24400d2cc74ced1093ca (patch) | |
| tree | 74cdfcea35640b72dadb49b0699069d3339c5d7c /mysql-test/t/sp.test | |
| parent | f71a1f736df98507c56913cc7538926f265545ea (diff) | |
| download | mariadb-git-0281757e824bfac4d68b24400d2cc74ced1093ca.tar.gz | |
Fixing sp.result, forgotten in 78d68badd7f399f08bc1000f56b2a12bb8515718.
In the affected test chunk in sp.test, sql_mode is set to 0xFFFFFFFF,
which includes ORACLE, therefore an additional "AS" keyword is required:
CREATE PROCEDURE p1() AS BEGIN END;
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 3ca210d9904..92f5acffb8e 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -8227,7 +8227,7 @@ drop procedure if exists p; set @old_mode= @@sql_mode; set @@sql_mode= cast(pow(2,32)-1 as unsigned integer); select @@sql_mode into @full_mode; -create procedure p() begin end; +create procedure p() as begin end; call p(); set @@sql_mode= @old_mode; # Rename SQL modes that differ in name between the server and the table definition. |