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.
|
|
|