Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32227

Partition Table do not using (Using index condition) ICP

Details

    Description

      In this case I created two tables

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12404 index condition pushdown on partitioned tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21625 Index condition pushdown is not used with ref access of partitioned tables

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            qidan3500 ZHENG SONGHUA created issue -
            qidan3500 ZHENG SONGHUA made changes -
            Field Original Value New Value
            Affects Version/s 10.4.25 [ 27510 ]
            Affects Version/s 10.2.25 [ 23408 ]
            qidan3500 ZHENG SONGHUA made changes -
            Environment all OS LINUX
            qidan3500 ZHENG SONGHUA made changes -
            Description 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
            		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
            qidan3500 ZHENG SONGHUA made changes -
            Description 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
            In this case I created two tables

















            qidan3500 ZHENG SONGHUA made changes -
            Description
            In this case I created two tables

















            		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)















            qidan3500 ZHENG SONGHUA made changes -
            Description 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)















            		In this case I created two tables
            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)















            qidan3500 ZHENG SONGHUA made changes -
            Description In this case I created two tables
            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)















            		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
            qidan3500 ZHENG SONGHUA made changes -
            Description 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             		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 NU{quote}quoted text{quote}LL,
              `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
            qidan3500 ZHENG SONGHUA made changes -
            Description 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 NU{quote}quoted text{quote}LL,
              `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             		In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** 1. row ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            qidan3500 ZHENG SONGHUA made changes -
            Description In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** 1. row ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            		-deleted text-In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** 1. ro{{monospaced text}}w ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            qidan3500 ZHENG SONGHUA made changes -
            Description -deleted text-In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** 1. ro{{monospaced text}}w ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            		In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** 1. ro{{monospaced text}}w ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            qidan3500 ZHENG SONGHUA made changes -
            Description In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** 1. ro{{monospaced text}}w ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            		In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            qidan3500 ZHENG SONGHUA made changes -
            Description In this case I created two tables
            root@maria3310.sock>[employees]>show create table emp31
            *************************** ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            		~subscript text~
             In this case I created two tables
            root@maria3310.sock>[employees ]>show create table emp31
            *************************** ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            ~subscript text~
            qidan3500 ZHENG SONGHUA made changes -
            Description ~subscript text~
             In this case I created two tables
            root@maria3310.sock>[employees ]>show create table emp31
            *************************** ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
              `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            ~subscript text~             		~subscript text~
             In this case I created two tables
            root@maria3310.sock>[employees ]>show create table emp31
            *************************** ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
            # `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            ~subscript text~
            qidan3500 ZHENG SONGHUA made changes -
            Description ~subscript text~
             In this case I created two tables
            root@maria3310.sock>[employees ]>show create table emp31
            *************************** ***************************
                   Table: emp31
            Create Table: CREATE TABLE `emp31` (
              `emp_no` int(11) NOT NULL,
            # `birth_date` date NOT NU{quote}quoted text{quote}LL,
              `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
            *************************** 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)
            ~subscript text~
            qidan3500 ZHENG SONGHUA made changes -
            Attachment 11111.sql [ 72065 ]
            qidan3500 ZHENG SONGHUA made changes -
            Attachment 11111.sql [ 72065 ]
            qidan3500 ZHENG SONGHUA made changes -
            Description In this case I created two tables
            qidan3500 ZHENG SONGHUA made changes -
            Attachment 11111.sql [ 72066 ]
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Fix Version/s N/A [ 14700 ]
            Resolution Duplicate [ 3 ]
            Status Open [ 1 ] Closed [ 6 ]

            People

              Unassigned Unassigned
              qidan3500 ZHENG SONGHUA
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.