Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9255

Add generation_expression to information_schema.columns

Details

    • 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

          Task - A task that needs to be done. MDEV-11786 generated columns in the information_schema

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12047 Information Schema does not show virtual / persisted column defintions

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            swillits Seth Willits created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Priority Minor [ 4 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Labels 10.2-ga
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik added a comment -

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

            serg Sergei Golubchik added a comment - SQL standard INFORMATION_SCHEMA.COLUMNS table has IS_GENERATED and GENERATED_EXPRESSION columns. Other tables might have something too, this needs to be checked.
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            alvinr Alvin Richards (Inactive) made changes -
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.6-1 [ 146 ]
            holyfoot Alexey Botchkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - Patch proposal: http://lists.askmonty.org/pipermail/commits/2017-March/010904.html
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.6-1 [ 146 ] 10.2.6-2 [ 148 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2017-March/010929.html
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            holyfoot Alexey Botchkov made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            holyfoot Alexey Botchkov made changes -
            issue.field.resolutiondate 2017-03-28 19:56:41.0 2017-03-28 19:56:41.72
            holyfoot Alexey Botchkov made changes -
            Component/s Dynamic Columns [ 10103 ]
            Fix Version/s 10.2.4 [ 22116 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 73110 ] MariaDB v4 [ 132755 ]

            People

              holyfoot Alexey Botchkov
              swillits Seth Willits
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.