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

Nested CTE query hangs forever

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 6.5.0
    • 6.5.0
    • query
    • None
    • Untriaged
    • No

    Description

      the following query works fine:

      with b as (select raw field1 from default d1 limit 1) select raw field2 from default d2 where field1 in b limit 1

      But if I nest this query as another CTE it hangs forever:

      with a as (<---> with b as (select raw field1 from default d1 limit 1) select raw field2 from default d2 where field1 in b limit 1 <---> ) select 1 limit 1

      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)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty