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

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            psergey Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: