diff options
| author | Daniel Black <daniel@mariadb.org> | 2020-12-16 10:26:29 +1100 |
|---|---|---|
| committer | Daniel Black <daniel@mariadb.org> | 2020-12-16 10:26:29 +1100 |
| commit | aebb1112693ebfa33e8e446668292a6124636ad7 (patch) | |
| tree | 5824195cc13e209a324fb89edca31965c2e12ec1 | |
| parent | 2c4761ccc1980421103ed1c82aff8cf2907d962b (diff) | |
| download | mariadb-git-aebb1112693ebfa33e8e446668292a6124636ad7.tar.gz | |
MDEV-21958: postfix - result of range_mrr_icp
| -rw-r--r-- | mysql-test/r/range_mrr_icp.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/range_mrr_icp.result b/mysql-test/r/range_mrr_icp.result index 55613261ce9..3561283044a 100644 --- a/mysql-test/r/range_mrr_icp.result +++ b/mysql-test/r/range_mrr_icp.result @@ -3170,6 +3170,21 @@ pk a b 70 4 40 71 2 20 drop table t1; +create table t1(a int); +insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +create table t2 ( +pk int primary key, +key1 int, +col1 varchar(255), +key (key1, pk) +); +insert into t2 (pk, key1) +select A.a+10 *B.a + 100*C.a, A.a+10 *B.a +100*C.a from t1 A, t1 B, t1 C; +# This must use ALL, not range: +explain select * from t2 force index (primary) where pk not in (1,2,3); +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t2 ALL PRIMARY NULL NULL NULL 1000 Using where +drop table t1,t2; # # End of 10.2 tests # |