diff options
author | unknown <sergefp@mysql.com> | 2004-05-13 04:50:54 +0400 |
---|---|---|
committer | unknown <sergefp@mysql.com> | 2004-05-13 04:50:54 +0400 |
commit | aa2bd8ec733b1287068b0940d479afe1bfa85fbc (patch) | |
tree | dfa18c96f72864608b7b8f606e7b2540675df09b | |
parent | fee57535b774e08ab854651badfe59b00b27c185 (diff) | |
download | mariadb-git-aa2bd8ec733b1287068b0940d479afe1bfa85fbc.tar.gz |
Post-merge fixes (code review fixes will follow)
include/my_base.h:
Post-merge fixes
mysql-test/r/index_merge_ror_cpk.result:
Post-merge fixes
mysql-test/r/rowid_order_innodb.result:
Post-merge fixes
-rw-r--r-- | include/my_base.h | 2 | ||||
-rw-r--r-- | mysql-test/r/index_merge_ror_cpk.result | 10 | ||||
-rw-r--r-- | mysql-test/r/rowid_order_innodb.result | 2 |
3 files changed, 7 insertions, 7 deletions
diff --git a/include/my_base.h b/include/my_base.h index 1017a518ae8..481023f39dc 100644 --- a/include/my_base.h +++ b/include/my_base.h @@ -146,7 +146,7 @@ enum ha_extra_function { On-the-fly switching between unique and non-unique key inserting. */ HA_EXTRA_CHANGE_KEY_TO_UNIQUE, - HA_EXTRA_CHANGE_KEY_TO_DUP + HA_EXTRA_CHANGE_KEY_TO_DUP, /* When using HA_EXTRA_KEYREAD, overwrite only key member fields and keep other fields intact. When this is off (by default) InnoDB will use memcpy diff --git a/mysql-test/r/index_merge_ror_cpk.result b/mysql-test/r/index_merge_ror_cpk.result index 10b4b74d3cd..51c1aee5b2c 100644 --- a/mysql-test/r/index_merge_ror_cpk.result +++ b/mysql-test/r/index_merge_ror_cpk.result @@ -41,7 +41,7 @@ pk1 pk2 key1 key2 pktail1ok pktail2ok pktail3bad pktail4bad pktail5bad pk2copy b 1 19 0 0 0 0 0 0 0 19 0 filler-data-19 filler2 explain select pk1,pk2 from t1 where key1 = 10 and key2=10 and 2*pk1+1 < 2*96+1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge key1,key2 intr(key1,key2) 4,4 NULL 1 Using where; Using index +1 SIMPLE t1 index_merge key1,key2 key1,key2 4,4 NULL 1 Using where; Using index select pk1,pk2 from t1 where key1 = 10 and key2=10 and 2*pk1+1 < 2*96+1; pk1 pk2 95 50 @@ -59,13 +59,13 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref key1 key1 4 const 101 Using where explain select * from t1 where pk1 < 7500 and key1 = 10; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge PRIMARY,key1 intr(key1:PRIMARY) 4:4 NULL 38 Using where +1 SIMPLE t1 index_merge PRIMARY,key1 key1,PRIMARY 4,4 NULL 38 Using where explain select * from t1 where pktail1ok=1 and key1=10; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge key1,pktail1ok intr(key1,pktail1ok) 4,4 NULL 1 Using where +1 SIMPLE t1 index_merge key1,pktail1ok key1,pktail1ok 4,4 NULL 1 Using where explain select * from t1 where pktail2ok=1 and key1=10; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge key1,pktail2ok intr(key1,pktail2ok) 4,4 NULL 1 Using where +1 SIMPLE t1 index_merge key1,pktail2ok key1,pktail2ok 4,4 NULL 1 Using where explain select * from t1 where pktail3bad=1 and key1=10; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref key1,pktail3bad pktail3bad 4 const 98 Using where @@ -77,7 +77,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref key1,pktail5bad pktail5bad 4 const 99 Using where explain select pk1,pk2,key1,key2 from t1 where key1 = 10 and key2=10 limit 10; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge key1,key2 intr(key1,key2) 4,4 NULL 1 Using where; Using index +1 SIMPLE t1 index_merge key1,key2 key1,key2 4,4 NULL 1 Using where; Using index select pk1,pk2,key1,key2 from t1 where key1 = 10 and key2=10 limit 10; pk1 pk2 key1 key2 95 50 10 10 diff --git a/mysql-test/r/rowid_order_innodb.result b/mysql-test/r/rowid_order_innodb.result index b1de1b37e73..60d237a977c 100644 --- a/mysql-test/r/rowid_order_innodb.result +++ b/mysql-test/r/rowid_order_innodb.result @@ -14,7 +14,7 @@ insert into t1 values (-5, 1, 1), (10, 1, 1); explain select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL 4 Using where +1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL 6 Using where select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3; pk1 key1 key2 -100 1 1 |