Re: [dba-dev] unexpected behavior with HSQL embedded DB case when and coalese commands

[Andrew Jensen]

Hallo Frank No issue for now then. Perhaps it is more fitting in user faq document.anyway. Andrew Frank Schönheit - Sun Microsystems Germany wrote: Hi Andrew. Change the select statement to SELECT CASE DATA WHEN 'xxxx' THEN 'X' WHEN 'yyyy' THEN 'Y' WHEN 'zzzz' THEN 'Z' ELSE 'NOTFOUND' END AS "DATA" FROM TESTCASE It still requires that EscapeProcessing = false. The HSQLDB engine is capable of more things that OOo's cross-DB parser, and SELECT CASE is not part of the latter. With the change (explicity setting the return columns name ) it works correctly using a RowSet object via the API, and as a View also. Still, is this an issue I should enter? Hmm, not sure without looking deeper into it. Might be possible that we can make OOo tolerant enough to also properly execute the AS-less query, so fel free to submit an issue (though it would probably be P4), so we can investigate. Thanks & Ciao Frank