create table t1 ( 

  pk int primary key,

  a int, 

  b int,

  c int,

  filler varchar(100),

  key(a,b,c)

) partition by hash(pk) partitions 4;

insert into t1 select seq, seq, seq, seq, 'hello' from seq_1_to_10000;

explain format=json select * from t1 where a < 10 and (b+1>3);

{

  "query_block": {

    "select_id": 1,

    "cost": 0.02196592,

    "nested_loop": [

      {

        "table": {

          "table_name": "t1",

          "partitions": ["p0", "p1", "p2", "p3"],

          "access_type": "range",

          "possible_keys": ["a"],

          "key": "a",

          "key_length": "5",

          "used_key_parts": ["a"],

          "loops": 1,

          "rows": 9,

          "cost": 0.02196592,

          "filtered": 100,

          "attached_condition": "t1.a < 10 and t1.b + 1 > 3"

        }

      }

    ]

  }

}

create table t2 ( 

  pk int primary key,

  a int, 

  b int,

  c int,

  filler varchar(100),

  key(a,b,c)

);

insert into t2 select seq, seq, seq, seq, 'hello' from seq_1_to_10000;

explain format=json select * from t2 where a < 10 and (b+1>3);

{

  "query_block": {

    "select_id": 1,

    "cost": 0.0146548,

    "nested_loop": [

      {

        "table": {

          "table_name": "t2",

          "access_type": "range",

          "possible_keys": ["a"],

          "key": "a",

          "key_length": "5",

          "used_key_parts": ["a"],

          "loops": 1,

          "rows": 9,

          "cost": 0.0146548,

          "filtered": 100,

          "index_condition": "t2.a < 10 and t2.b + 1 > 3"

        }

      }

    ]

  }

}