summaryrefslogtreecommitdiff
path: root/mysql-test/r/index_merge_innodb.result
diff options
context:
space:
mode:
authorunknown <sergefp@mysql.com>2003-11-24 20:54:57 +0300
committerunknown <sergefp@mysql.com>2003-11-24 20:54:57 +0300
commitd8010263a5abc731affd3482f117ef219af75d06 (patch)
tree304d96da3c9ae2060fd5dcda3c435cd26bf4a922 /mysql-test/r/index_merge_innodb.result
parent7bdf94993ef67041d9ecf72c4f28ea691d2b5cf7 (diff)
downloadmariadb-git-d8010263a5abc731affd3482f117ef219af75d06.tar.gz
Post-merge fixes for index_merge/Unique/5.0
mysql-test/r/index_merge.result: Post-merge fixes mysql-test/r/index_merge_innodb.result: Post-merge fixes sql/opt_range.cc: Post-merge fixes sql/opt_range.h: Post-merge fixes
Diffstat (limited to 'mysql-test/r/index_merge_innodb.result')
-rw-r--r--mysql-test/r/index_merge_innodb.result16
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/index_merge_innodb.result b/mysql-test/r/index_merge_innodb.result
index ef6ffa82da7..dc1fdd97723 100644
--- a/mysql-test/r/index_merge_innodb.result
+++ b/mysql-test/r/index_merge_innodb.result
@@ -24,8 +24,8 @@ key1 key2
0 200
1 199
2 198
-4 196
3 197
+4 196
alter table t1 add str1 char (255) not null,
add zeroval int not null default 0,
add str2 char (255) not null,
@@ -37,19 +37,19 @@ id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index_merge i1,i2 i1,i2 4,4 NULL 8 Using where
select * from t1 where key1 < 5 or key2 > 197;
key1 key2 str1 zeroval str2 str3
-0 200 aaa 0 bbb 200-0_a
-1 199 aaa 0 bbb 199-0_A
-2 198 aaa 0 bbb 198-1_a
-3 197 aaa 0 bbb 197-1_A
4 196 aaa 0 bbb 196-2_a
+3 197 aaa 0 bbb 197-1_A
+2 198 aaa 0 bbb 198-1_a
+1 199 aaa 0 bbb 199-0_A
+0 200 aaa 0 bbb 200-0_a
explain select * from t1 where key1 < 3 or key2 > 195;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index_merge i1,i2 i1,i2 4,4 NULL 8 Using where
select * from t1 where key1 < 3 or key2 > 195;
key1 key2 str1 zeroval str2 str3
-0 200 aaa 0 bbb 200-0_a
-1 199 aaa 0 bbb 199-0_A
-2 198 aaa 0 bbb 198-1_a
4 196 aaa 0 bbb 196-2_a
3 197 aaa 0 bbb 197-1_A
+2 198 aaa 0 bbb 198-1_a
+1 199 aaa 0 bbb 199-0_A
+0 200 aaa 0 bbb 200-0_a
drop table t1;