Details
-
Task
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
Description
System-versioned tables can be recognized in information_schema by TABLES.TABLE_TYPE being SYSTEM VERSIONED. Application-time period tables, however, are indistinguishable. They present in TABLES view as BASE TABLE, and the period looks like a regular check constraint both in CHECK_CONSTRAINTS and TABLE_CONSTRAINTS. As discussed earlier on Slack, the standard defines some period-specific views, I think at least most basic ones should be added.
Attachments
Issue Links
- is duplicated by
-
MDEV-29055 There is no data on PERIOD FOR in information schema
-
- Closed
-