Forum: Other

Post: Case statement Quote Character ` or '

Case statement Quote Character ` or '
tariqrahiman
Nov 20, 2014
Under the documentation, http://docs.voltdb.com/ReleaseNotes/index.php#ChangesSinceLast it says voltdb supports case statements and has a sample.

SELECT Prod_name,
CASE WHEN price > 100.00
THEN `Expensive`
ELSE `Cheap`
END
FROM products ORDER BY Prod_name

Question: is the quote identifier ` or '
I get General Provider Error (GRACEFUL_FAILURE): 'Unexpected Ad Hoc Planning Error: java.lang.RuntimeException: Error compiling query: org.voltdb.planner.PlanningErrorException: unknown token' if i use `Expensive` as in your sample
rmorgenstein
Nov 20, 2014
It is meant to be the regular single-quote. I will get the release notes updated. Thanks for letting us know.

Ruth
tariqrahiman
Nov 20, 2014