diff options
| -rw-r--r-- | mysql-test/r/sp.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/sp.test | 1 |
2 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 2bfe975f656..158dd9bb949 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -3083,9 +3083,10 @@ drop procedure if exists bug9538| create procedure bug9538() set @@sort_buffer_size = 1000000| set @x = @@sort_buffer_size| +set @@sort_buffer_size = 2000000| select @@sort_buffer_size| @@sort_buffer_size -262136 +2000000 call bug9538()| select @@sort_buffer_size| @@sort_buffer_size diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 342fd0d9538..209386fcba4 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -3866,6 +3866,7 @@ create procedure bug9538() set @@sort_buffer_size = 1000000| set @x = @@sort_buffer_size| +set @@sort_buffer_size = 2000000| select @@sort_buffer_size| call bug9538()| select @@sort_buffer_size| |