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

Optimizer trace: optimize_cond() should show ON expression processing

    XMLWordPrintable

Details

    Description

      optimize_cond prints the rewrites done for WHERE and HAVING:

        "join_optimization": {
          "select_id": 1,
          "steps": [
            {
              "condition_processing": {
                "condition": "WHERE",
                "original_condition": "..."
                "steps": [
                  {
                    "transformation": "equality_propagation",
                    "resulting_condition": "..."
                  },
                  {
                    "transformation": "constant_propagation",
                    "resulting_condition": "..."
                  },
                  {
                    "transformation": "trivial_condition_removal",
                    "resulting_condition": "..."
      

      but it doesn't print the same for ON expressions, which is misleading.
      Make it print that.

      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.