summaryrefslogtreecommitdiffstats
path: root/storage/myisammrg/mysql-test/storage_engine/type_char_indexes.rdiff
blob: 797907fa71a14ada1c3ab717bc809b8c7ab5c9cd (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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