diff options
| author | Igor Babaev <igor@askmonty.org> | 2019-03-14 19:33:13 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2019-03-14 19:33:13 -0700 |
| commit | b234f81037d79b64f46a8de1602a8a7e3a45aada (patch) | |
| tree | 13dea148b0a0542eb351d7aa5aa9607ccf2ef607 | |
| parent | e3ebeebe3a4c14293a48971e0a062008a1473140 (diff) | |
| download | mariadb-git-b234f81037d79b64f46a8de1602a8a7e3a45aada.tar.gz | |
MDEV-18640 TABLE::prune_range_rowid_filters: Conditional jump or move
depends on uninitialized value
This problem most probably was resolved by the patch for MDEV-18816.
This commit adds only the test case from the bug entry.
| -rw-r--r-- | mysql-test/main/rowid_filter.result | 13 | ||||
| -rw-r--r-- | mysql-test/main/rowid_filter.test | 14 |
2 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/main/rowid_filter.result b/mysql-test/main/rowid_filter.result index f0253055065..2fdff7dda90 100644 --- a/mysql-test/main/rowid_filter.result +++ b/mysql-test/main/rowid_filter.result @@ -1974,4 +1974,17 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select 1 AS `1` from `test`.`t1` join `test`.`t2` join `test`.`t1` `t1_a` where 0 drop table t1,t2; +# +# MDEV-18640: TABLE::prune_range_rowid_filters: Conditional jump or +# move depends on uninitialized value +# +CREATE TABLE t1 ( +pk INT, i INT, PRIMARY KEY (pk), KEY (pk,i) +) ENGINE=MyISAM; +INSERT INTO t1 VALUES (1,10), (7,70), (2,20); +SELECT * FROM t1 WHERE pk < 5; +pk i +1 10 +2 20 +DROP TABLE t1; set @@use_stat_tables=@save_use_stat_tables; diff --git a/mysql-test/main/rowid_filter.test b/mysql-test/main/rowid_filter.test index 87e8b2c10dd..d84839bdf53 100644 --- a/mysql-test/main/rowid_filter.test +++ b/mysql-test/main/rowid_filter.test @@ -261,4 +261,18 @@ eval explain extended $q; drop table t1,t2; +--echo # +--echo # MDEV-18640: TABLE::prune_range_rowid_filters: Conditional jump or +--echo # move depends on uninitialized value +--echo # + +CREATE TABLE t1 ( + pk INT, i INT, PRIMARY KEY (pk), KEY (pk,i) +) ENGINE=MyISAM; +INSERT INTO t1 VALUES (1,10), (7,70), (2,20); + +SELECT * FROM t1 WHERE pk < 5; + +DROP TABLE t1; + set @@use_stat_tables=@save_use_stat_tables; |