Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3
-
None
Description
Currently I_S.PARTITIONS.PARTITION_DESCRIPTION shows CURRENT for current partitions, rotation timestamp for history partitions limited by time interval, but NULL otherwise – both for unlimited history partitions and for those limited by row number. For consistency it should probably show the limit number for partitions limited by it.
|
10.3 c39f8a80c9 |
MariaDB [db1]> create or replace table t1 (a int) with system versioning partition by system_time limit 100 (partition p0 history, partition pc current); |
Query OK, 0 rows affected (0.41 sec) |
|
|
MariaDB [db1]> select * from information_schema.partitions where table_schema = 'db1' and table_name = 't1' \G |
*************************** 1. row ***************************
|
TABLE_CATALOG: def
|
TABLE_SCHEMA: db1
|
TABLE_NAME: t1
|
PARTITION_NAME: p0
|
SUBPARTITION_NAME: NULL |
PARTITION_ORDINAL_POSITION: 1
|
SUBPARTITION_ORDINAL_POSITION: NULL |
PARTITION_METHOD: SYSTEM_TIME
|
SUBPARTITION_METHOD: NULL |
PARTITION_EXPRESSION: `row_end`
|
SUBPARTITION_EXPRESSION: NULL |
PARTITION_DESCRIPTION: NULL |
TABLE_ROWS: 0
|
AVG_ROW_LENGTH: 0
|
DATA_LENGTH: 16384
|
MAX_DATA_LENGTH: NULL |
INDEX_LENGTH: 0
|
DATA_FREE: 0
|
CREATE_TIME: 2018-04-23 23:15:26
|
UPDATE_TIME: NULL |
CHECK_TIME: NULL |
CHECKSUM: NULL |
PARTITION_COMMENT:
|
NODEGROUP: default |
TABLESPACE_NAME: NULL |
*************************** 2. row ***************************
|
TABLE_CATALOG: def
|
TABLE_SCHEMA: db1
|
TABLE_NAME: t1
|
PARTITION_NAME: pc
|
SUBPARTITION_NAME: NULL |
PARTITION_ORDINAL_POSITION: 2
|
SUBPARTITION_ORDINAL_POSITION: NULL |
PARTITION_METHOD: SYSTEM_TIME
|
SUBPARTITION_METHOD: NULL |
PARTITION_EXPRESSION: `row_end`
|
SUBPARTITION_EXPRESSION: NULL |
PARTITION_DESCRIPTION: CURRENT |
TABLE_ROWS: 0
|
AVG_ROW_LENGTH: 0
|
DATA_LENGTH: 16384
|
MAX_DATA_LENGTH: NULL |
INDEX_LENGTH: 0
|
DATA_FREE: 0
|
CREATE_TIME: 2018-04-23 23:15:26
|
UPDATE_TIME: NULL |
CHECK_TIME: NULL |
CHECKSUM: NULL |
PARTITION_COMMENT:
|
NODEGROUP: default |
TABLESPACE_NAME: NULL |
2 rows in set (0.02 sec) |