diff options
Diffstat (limited to 'mysql-test/t/sp.test')
-rw-r--r-- | mysql-test/t/sp.test | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 8f4763c636a..9cf95fd484f 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -1763,11 +1763,11 @@ 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); @@ -1777,7 +1777,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 @@ -1823,7 +1823,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 @@ -1842,7 +1842,7 @@ begin 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); @@ -2015,7 +2015,7 @@ begin 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); @@ -4507,7 +4507,7 @@ begin select bug12379(); end| ---error 1062 +--error ER_DUP_ENTRY_WITH_KEY_NAME select bug12379()| select 1| # statement-based binlogging will show warning which row-based won't; @@ -4518,7 +4518,7 @@ select 2| call bug12379_2()| --enable_warnings select 3| ---error 1062 +--error ER_DUP_ENTRY_WITH_KEY_NAME call bug12379_3()| select 4| @@ -4600,7 +4600,7 @@ end| call bug6127()| select * from t3| ---error ER_DUP_ENTRY +--error ER_DUP_ENTRY_WITH_KEY_NAME call bug6127()| select * from t3| set sql_mode=@sm| @@ -5528,11 +5528,11 @@ 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); |