In this case I created two tables
root@maria3310.sock>[employees]>show create table emp31\G
*************************** 1. row ***************************
       Table: emp31
Create Table: CREATE TABLE `emp31` (
  `emp_no` int(11) NOT NULL,
  `birth_date` date NOT NULL,
  `first_name` varchar(14) NOT NULL,
  `last_name` varchar(16) NOT NULL,
  `gender` enum('M','F') NOT NULL,
  `hire_date` date NOT NULL,
  `n1` varchar(10) DEFAULT NULL,
  `n2` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`emp_no`,`birth_date`),
  KEY `idx_emp3_n1` (`first_name`,`birth_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
1 row in set (0.000 sec)
root@maria3310.sock>[employees]>show create table emp3\G
*************************** 1. row ***************************
       Table: emp3
Create Table: CREATE TABLE `emp3` (
  `emp_no` int(11) NOT NULL,
  `birth_date` date NOT NULL,
  `first_name` varchar(14) NOT NULL,
  `last_name` varchar(16) NOT NULL,
  `gender` enum('M','F') NOT NULL,
  `hire_date` date NOT NULL,
  `n1` varchar(10) DEFAULT NULL,
  `n2` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`emp_no`,`birth_date`),
  KEY `idx_emp3_n1` (`first_name`,`birth_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
 PARTITION BY RANGE (to_days(`birth_date`))
(PARTITION `p202102` VALUES LESS THAN (738215) ENGINE = InnoDB,
 PARTITION `p202103` VALUES LESS THAN (738246) ENGINE = InnoDB,
 PARTITION `p202104` VALUES LESS THAN (738276) ENGINE = InnoDB,
 PARTITION `p202105` VALUES LESS THAN (738307) ENGINE = InnoDB,
 PARTITION `p202106` VALUES LESS THAN (738337) ENGINE = InnoDB,
 PARTITION `p202107` VALUES LESS THAN (738368) ENGINE = InnoDB,
 PARTITION `p202108` VALUES LESS THAN (738399) ENGINE = InnoDB,
 PARTITION `p202109` VALUES LESS THAN (738429) ENGINE = InnoDB,
 PARTITION `pmax` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
1 row in set (0.000 sec)


root@maria3310.sock>[employees]>desc select * from emp3 where first_name='Chirstian' and birth_date like '1954%'\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: emp3
         type: ref
possible_keys: idx_emp3_n1
          key: idx_emp3_n1
      key_len: 58
          ref: const
         rows: 9
        Extra: Using where
1 row in set (0.001 sec)

root@maria3310.sock>[employees]>desc select * from emp31 where first_name='Chirstian' and birth_date like '1954%'\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: emp31
         type: ref
possible_keys: idx_emp3_n1
          key: idx_emp3_n1
      key_len: 58
          ref: const
         rows: 1
        Extra: Using index condition
1 row in set (0.000 sec)

partition table emp31 not using icp 