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

Query with inline function does not produce VISUAL plan,but explain & executes fine.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 6.5.0
    • None
    • query_tools, UI
    • None
    • Untriaged
    • Unknown

    Description

      create a bucket b1;

      create primary index on b1;

      insert into b1 values(UUID(), {"a":1})

      CREATE FUNCTION func(vEmail) { (select * from `travel-sample` where type = vEmail limit 1)};

      select func('hotel')
      from b1;

       

      EXPLAIN: 

      Internal error generating query plan: Error: Parse error on line 1:
      default:func("hotel")
      -------^
      Expecting 'EOF', 'SEMI', 'STAR', 'DOT', 'EQ', 'IN', 'WITHIN', 'NOT', 'LBRACKET', 'PLUS', 'MINUS', 'DIV', 'MOD', 'CONCAT', 'AND', 'OR', 'DEQ', 'NE', 'LT', 'GT', 'LE', 'GE', 'BETWEEN', 'LIKE', 'IS', got 'COLON'

      Attachments

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

        Activity

          People

            eben Eben Haber
            keshav Keshav Murthy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty