summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition.test
diff options
context:
space:
mode:
authorunknown <mikael@dator5.(none)>2006-06-19 20:56:50 -0400
committerunknown <mikael@dator5.(none)>2006-06-19 20:56:50 -0400
commitd90d673daf4e1ed86e0701a35509f14d750ab9ca (patch)
treee9fe42f606af55a38cf51cdf386a867f0ac6529b /mysql-test/t/partition.test
parentb19c1896adea1166adb8e80552ac3abfa7642205 (diff)
downloadmariadb-git-d90d673daf4e1ed86e0701a35509f14d750ab9ca.tar.gz
BUG#17138: Error in stored procedure due to fatal error when not really
a fatal error. New handling of ignore error in place. mysql-test/t/partition.test: New test case sql/ha_ndbcluster.h: New handler method to check if error can be ignored sql/ha_partition.h: New handler method to check if error can be ignored sql/handler.h: New handler method to check if error can be ignored sql/sql_acl.cc: Use new handler method sql/sql_insert.cc: Use new handler method sql/sql_table.cc: Use new handler method sql/sql_union.cc: Use new handler method sql/sql_update.cc: Use new handler method
Diffstat (limited to 'mysql-test/t/partition.test')
-rw-r--r--mysql-test/t/partition.test23
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test
index 05adb6866db..3037c409165 100644
--- a/mysql-test/t/partition.test
+++ b/mysql-test/t/partition.test
@@ -1135,4 +1135,27 @@ alter table t1 drop partition p2;
use test;
drop database db99;
+#
+#BUG 17138 Problem with stored procedure and analyze partition
+#
+create table t1 (a int)
+partition by list (a)
+(partition p0 values in (0));
+
+insert into t1 values (0);
+delimiter //;
+
+create procedure po ()
+begin
+ begin
+ declare continue handler for sqlexception begin end;
+ update ignore t1 set a = 1 where a = 0;
+ end;
+ prepare stmt1 from 'alter table t1';
+ execute stmt1;
+end//
+
+call po()//
+delimiter ;//
+drop table t1;
--echo End of 5.1 tests