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
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 7.0.0-Beta1
    • 7.0.0
    • 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

          Matthew Groves Can you change query.n1ql to query.txt so that it can viewable in browser

          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - Matthew Groves Can you change query.n1ql to query.txt so that it can viewable in browser

          yes

          matthew.groves Matthew Groves added a comment - yes

          Works in cbq shell. It looks like UI parsing error

          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - Works in cbq shell. It looks like UI parsing error
          eben Eben Haber added a comment -

          This is the same problem as MB-42043, which is currently being worked on.

          eben Eben Haber added a comment - This is the same problem as MB-42043 , which is currently being worked on.

          Mass closing all non-fixed bugs

          mihir.kamdar Mihir Kamdar (Inactive) added a comment - Mass closing all non-fixed bugs

          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