[GitHub] [shardingsphere] sinoryan opened a new issue #11418: mysql case when statement parse error

Tue, 20 Jul 2021 04:21:46 -0700 


sinoryan opened a new issue #11418:
URL: https://github.com/apache/shardingsphere/issues/11418


   shardingsphere version:4.1.1
   
   mybatis sql  as follow:
   
   SELECT id,
           (CASE
           WHEN LENGTH(TRIM(name_en))<![CDATA[>]]>0 THEN 
CONCAT(name_cn,'-',name_en)
           ELSE name_cn
           END) AS text,account_no FROM `user`
           WHERE status=1 xxxx
   
   debug screenshot
   
![QQ图片20210720191809](https://user-images.githubusercontent.com/8133974/126315353-5cae0c08-6338-4d2e-b96f-c3a47b28b6c3.png)
   
![QQ图片20210720191816](https://user-images.githubusercontent.com/8133974/126315357-4ca4798f-63e3-4db5-bc3c-954b3ef6d86c.png)
   
   exception:
   line 3:25 no viable alternative at input '(CASEWHENLENGTH(TRIM(name_en'
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to