3602 Mattias Jonsson 2009-09-12
post push fix for mysql-pe for bug#20577 and bug#46362.
fix for mysql-pe; 'Using where' should not be in the extra column after MRR and other optimizer changes.
@ mysql-test/r/partition_pruning.result
post push fix for mysql-pe for bug#20577 and bug#46362.
fix for mysql-pe; 'Using where' should not be in the extra column after MRR and other optimizer changes.
modified:
mysql-test/r/partition_pruning.result
3601 Mattias Jonsson 2009-09-12 [merge]
Null merge of bug#35845 (backport to 5.1)
=== modified file 'mysql-test/r/partition_pruning.result'
--- a/mysql-test/r/partition_pruning.result 2009-09-01 14:04:56 +0000
+++ b/mysql-test/r/partition_pruning.result 2009-09-11 23:29:44 +0000
@@ -137,7 +137,7 @@ id select_type table partitions type pos
1 SIMPLE t1 pNULL,p1001-01-01,p2001-01-01 range a a 4 NULL 4 Using where; Using index
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a = '1001-00-00';
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 pNULL ref a a 4 const 1 Using where; Using index
+1 SIMPLE t1 pNULL ref a a 4 const 1 Using index
# Disabling warnings for the invalid date
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < '1999-02-31';
id select_type table partitions type possible_keys key key_len ref rows Extra
@@ -466,7 +466,7 @@ id select_type table partitions type pos
1 SIMPLE t1 p2001-01-01,pNULL,p1001-01-01 range a a 4 NULL 4 Using where; Using index
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a = '1001-00-00';
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 pNULL ref a a 4 const 1 Using where; Using index
+1 SIMPLE t1 pNULL ref a a 4 const 1 Using index
# Disabling warnings for the invalid date
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < '1999-02-31';
id select_type table partitions type possible_keys key key_len ref rows Extra
Attachment: [text/bzr-bundle]
| Thread |
|---|
| • bzr push into mysql-pe branch (mattias.jonsson:3601 to 3602) Bug#20577Bug#46362 | Mattias Jonsson | 12 Sep |
