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

Explain plan/Plan text error from query workbench

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.1.0
    • 7.0.3, 7.0.4
    • UI
    • None
    • Untriaged
    • 1
    • Unknown

    Description

      Verified this on both 7.0.3 and 7.0.4, the issue is consistent and not happening on 7.1.1.

      Error with explain plan: Query error: Internal error generating query plan: TypeError: undefined is not an object (evaluating 'result.all_paths_used.forEach')

      Steps to reproduce:

      • Create a 1 node cluster with (KV+N1QL+GSI) and a test bucket
      • Create primary index
      • Explain below query from Query Workbench

      SELECT META().id
      		 
      FROM `test`
      		 
      WHERE date < DATE_ADD_STR(NOW_UTC(), -2, 'day')

      Explain from CBQ is working fine.

      Issue:

      Attachments

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

        Activity

          People

            eben Eben Haber
            ajay.upputuri Ajay Upputuri
            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