Added more test cases

1 files changed, 19 insertions, 0 deletions

diff --git a/mysql-test/t/partition_column.test b/mysql-test/t/partition_column.test
index f551b58119e..ff625acdb1d 100644
--- a/mysql-test/t/partition_column.test
+++ b/mysql-test/t/partition_column.test
@@ -8,6 +8,24 @@
 drop table if exists t1;
 --enable_warnings
 
+create table t1 (a int, b int)
+partition by list column_list(a,b)
+( partition p0 values in (column_list(1, NULL), column_list(2, NULL),
+                          column_list(NULL, NULL)),
+  partition p1 values in (column_list(1,1), column_list(2,2)),
+  partition p2 values in (column_list(3, NULL), column_list(NULL, 1)));
+insert into t1 values (3, NULL);
+insert into t1 values (NULL, 1);
+insert into t1 values (NULL, NULL);
+insert into t1 values (1, NULL);
+insert into t1 values (2, NULL);
+insert into t1 values (1,1);
+insert into t1 values (2,2);
+select * from t1 where a = 1;
+select * from t1 where a = 2;
+show create table t1;
+drop table t1;
+
 --error ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR
 create table t1 (a int)
 partition by list (a)
@@ -38,6 +56,7 @@ insert into t1 values (4);
 insert into t1 values (NULL);
 --error ER_NO_PARTITION_FOR_GIVEN_VALUE
 insert into t1 values (5);
+show create table t1;
 drop table t1;
 
 create table t1 (a int, b char(10), c varchar(25), d datetime)