From 09580562a2f5e34583fb4d4448c908c1c0802882 Mon Sep 17 00:00:00 2001 From: Mikael Ronstrom Date: Thu, 5 Nov 2009 15:42:03 +0100 Subject: 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 --- mysql-test/t/partition_innodb.test | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'mysql-test/t/partition_innodb.test') 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 @@ -5,6 +5,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 # -- cgit v1.2.1