[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: |
|
||||||||||||
| 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: |
| Comment by Alexey Botchkov [ 2017-03-27 ] |
|
http://lists.askmonty.org/pipermail/commits/2017-March/010929.html |