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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1.75d
                1.75d

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.