summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition.result
diff options
context:
space:
mode:
authorunknown <mattiasj@mattiasj-laptop.(none)>2007-10-17 20:40:23 +0200
committerunknown <mattiasj@mattiasj-laptop.(none)>2007-10-17 20:40:23 +0200
commitbfc41161b49dec93a1f59e15d5147b3f18fc3578 (patch)
tree54c2a09768bf727ffeae066e153aa0d84d1acbc2 /mysql-test/r/partition.result
parent9105a1d90b78f125738d6fb720d4a1db1632abd6 (diff)
downloadmariadb-git-bfc41161b49dec93a1f59e15d5147b3f18fc3578.tar.gz
Bug #30878: Crashing when alter an auto_increment non partitioned
table to partitioned Problem: Crashed because usage of an uninitialised mutex when auto_incrementing a partitioned temporary table Fix: Only locking (using the mutex) if not temporary table. mysql-test/r/partition.result: Bug #30878: Crashing when alter an auto_increment non partitioned table to partitioned test result mysql-test/t/partition.test: Bug #30878: Crashing when alter an auto_increment non partitioned table to partitioned testcase sql/ha_partition.cc: Bug #30878: Crashing when alter an auto_increment non partitioned table to partitioned If the table is a temporary table, the table_share->mutex is not initialised. Checking if not temporary table, then OK to lock (else no need to lock)
Diffstat (limited to 'mysql-test/r/partition.result')
-rw-r--r--mysql-test/r/partition.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result
index f90f3b07d70..753a2e31632 100644
--- a/mysql-test/r/partition.result
+++ b/mysql-test/r/partition.result
@@ -1,4 +1,16 @@
drop table if exists t1;
+create table t1 (id int auto_increment, s1 int, primary key (id));
+insert into t1 values (null,1);
+insert into t1 values (null,6);
+select * from t1;
+id s1
+1 1
+2 6
+alter table t1 partition by range (id) (
+partition p0 values less than (3),
+partition p1 values less than maxvalue
+);
+drop table t1;
create table t1 (a int)
partition by key(a)
partitions 0.2+e1;