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

Query error: Internal error generating query plan (visual AND Plan Text)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • 7.0.0
    • 7.0.0-Beta1
    • UI
    • Windows, Enterprise Edition 7.0.0 build 4602
    • Untriaged
    • 1
    • Unknown

    Description

      Summary: When executing a query with a correlated subquery, I get an error.

      Repro:

      1. Paste the the attached query.
      2. Execute. It can be on any bucket.
      3. Click "Plan" or "Plan Text"

      Expected:

      For "Plan", a visualized query plan. For "Plan Text", the raw information of the query plan.

      Actual:

      For "Plan", see planErrorMessage.txt. For "Plan Text", see planTextErrorMessage.png

      Notes:

      The query executes without error. It's only when clicking "Plan" or "Plan Text" is there an error.

      This error happens on any bucket/collection, regardless of indexing. You can sub out "AdventureWorks2016.Production.Product" in query.n1ql to `travel-sample` or whatever and still get the error.

      Attachments

        1. planErrorMessage.txt
          0.6 kB
        2. planTextErrorMessage.png
          planTextErrorMessage.png
          16 kB
        3. query.n1ql
          0.3 kB
        4. query.n1ql.txt
          0.3 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            eben Eben Haber
            matthew.groves Matthew Groves
            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