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

EXPLAIN FORMAT=JSON should show outer_ref_cond

    XMLWordPrintable

    Details

      Description

      EXPLAIN FORMAT=JSON doesn't show outer_ref_table cond.

      This is a condition that is a part of subquery's WHERE condition that

      • depends on outer reference tables (and so this is not a "constant condition")
      • does not depend on any tables in the subquery

      we produce and evaluate it but EXPLAIN FORMAT=JSON doesn't show it.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: