diff options
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r-- | mysql-test/r/sp.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 60363b06ea0..9a41c63c534 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -1493,10 +1493,10 @@ insert into t3 (a) values (1)| create procedure h_ee() deterministic begin -declare continue handler for 1062 -- ER_DUP_ENTRY +declare continue handler for 1579 -- ER_DUP_ENTRY_WITH_KEY_NAME select 'Outer (bad)' as 'h_ee'; begin -declare continue handler for 1062 -- ER_DUP_ENTRY +declare continue handler for 1579 -- ER_DUP_ENTRY_WITH_KEY_NAME select 'Inner (good)' as 'h_ee'; insert into t3 values (1); end; @@ -1504,7 +1504,7 @@ end| create procedure h_es() deterministic begin -declare continue handler for 1062 -- ER_DUP_ENTRY +declare continue handler for 1579 -- ER_DUP_ENTRY_WITH_KEY_NAME select 'Outer (good)' as 'h_es'; begin -- integrity constraint violation @@ -1541,7 +1541,7 @@ end| create procedure h_ex() deterministic begin -declare continue handler for 1062 -- ER_DUP_ENTRY +declare continue handler for 1579 -- ER_DUP_ENTRY_WITH_KEY_NAME select 'Outer (good)' as 'h_ex'; begin declare continue handler for sqlexception @@ -1556,7 +1556,7 @@ begin declare continue handler for sqlstate '23000' select 'Outer (bad)' as 'h_se'; begin -declare continue handler for 1062 -- ER_DUP_ENTRY +declare continue handler for 1579 -- ER_DUP_ENTRY_WITH_KEY_NAME select 'Inner (good)' as 'h_se'; insert into t3 values (1); end; @@ -1696,7 +1696,7 @@ begin declare continue handler for sqlexception select 'Outer (bad)' as 'h_xe'; begin -declare continue handler for 1062 -- ER_DUP_ENTRY +declare continue handler for 1579 -- ER_DUP_ENTRY_WITH_KEY_NAME select 'Inner (good)' as 'h_xe'; insert into t3 values (1); end; @@ -4701,10 +4701,10 @@ insert into t3 values (1)| create procedure bug15011() deterministic begin -declare continue handler for 1062 +declare continue handler for 1579 select 'Outer' as 'Handler'; begin -declare continue handler for 1062 +declare continue handler for 1579 select 'Inner' as 'Handler'; insert into t3 values (1); end; |