Description
case and like query in n1ql:
SELECT 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 'winter' ELSE 'other' END LIKE 'win%';
|
Result of above query in cbas:
"msg": "Syntax error: In line 1 >>SELECT 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 'winter' ELSE 'other' END LIKE 'win%';<< Encountered 'like' \"LIKE\" at column 188. "
|
Removed END keywords from above query and then tried in cbas:
Query issued:
SELECT name, CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' AS period FROM default_shadow WHERE CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' LIKE 'win%';
|
Result:
"msg": "Syntax error: In line 1 >>SELECT name, CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' AS period FROM default_shadow WHERE CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' LIKE 'win%';<< Encountered 'as' \"AS\" at column 80. "
|
}],
|