diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-28 18:22:36 +0100 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-28 18:22:36 +0100 |
| commit | 072c13d9395b6a3f3a472633d6e817db9215d81e (patch) | |
| tree | 0891f6df26609fa66b89a4cc8faa8079ec21f6f3 /mysql-test/t/partition_pruning.test | |
| parent | cd6e15989044e5d4a708a6ee191bcd3c13dc0071 (diff) | |
| parent | 10fed1aca0096acb135c2065233e84d61b00b9cf (diff) | |
| download | mariadb-git-072c13d9395b6a3f3a472633d6e817db9215d81e.tar.gz | |
Merged WL#3352 into mysql-next-mr
Diffstat (limited to 'mysql-test/t/partition_pruning.test')
| -rw-r--r-- | mysql-test/t/partition_pruning.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/partition_pruning.test b/mysql-test/t/partition_pruning.test index ea72cef5b62..fd3f7f2c322 100644 --- a/mysql-test/t/partition_pruning.test +++ b/mysql-test/t/partition_pruning.test @@ -51,6 +51,26 @@ INSERT INTO t1 VALUES ('0000-00-00'), ('0000-01-02'), ('0001-01-01'), ALTER TABLE t1 DROP KEY a; --source include/partition_date_range.inc DROP TABLE t1; +--echo # TO_SECONDS, test of LIST and index +CREATE TABLE t1 (a DATE, KEY(a)) +PARTITION BY LIST (TO_SECONDS(a)) +(PARTITION `p0001-01-01` VALUES IN (TO_SECONDS('0001-01-01')), + PARTITION `p2001-01-01` VALUES IN (TO_SECONDS('2001-01-01')), + PARTITION `pNULL` VALUES IN (NULL), + PARTITION `p0000-01-02` VALUES IN (TO_SECONDS('0000-01-02')), + PARTITION `p1001-01-01` VALUES IN (TO_SECONDS('1001-01-01'))); +if ($verify_without_partitions) +{ +ALTER TABLE t1 REMOVE PARTITIONING; +} +INSERT INTO t1 VALUES ('0000-00-00'), ('0000-01-02'), ('0001-01-01'), + ('1001-00-00'), ('1001-01-01'), ('1002-00-00'), ('2001-01-01'); +--source include/partition_date_range.inc +--echo # test without index +ALTER TABLE t1 DROP KEY a; +--source include/partition_date_range.inc +DROP TABLE t1; + # # Bug#46362: Endpoint should be set to false for TO_DAYS(DATE) |