summaryrefslogtreecommitdiff
path: root/mysql-test/t/sp.test
diff options
context:
space:
mode:
authorunknown <monty@narttu.mysql.fi>2007-01-22 19:18:22 +0200
committerunknown <monty@narttu.mysql.fi>2007-01-22 19:18:22 +0200
commita043cd152da16624b74ec9ee4d259b4570ef4dcd (patch)
treee1f7760d143c61bab6297ac28959e5b752a764ed /mysql-test/t/sp.test
parent10f4f15e83f19d85cae4bff9240973c216ea98c7 (diff)
parentb4f80eedf3c25773d1e116ab915138096ec713f3 (diff)
downloadmariadb-git-a043cd152da16624b74ec9ee4d259b4570ef4dcd.tar.gz
Merge bk-internal.mysql.com:/home/bk/mysql-5.1
into mysql.com:/home/my/mysql-5.1 BUILD/SETUP.sh: Auto merged mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test: Auto merged mysql-test/extra/rpl_tests/rpl_row_basic.test: Auto merged mysql-test/include/mix1.inc: Auto merged mysql-test/r/sp.result: Auto merged mysql-test/r/view.result: Auto merged mysql-test/t/ctype_utf8.test: Auto merged mysql-test/t/delayed.test: Auto merged mysql-test/t/innodb.test: Auto merged mysql-test/t/insert_select.test: Auto merged mysql-test/t/myisam.test: Auto merged mysql-test/t/ndb_index_unique.test: Auto merged mysql-test/t/rpl_row_create_table.test: Auto merged mysql-test/t/rpl_sp.test: Auto merged mysql-test/t/sp.test: Auto merged mysql-test/t/type_binary.test: Auto merged mysql-test/t/type_varchar.test: Auto merged mysql-test/t/view.test: Auto merged sql/handler.cc: Auto merged sql/sql_table.cc: Auto merged mysql-test/r/rpl_sp.result: Manual merge mysql-test/t/ndb_update.test: Manual merge sql/share/errmsg.txt: Manual merge
Diffstat (limited to 'mysql-test/t/sp.test')
-rw-r--r--mysql-test/t/sp.test22
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test
index 19c70b1bd1e..326518902d7 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);