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
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
