diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-10-30 13:18:41 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-10-30 13:47:56 +0200 |
| commit | 5b3be9e1c657c3e44377d3c236ff2c31a04adeee (patch) | |
| tree | 8df41db4276ded92a029e8ed83a4d2863c728789 | |
| parent | cb253b8687092960287c333962d56771f6ad9db8 (diff) | |
| download | mariadb-git-5b3be9e1c657c3e44377d3c236ff2c31a04adeee.tar.gz | |
Try to stabilize main.innodb_ext_key,off
Thanks to Varun Gupta for suggesting this. This seems to
make main.innodb_ext_key,off more stable.
| -rw-r--r-- | mysql-test/main/innodb_ext_key,off.rdiff | 2 | ||||
| -rw-r--r-- | mysql-test/main/innodb_ext_key.result | 6 | ||||
| -rw-r--r-- | mysql-test/main/innodb_ext_key.test | 5 |
3 files changed, 8 insertions, 5 deletions
diff --git a/mysql-test/main/innodb_ext_key,off.rdiff b/mysql-test/main/innodb_ext_key,off.rdiff index 2164c56c5b5..f4eaa4b112c 100644 --- a/mysql-test/main/innodb_ext_key,off.rdiff +++ b/mysql-test/main/innodb_ext_key,off.rdiff @@ -1,3 +1,5 @@ +--- innodb_ext_key.result ++++ innodb_ext_key,off.result @@ -9,7 +9,7 @@ explain select count(*) from lineitem where l_orderkey=130 and l_shipdate='1992-07-01'; diff --git a/mysql-test/main/innodb_ext_key.result b/mysql-test/main/innodb_ext_key.result index dbc201be669..7cc03bee546 100644 --- a/mysql-test/main/innodb_ext_key.result +++ b/mysql-test/main/innodb_ext_key.result @@ -26,12 +26,12 @@ Handler_read_rnd 0 Handler_read_rnd_deleted 0 Handler_read_rnd_next 0 explain -select count(*) from lineitem +select count(*) from lineitem use index(primary) where l_orderkey=130 and l_linenumber=2 and l_shipdate='1992-07-01'; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE lineitem const PRIMARY,i_l_shipdate,i_l_orderkey,i_l_orderkey_quantity PRIMARY 8 const,const 1 +1 SIMPLE lineitem const PRIMARY PRIMARY 8 const,const 1 flush status; -select count(*) from lineitem +select count(*) from lineitem use index(primary) where l_orderkey=130 and l_linenumber=2 and l_shipdate='1992-07-01'; count(*) 1 diff --git a/mysql-test/main/innodb_ext_key.test b/mysql-test/main/innodb_ext_key.test index 9ca9bbd608f..413d5570be5 100644 --- a/mysql-test/main/innodb_ext_key.test +++ b/mysql-test/main/innodb_ext_key.test @@ -17,6 +17,7 @@ use dbt3_s001; --disable_result_log --disable_warnings --source include/dbt3_s001.inc +ANALYZE TABLE lineitem PERSISTENT FOR COLUMNS() INDEXES(); --enable_warnings --enable_result_log --enable_query_log @@ -28,10 +29,10 @@ select count(*) from lineitem where l_orderkey=130 and l_shipdate='1992-07-01'; show status like 'handler_read%'; explain -select count(*) from lineitem +select count(*) from lineitem use index(primary) where l_orderkey=130 and l_linenumber=2 and l_shipdate='1992-07-01'; flush status; -select count(*) from lineitem +select count(*) from lineitem use index(primary) where l_orderkey=130 and l_linenumber=2 and l_shipdate='1992-07-01'; show status like 'handler_read%'; |