← Back to team overview

maria-developers team mailing list archive

Contents of information_schema.partitions.PARTITION_DESCRIPTION for DEFAULT partitions?

 

Hi Sanja,

I'm looking at I_S description for the DEFAULT partition and I see this:

        PARTITION_DESCRIPTION: (MAXVALUE,MAXVALUE)

Is this normal?

The full example below:


show create table t10;
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                         |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t10   | CREATE TABLE `t10` (
  `i` varchar(10) DEFAULT NULL,
  `j` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50500 PARTITION BY LIST  COLUMNS(i,j)
(PARTITION p1 VALUES IN (('10','10')) ENGINE = InnoDB,
 PARTITION p2 DEFAULT ENGINE = InnoDB) */ |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

MariaDB [j4]> select * from information_schema.partitions where table_name='t10'\G
*************************** 1. row ***************************
                TABLE_CATALOG: def
                 TABLE_SCHEMA: j4
                   TABLE_NAME: t10
               PARTITION_NAME: p1
            SUBPARTITION_NAME: NULL
   PARTITION_ORDINAL_POSITION: 1
SUBPARTITION_ORDINAL_POSITION: NULL
             PARTITION_METHOD: LIST COLUMNS
          SUBPARTITION_METHOD: NULL
         PARTITION_EXPRESSION: `i`,`j`
      SUBPARTITION_EXPRESSION: NULL
        PARTITION_DESCRIPTION: ('10','10')
                   TABLE_ROWS: 0
               AVG_ROW_LENGTH: 0
                  DATA_LENGTH: 16384
              MAX_DATA_LENGTH: NULL
                 INDEX_LENGTH: 0
                    DATA_FREE: 0
                  CREATE_TIME: 2016-09-08 21:22:45
                  UPDATE_TIME: NULL
                   CHECK_TIME: NULL
                     CHECKSUM: NULL
            PARTITION_COMMENT: 
                    NODEGROUP: default
              TABLESPACE_NAME: NULL
*************************** 2. row ***************************
                TABLE_CATALOG: def
                 TABLE_SCHEMA: j4
                   TABLE_NAME: t10
               PARTITION_NAME: p2
            SUBPARTITION_NAME: NULL
   PARTITION_ORDINAL_POSITION: 2
SUBPARTITION_ORDINAL_POSITION: NULL
             PARTITION_METHOD: LIST COLUMNS
          SUBPARTITION_METHOD: NULL
         PARTITION_EXPRESSION: `i`,`j`
      SUBPARTITION_EXPRESSION: NULL
        PARTITION_DESCRIPTION: (MAXVALUE,MAXVALUE)
                   TABLE_ROWS: 0
               AVG_ROW_LENGTH: 0
                  DATA_LENGTH: 16384
              MAX_DATA_LENGTH: NULL
                 INDEX_LENGTH: 0
                    DATA_FREE: 0
                  CREATE_TIME: 2016-09-08 21:22:45
                  UPDATE_TIME: NULL
                   CHECK_TIME: NULL
                     CHECKSUM: NULL
            PARTITION_COMMENT: 
                    NODEGROUP: default
              TABLESPACE_NAME: NULL
2 rows in set (0.01 sec)

BR
 Sergei
-- 
Sergei Petrunia, Software Developer
MariaDB Corporation | Skype: sergefp | Blog: http://s.petrunia.net/blog