diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-11-05 15:42:03 +0100 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-11-05 15:42:03 +0100 |
| commit | 09580562a2f5e34583fb4d4448c908c1c0802882 (patch) | |
| tree | 2d7883b6f6ed985beb703f0fd5c5e8207e7fce20 /mysql-test/t/partition_innodb.test | |
| parent | 06bfaf21f2965539ab76fed3338b3cb0089adc57 (diff) | |
| download | mariadb-git-09580562a2f5e34583fb4d4448c908c1c0802882.tar.gz | |
BUG#48447, BUG#48161, fixed a regression from fix of BUG#6045, where binary collations can use indexes/partition pruning for cases using equality conditions, however it cannot be used for any other condition like <, >, <=, >=, <>, also added test case for verification of BUG#47774 in this patch
Diffstat (limited to 'mysql-test/t/partition_innodb.test')
| -rw-r--r-- | mysql-test/t/partition_innodb.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/partition_innodb.test b/mysql-test/t/partition_innodb.test index 5aef5dcaa18..2e08834cfc7 100644 --- a/mysql-test/t/partition_innodb.test +++ b/mysql-test/t/partition_innodb.test @@ -6,6 +6,21 @@ drop table if exists t1; --enable_warnings # +# BUG#47774, Assertion failure in InnoDB using column list partitioning +# +create table t1 (a varchar(5), b int signed, c varchar(10), d datetime) +partition by range columns(b,c) +subpartition by hash(to_seconds(d)) +( partition p0 values less than (2, 'b'), + partition p1 values less than (4, 'd'), + partition p2 values less than (10, 'za')); +insert into t1 values ('a', 3, 'w', '2001-10-27 04:34:00'); +insert into t1 values ('r', 7, 'w', '2001-10-27 05:34:00'); +insert into t1 values ('g', 10, 'w', '2001-10-27 06:34:00'); +update t1 set a = 'c' where a > 'f'; +drop table t1; + +# # BUG#47776, Failed to update for MEMORY engine, crash for InnoDB and success for MyISAM # create table t1 (a varchar(5)) |