summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition.test
diff options
context:
space:
mode:
authorunknown <istruewing@stella.local>2007-11-16 14:07:59 +0100
committerunknown <istruewing@stella.local>2007-11-16 14:07:59 +0100
commit9e63a99d9bc06eb80b0d1559c442e4e487cea989 (patch)
treedea821c80ecfeb109889393532a9a4c1c588d046 /mysql-test/t/partition.test
parent411d9925fb66d5ba651d5e83748256615720900d (diff)
parentf4f7e1f42c831152d750a0f159db7bae1b756601 (diff)
downloadmariadb-git-9e63a99d9bc06eb80b0d1559c442e4e487cea989.tar.gz
Merge stella.local:/home2/mydev/mysql-5.1-amain
into stella.local:/home2/mydev/mysql-5.1-axmrg include/mysql_com.h: Auto merged mysql-test/r/partition.result: Auto merged mysql-test/t/partition.test: Auto merged sql/item_func.cc: Auto merged sql/mysql_priv.h: Auto merged sql/sql_base.cc: Auto merged sql/sql_partition.cc: Auto merged sql/sql_select.cc: Auto merged sql/sql_yacc.yy: Auto merged
Diffstat (limited to 'mysql-test/t/partition.test')
-rw-r--r--mysql-test/t/partition.test21
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test
index 8114b85c0f9..68eff608879 100644
--- a/mysql-test/t/partition.test
+++ b/mysql-test/t/partition.test
@@ -1520,4 +1520,25 @@ PARTITION BY RANGE (b) (
show create table t1;
drop table t1, t2;
+#
+# Bug #32067 Partitions: crash with timestamp column
+# this bug occurs randomly on some UPDATE statement
+# with the '1032: Can't find record in 't1'' error
+
+create table t1
+ (s1 timestamp on update current_timestamp, s2 int)
+ partition by key(s1) partitions 3;
+
+insert into t1 values (null,null);
+--disable_query_log
+let $cnt= 1000;
+while ($cnt)
+{
+ update t1 set s2 = 1;
+ update t1 set s2 = 2;
+ dec $cnt;
+}
+--enable_query_log
+
+drop table t1;
--echo End of 5.1 tests