diff options
Diffstat (limited to 'storage/myisammrg/mysql-test/storage_engine/type_char_indexes.rdiff')
| -rw-r--r-- | storage/myisammrg/mysql-test/storage_engine/type_char_indexes.rdiff | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/storage/myisammrg/mysql-test/storage_engine/type_char_indexes.rdiff b/storage/myisammrg/mysql-test/storage_engine/type_char_indexes.rdiff new file mode 100644 index 00000000..797907fa --- /dev/null +++ b/storage/myisammrg/mysql-test/storage_engine/type_char_indexes.rdiff @@ -0,0 +1,20 @@ +--- suite/storage_engine/type_char_indexes.result 2014-10-12 14:22:11.000000000 +0400 ++++ suite/storage_engine/type_char_indexes.reject 2014-10-12 14:22:41.000000000 +0400 +@@ -100,7 +100,7 @@ + Warning 1681 'engine_condition_pushdown=on' is deprecated and will be removed in a future release. + EXPLAIN SELECT c,c20,v16,v128 FROM t1 WHERE c > 'a'; + id select_type table type possible_keys key key_len ref rows Extra +-# # # range c_v c_v # # # Using index condition ++# # # ALL c_v NULL # # # Using where + SELECT c,c20,v16,v128 FROM t1 WHERE c > 'a'; + c c20 v16 v128 + b char3 varchar1a varchar1b +@@ -137,7 +137,7 @@ + r3a + EXPLAIN SELECT c,c20,v16,v128 FROM t1 WHERE v16 = 'varchar1a' OR v16 = 'varchar3a' ORDER BY v16; + id select_type table type possible_keys key key_len ref rows Extra +-# # # range # v16 # # # # ++# # # ALL # NULL # # # # + SELECT c,c20,v16,v128 FROM t1 WHERE v16 = 'varchar1a' OR v16 = 'varchar3a' ORDER BY v16; + c c20 v16 v128 + a char1 varchar1a varchar1b |