diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-06 16:22:15 +0200 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-06 16:22:15 +0200 |
| commit | c6e67a9b04289ccf78f5f11485c34875ddf8ad89 (patch) | |
| tree | d9308e481af7e82829423a1f7d70f0ebc9fa598f /mysql-test/r/partition_column.result | |
| parent | 01072e22fe7cc5e7a53e9ea0a065ba22027d52bf (diff) | |
| download | mariadb-git-c6e67a9b04289ccf78f5f11485c34875ddf8ad89.tar.gz | |
BUG#47838, NULL values in ranges was dropped due to missing else part in store_tuple_to_record
Diffstat (limited to 'mysql-test/r/partition_column.result')
| -rw-r--r-- | mysql-test/r/partition_column.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 43538cb7c69..f5b5b49de56 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -1,4 +1,16 @@ drop table if exists t1; +create table t1 (a int signed) +partition by list column_list(a) +( partition p0 values in (column_list(1), column_list(3), column_list(5), +column_list(7), column_list(9), column_list(NULL)), +partition p1 values in (column_list(2), column_list(4), column_list(6), +column_list(8), column_list(0))); +insert into t1 values (NULL),(0),(1),(2),(2),(4),(4),(4),(8),(8); +select * from t1 where a <= 1; +a +1 +0 +drop table t1; 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), |