zhongyongpei opened a new issue, #29692:
URL: https://github.com/apache/shardingsphere/issues/29692

   version: 5.2.1
   SQL:
   insert into t_entry_exit_record(id,exit_report_time) 
values(?,COALESCE(?,CURRENT_TIMESTAMP()))
   get error:
   org.mybatis.spring.MyBatisSystemException: nested exception is 
org.apache.ibatis.executor.ExecutorException: Error preparing statement.  
Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException
   
   
![image](https://github.com/apache/shardingsphere/assets/10511611/c26a9273-2544-4418-a837-6b8086d40811)
   
   change  COALESCE to IFNULL   it is ok.
   support COALESCE?


-- 
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