diff options
| author | Alexander Nozdrin <alik@sun.com> | 2009-11-06 11:56:48 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2009-11-06 11:56:48 +0300 |
| commit | 52b1bfe4050e163d844df1c10c648b33d25e28c5 (patch) | |
| tree | eb2d1324319886b82e2838e7144d856c95683bbd /mysql-test/r/partition_pruning.result | |
| parent | eed607b829e68694ee996092c337ed13846e78ec (diff) | |
| parent | f6868a4eb42f39a5f4e8179b91fe38f0ff299ebe (diff) | |
| download | mariadb-git-52b1bfe4050e163d844df1c10c648b33d25e28c5.tar.gz | |
Manual merge from mysql-trunk-merge.
Fix partition_column.test.
Diffstat (limited to 'mysql-test/r/partition_pruning.result')
| -rw-r--r-- | mysql-test/r/partition_pruning.result | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/mysql-test/r/partition_pruning.result b/mysql-test/r/partition_pruning.result index f59316e9ce8..d7790cd8075 100644 --- a/mysql-test/r/partition_pruning.result +++ b/mysql-test/r/partition_pruning.result @@ -1601,10 +1601,9 @@ INSERT INTO t1 VALUES (1, '2009-01-01'), (2, NULL); # test with an invalid date, which lead to item->null_value is set. EXPLAIN PARTITIONS SELECT * FROM t1 WHERE b < CAST('2009-04-99' AS DATETIME); id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p20090401 ALL NULL NULL NULL NULL 2 Using where +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Warning 1292 Incorrect datetime value: '2009-04-99' -Warning 1292 Incorrect datetime value: '2009-04-99' DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, |