diff options
| author | unknown <mskold@mysql.com> | 2006-02-15 12:52:30 +0100 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2006-02-15 12:52:30 +0100 |
| commit | f8b27ebb54259d2e148db62ddd65761fe1ea36a9 (patch) | |
| tree | 53accc5efd3eed2f105b7864fe571d63b778ba78 /mysql-test | |
| parent | 0c8d763e81d72fd0fdf5ca08476192d935967efe (diff) | |
| parent | aa796cab7dac5bb8a9ce311b558cdfb96f7b3ece (diff) | |
| download | mariadb-git-f8b27ebb54259d2e148db62ddd65761fe1ea36a9.tar.gz | |
Merge mskold@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into mysql.com:/usr/local/home/marty/MySQL/mysql-5.1-work
sql/sql_partition.cc:
Auto merged
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/partition.result | 11 | ||||
| -rw-r--r-- | mysql-test/t/partition.test | 12 |
2 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index ea88efa6d73..699f448689b 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -289,3 +289,14 @@ select * from t1 where f1 = 2; f1 f2 f3 2 2 2 drop table t1; +create table t1 (f1 integer,f2 integer, unique index(f1)) +partition by range(f1 div 2) +subpartition by hash(f1) subpartitions 2 +(partition partb values less than (2), +partition parte values less than (4), +partition partf values less than (10000)); +insert into t1 values(10,1); +select * from t1 where f1 = 10; +f1 f2 +10 1 +drop table t1; diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test index 9b688525dfb..fd7e3bf7b70 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -368,3 +368,15 @@ insert into t1 values(2,2,'2'); select * from t1 where f1 = 2; drop table t1; +# +# Bug #16907 Partitions: crash, SELECT goes into last partition, UNIQUE INDEX +# +create table t1 (f1 integer,f2 integer, unique index(f1)) +partition by range(f1 div 2) +subpartition by hash(f1) subpartitions 2 +(partition partb values less than (2), +partition parte values less than (4), +partition partf values less than (10000)); +insert into t1 values(10,1); +select * from t1 where f1 = 10; +drop table t1; |