summaryrefslogtreecommitdiff
path: root/mysql-test/r/range.result
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-11-22 22:57:05 +0100
committerunknown <serg@serg.mylan>2004-11-22 22:57:05 +0100
commite4f75be8d4c59d305a2a97cb2a0cfdb80c12f408 (patch)
treef4bb78470b9d12744fe1091be398ea6137419ae3 /mysql-test/r/range.result
parent6627dc7d1bd399e6b2bdac02c6878435f1a96a5d (diff)
downloadmariadb-git-e4f75be8d4c59d305a2a97cb2a0cfdb80c12f408.tar.gz
post-merge
Diffstat (limited to 'mysql-test/r/range.result')
-rw-r--r--mysql-test/r/range.result9
1 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result
index 17e1ee5ea1a..8a1d80e9f79 100644
--- a/mysql-test/r/range.result
+++ b/mysql-test/r/range.result
@@ -218,13 +218,14 @@ drop table t1;
create table t1 (x int, y int, index(x), index(y));
insert into t1 (x) values (1),(2),(3),(4),(5),(6),(7),(8),(9);
update t1 set y=x;
-explain select * from t1, t1 t2 where t1.y = 2 and t2.x between 7 and t1.y+0;
+explain select * from t1, t1 t2 where t1.y = 8 and t2.x between 7 and t1.y+0;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ref y y 5 const 1 Using where
-1 SIMPLE t2 range x x 5 NULL 4 Range checked for each record (index map: 0x1)
-explain select * from t1, t1 t2 where t1.y = 2 and t2.x >= 7 and t2.x <= t1.y+0;
+1 SIMPLE t2 range x x 5 NULL 2 Using where
+explain select * from t1, t1 t2 where t1.y = 8 and t2.x >= 7 and t2.x <= t1.y+0;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
+1 SIMPLE t1 ref y y 5 const 1 Using where
+1 SIMPLE t2 range x x 5 NULL 2 Using where
explain select * from t1, t1 t2 where t1.y = 2 and t2.x between t1.y-1 and t1.y+1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ref y y 5 const 1 Using where