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

Allow JSON_NORMALIZE before inserting values

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: JSON
    • Labels:
      None

      Description

      Could the possibility be added to normalize any JSON that is inserted/updated by default? This saves a lot of space (if the JSON is formatted / space separated) and should theoretically speed up a handful of other JSON functions.

      Maybe a possible syntax could be something like `ON UPDATE JSON_NORMALIZE`

      This is of course possible with a trigger, but having it built in seems useful.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            tgross35 Trevor Gross
            Votes:
            1 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.