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

Optimizer Trace: plan_prefix should be a comma-separated-list, not array.

    XMLWordPrintable

Details

    Description

      Optimizer Trace currently prints plan_prefix as an array:

                     "plan_prefix": ["t_outer_1", "t_outer_2", "t_inner_1"],
      

      ... sometimes auto-formatter puts each array element onto its own line.

      This makes it impossible to use grep.

      On the other hand, it doesn't seem to be possible to make any use of the JSON array structure: JSON Path language doesn't provide any convenient way for the most common operation of "find this join prefix".

      So, the suggestion is to change the representation to be comma-separated list:

                       "plan_prefix": "t_outer_1,t_outer_2,t_inner_1",
      

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.