diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-03-27 10:03:28 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-03-27 10:03:28 +0100 |
| commit | 6599fd3e9c23a8957a63146cbe6a0ffc4c292a3d (patch) | |
| tree | 5a7e05e0a9abb5f5cc2672bc3d545ac3f5f7fa43 /mysql-test/r/partition_pruning.result | |
| parent | 102a7a2a763dc5f2da8dd1f9ca9a53664c5aad6a (diff) | |
| parent | e308d7417bc4ceb1b3b72cac2642015b88f310ff (diff) | |
| download | mariadb-git-6599fd3e9c23a8957a63146cbe6a0ffc4c292a3d.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/r/partition_pruning.result')
| -rw-r--r-- | mysql-test/r/partition_pruning.result | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/r/partition_pruning.result b/mysql-test/r/partition_pruning.result index ec7fd798d4c..f4d473c00d5 100644 --- a/mysql-test/r/partition_pruning.result +++ b/mysql-test/r/partition_pruning.result @@ -2235,9 +2235,10 @@ 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 NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +1 SIMPLE t1 p20090401 ALL NULL NULL NULL NULL 2 Using where 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, |