summaryrefslogtreecommitdiff
path: root/mysql-test/main/innodb_ext_key.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2020-10-30 11:04:16 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2020-10-30 11:04:16 +0200
commit199863d72b7cccaa4c75641c50c45a83b568ab8c (patch)
tree4a5e71963b2fd64141439552c1493d4ab368c3b9 /mysql-test/main/innodb_ext_key.result
parent99362359850d3cece6e465788827aef7e8c33ca6 (diff)
downloadmariadb-git-199863d72b7cccaa4c75641c50c45a83b568ab8c.tar.gz
MDEV-23991 fixup: Initialize the memory
Also, revert the work-around for the test that was attempted in commit 85613a32477ef4b8fb9aefba5f61689028f3ff87. This issue was caught by MemorySanitizer as well as on the Microsoft Windows debug builds, thanks to /MD being used starting with 10.4. The code fix will also be applied to 10.2 because the regression was introduced in commit afc9d00c66db946c8240fe1fa6b345a3a8b6fec1.
Diffstat (limited to 'mysql-test/main/innodb_ext_key.result')
-rw-r--r--mysql-test/main/innodb_ext_key.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/innodb_ext_key.result b/mysql-test/main/innodb_ext_key.result
index 6725e91a137..dbc201be669 100644
--- a/mysql-test/main/innodb_ext_key.result
+++ b/mysql-test/main/innodb_ext_key.result
@@ -204,6 +204,12 @@ Handler_read_retry 0
Handler_read_rnd 3
Handler_read_rnd_deleted 0
Handler_read_rnd_next 0
+explain
+select l_orderkey, l_linenumber from lineitem
+where l_shipdate='1992-07-01' and l_orderkey between 1 and 1000
+or l_receiptdate='1992-07-01' and l_orderkey between 5001 and 6000;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE lineitem index_merge PRIMARY,i_l_shipdate,i_l_receiptdate,i_l_orderkey,i_l_orderkey_quantity i_l_shipdate,i_l_receiptdate # NULL # Using
flush status;
select l_orderkey, l_linenumber from lineitem
where l_shipdate='1992-07-01' and l_orderkey between 1 and 1000