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

[CX] test_case_and_logic_exp fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • CBAS DP
    • CBAS DP
    • analytics
    • None
    • Untriaged
    • Unknown

    Description

      Query issued:
      SELECT DISTINCT name, CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' END AS period FROM default_shadow WHERE CASE WHEN join_mo < 3 OR join_mo > 11 THEN 1 ELSE 0 END > 0 AND job_title='Sales';
       
      Error message:
      	"msg": "Syntax error: In line 1 >>SELECT DISTINCT name, CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' END AS period FROM default_shadow WHERE CASE WHEN join_mo < 3 OR join_mo > 11 THEN 1 ELSE 0 END > 0 AND job_title='Sales';<< Encountered \">\" at column 184. "
      	}],
       
      This query works well in n1ql.
       
      
      

      Attachments

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

        Activity

          People

            ritesh.agarwal Ritesh Agarwal
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty