[MDEV-23646] Optimizer trace: optimize_cond() should show ON expression processing Created: 2020-09-01  Updated: 2021-03-23  Resolved: 2021-03-19

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Fix Version/s: 10.6.0

Type: Task Priority: Critical
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: optimizer_trace


 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.


Generated at Thu Feb 08 09:23:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.