[MDEV-9255] Add generation_expression to information_schema.columns Created: 2015-12-09  Updated: 2017-03-28  Resolved: 2017-03-28

Status: Closed
Project: MariaDB Server
Component/s: Dynamic Columns
Fix Version/s: 10.2.4

Type: Task Priority: Major
Reporter: Seth Willits Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: 10.2-ga

Issue Links:
Duplicate
duplicates MDEV-11786 generated columns in the information_... Closed
is duplicated by MDEV-12047 Information Schema does not show virt... Closed
Sprint: 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.



 Comments   
Comment by Sergei Golubchik [ 2017-02-06 ]

SQL standard INFORMATION_SCHEMA.COLUMNS table has IS_GENERATED and GENERATED_EXPRESSION columns. Other tables might have something too, this needs to be checked.

Comment by Alexey Botchkov [ 2017-03-21 ]

Patch proposal:
http://lists.askmonty.org/pipermail/commits/2017-March/010904.html

Comment by Alexey Botchkov [ 2017-03-27 ]

http://lists.askmonty.org/pipermail/commits/2017-March/010929.html

Generated at Thu Feb 08 07:33:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.