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

Optimizer trace: optimize_cond() should show ON expression processing

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

          There are no comments yet on this issue.

          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.