当前使用版本(必填,否则不予处理)
mybatis-plus-spring-boot3-starter 3.5.5 spring-boot 3.2.1
该问题是如何引起的?(确定最新版也有问题再提!!!)
MP升级以后,关键字date报错
重现步骤(如果有就写完整)
报错信息
Caused by: org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax: SELECT id,type,user_id,cnt,date,create_time,update_time FROM user_send_email_count WHERE (type = ? AND user_id = ? AND date = ?) ORDER BY id ASC limit 1, no viable alternative at input 'SELECTid,type,user_id,cnt,`date' at line 1, position 29, near [@10,29:32='date',<520>,1:29]
Comment From: Robert-PF
这个解决了吗