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

query the metadata of a dynamic column

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Dynamic Columns
    • None

    Description

      The set of SQL functions for dynamic columns is missing a way to query the metadata of a dynamic column. Like, what type a particular column has, number of columns, and so on. There can also be a function to return both the value and a type as an SQL-compatible cast:

      SELECT COLUMN_GET_SQL(dyncol, 'a') FROM t1;
      +-------------------------------+
      | COLUMN_GET_SQL(dyncol, 'a')   |
      +-------------------------------+
      | CAST(123.45 AS DECIMAL(10,2)) |
      +-------------------------------+

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              serg Sergei Golubchik
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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