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/r/partition_column.result | |
| 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/r/partition_column.result')
| -rw-r--r-- | mysql-test/r/partition_column.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/partition_column.result b/mysql-test/r/partition_column.result index 66308321a95..43538cb7c69 100644 --- a/mysql-test/r/partition_column.result +++ b/mysql-test/r/partition_column.result @@ -20,6 +20,15 @@ select * from t1 where a = 2; a b 2 NULL 2 2 +select * from t1 where a > 8; +a b +select * from t1 where a not between 8 and 8; +a b +2 NULL +2 2 +3 NULL +1 NULL +1 1 show create table t1; Table Create Table t1 CREATE TABLE `t1` ( |