Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-31642

Visual explain on statements with WITH clause are incorrect.

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Cannot Reproduce
    • Major
    • None
    • None
    • query_tools
    • None

    Description

      The visual explains only shows one block with WITH clause or few end blocks.

      See examples from the MB-31629

      with with_table as (select * from defMB-31629ault d0 where join_yr == 2010 order by meta(d0).id limit 1) 
      select * 
      from default AS table1 
      join with_table as table2 
      on (table1.join_yr == table2.d0.join_yr)

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            marco.greco Marco Greco (Inactive)
            eben Eben Haber
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty