Details
Description
Query:
SELECT join_mo,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%'
|
Error:
[
|
{
|
"code": 1,
|
"msg": "Conversion = '''",
|
"query_from_user": "SELECT join_mo,name,CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' END AS period FROM default_shadow \nWHERE CASE WHEN join_mo < 3 OR join_mo > 11 THEN 'winter' ELSE 'other' END LIKE 'win%'"
|
}
|
]
|
But on simply putting the case expression in where in braces, query works:
SELECT join_mo,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%'
|
Query works fine in N1QL both ways.