Well, found the solution.
Change the select statement to
SELECT CASE DATA WHEN '' THEN 'X' WHEN '' THEN 'Y' WHEN ''
THEN 'Z' ELSE 'NOTFOUND' END AS "DATA" FROM TESTCASE
It still requires that EscapeProcessing = false. With the change
(explicity setting the return columns name )
Installation WinXP SP2, OO.o 1.9.123
I am experiencing rather odd behavior between queries and viees when
using case when and coalese commands.
Here are the steps to reproduce the effect.
Created HSQL embedded datasource using build 1.9.123
Execute the following commands in the sql window. T