Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.6-2
Description
In MySQL the information_schema.columns table has a generation_expression column containing the expression used for generated columns. In MariaDB this column is missing, which makes it more difficult for third party software to interplay with both MariaDB and MySQL by looking for this schema data in one location. Instead, it seems MariaDB only contains this information in the table's create statement which must be parsed — a non-trivial and fragile task.
Attachments
Issue Links
- duplicates
-
MDEV-11786 generated columns in the information_schema
-
- Closed
-
- is duplicated by
-
MDEV-12047 Information Schema does not show virtual / persisted column defintions
-
- Closed
-
SQL standard INFORMATION_SCHEMA.COLUMNS table has IS_GENERATED and GENERATED_EXPRESSION columns. Other tables might have something too, this needs to be checked.