-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 2.6.1
-
Component/s: metadata
-
Labels:None
Temporal Data Tables are not currently handled well in metadata:
Using 'SHOW FULL TABLES FROM db;' System-Versioned Tables appear as 'BASE TABLE', but in information_schema.tables, System-Versioned Tables are listed as 'SYSTEM VERSIONED' (Period table appear as 'BASE TABLE')
This result in DatabaseMetaData.getTables​() not listing system versioned tables.
They must be listed as any standard tables.
- relates to
-
MDEV-22049 System-Versioned Tables appears as BASE TABLE for SHOW FULL TABLES
-
- Confirmed
-