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

query the metadata of a dynamic column

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Dynamic Columns
    • Labels:
      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

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

                Dates

                Created:
                Updated:

                  Git Integration