create table t1(a int);
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

create table t2(a int);
insert into t2 select A.a + B.a* 10 + C.a * 100 from t1 A, t1 B, t1 C;

create table t3(a int, b int);
insert into t3 select a,a from t1;

create table t4(a int, b int, c int, filler char(100), key (a,b));
insert into t4 select a,a,a, 'filler-data' from t2;

set optimizer_switch='mrr=on';
set join_cache_level=6;
explain
select * from t3,t4 where t3.a=t4.a and (t4.b+1 <= t3.b+1);
+------+-------------+-------+------+---------------+------+---------+---------+------+------------------------------------------------------------------------------------+
| id   | select_type | table | type | possible_keys | key  | key_len | ref     | rows | Extra                                                                              |
+------+-------------+-------+------+---------------+------+---------+---------+------+------------------------------------------------------------------------------------+
|    1 | SIMPLE      | t3    | ALL  | NULL          | NULL | NULL    | NULL    |   10 | Using where                                                                        |
|    1 | SIMPLE      | t4    | ref  | a             | a    | 5       | j2.t3.a |    1 | Using index condition(BKA); Using join buffer (flat, BKA join); Rowid-ordered scan |
+------+-------------+-------+------+---------------+------+---------+---------+------+------------------------------------------------------------------------------------+

 {
  "query_block": {
    "select_id": 1,
    "r_loops": 1,
    "r_total_time_ms": 3.0276,
    "table": {
      "table_name": "t3",
      "access_type": "ALL",
      "r_loops": 1,
      "rows": 10,
      "r_rows": 10,
      "r_total_time_ms": 0.5097,
      "filtered": 100,
      "r_filtered": 100,
      "attached_condition": "(t3.a is not null)"
    },
    "block-nl-join": {
      "table": {
        "table_name": "t4",
        "access_type": "ref",
        "possible_keys": ["a"],
        "key": "a",
        "key_length": "5",
        "used_key_parts": ["a"],
        "ref": ["j2.t3.a"],
        "r_loops": 0,
        "rows": 1,
        "r_rows": null,
        "r_total_time_ms": 0.8301,
        "filtered": 100,
        "r_filtered": null,
        "index_condition_bka": "((t4.b + 1) <= (t3.b + 1))"
      },
      "buffer_type": "flat",
      "buffer_size": "256Kb",
      "join_type": "BKA",
      "mrr_type": "Rowid-ordered scan",
      "r_filtered": 100
    }
  }
}