Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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.
Attachments
Issue Links
- relates to
-
MDEV-22049 System-Versioned Tables appears as BASE TABLE for SHOW FULL TABLES
- Confirmed