diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-02 11:31:05 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-02 11:31:05 +0200 |
| commit | f1437d6afdc53fce49867781b14675003b4a32c3 (patch) | |
| tree | a4e2432ccecf236709f2735f2cd0fe3782123f72 /mysql-test/t/partition_column.test | |
| parent | d0627362adee94d0cac63426a045365f8d8109fd (diff) | |
| download | mariadb-git-f1437d6afdc53fce49867781b14675003b4a32c3.tar.gz | |
BUG#47754, used number of parts instead of number of list values as end part for list partitioning in column list partitioning
Diffstat (limited to 'mysql-test/t/partition_column.test')
| -rw-r--r-- | mysql-test/t/partition_column.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/partition_column.test b/mysql-test/t/partition_column.test index ff625acdb1d..4edb03405b5 100644 --- a/mysql-test/t/partition_column.test +++ b/mysql-test/t/partition_column.test @@ -14,6 +14,9 @@ partition by list column_list(a,b) 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))); +# +# BUG#47754 Crash when selecting using NOT BETWEEN for column list partitioning +# insert into t1 values (3, NULL); insert into t1 values (NULL, 1); insert into t1 values (NULL, NULL); @@ -23,6 +26,8 @@ insert into t1 values (1,1); insert into t1 values (2,2); select * from t1 where a = 1; select * from t1 where a = 2; +select * from t1 where a > 8; +select * from t1 where a not between 8 and 8; show create table t1; drop table t1; |