diff options
author | unknown <sergefp@mysql.com> | 2003-11-24 20:54:57 +0300 |
---|---|---|
committer | unknown <sergefp@mysql.com> | 2003-11-24 20:54:57 +0300 |
commit | d8010263a5abc731affd3482f117ef219af75d06 (patch) | |
tree | 304d96da3c9ae2060fd5dcda3c435cd26bf4a922 /mysql-test/r/index_merge_innodb.result | |
parent | 7bdf94993ef67041d9ecf72c4f28ea691d2b5cf7 (diff) | |
download | mariadb-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.result | 16 |
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; |