I have a SQL query that works with the driver version dated 2010-aug-12 06:21. The same query produces an error with newer version (tested 2010-nov-18 06:46 and 2010-dec-29 08:11).
The error is "Syntax error: Stopped parse at ELSE(id149).
I have simplified the query and the problem seems to be related to the use of the ELSE keyword. So the following query fails:
SELECT sum(CASE WHEN 1 THEN 1 WHEN 2 THEN 2 ELSE 3 END)
FROM table;
Error: Syntax error: Stopped parse at ELSE(id149)
SQLState: 2A000
ErrorCode: 172032
Thanks for your support.
|
Thanks. Fixed. Please download the latest package. BTW, Both of
[NOT] CASE WHEN expr THEN result [WHEN expr THEN result ...] [ELSE expr] END, CASE expr WHEN compare_expr THEN result [WHEN compare_expr THEN result ...] [ELSE result] END are supported.
|
Main
webmaster@hxtt.com