summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r--mysql-test/r/sp.result16
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;