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

explain on prepared statments is broken

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 6.5.0
    • 6.5.0
    • UI
    • Untriaged
    • Unknown

    Description

      Create default bucket

      create primary index on default

      Run the following:

      EXPLAIN PREPARE join_prepare_2911 from SELECT employee.name, employee.tasks_ids, new_project.project FROM default as employee INNER JOIN default as new_project ON KEYS employee.tasks_ids

      Will throw a syntax error:

      { "code": 3000, "msg": "syntax error - at PREPARE", "query_from_user": "explain PREPARE join_prepare_2911 from SELECT employee.name, employee.tasks_ids, new_project.project FROM default as employee INNER JOIN default as new_project ON KEYS employee.tasks_ids" }

      Alternatively from QWB click explain for:PREPARE join_prepare_2911 from SELECT employee.name, employee.tasks_ids, new_project.project FROM default as employee INNER JOIN default as new_project ON KEYS employee.tasks_ids

      This will hang forever.

      Nothing in the logs.

      Attachments

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

        Activity

          People

            Ofer.Yaakobovitz Ofer Yaakobovitz [X] (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            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