wwding opened a new issue, #32946: URL: https://github.com/apache/shardingsphere/issues/32946
 SELECT * FROM ( SELECT TMP_PAGE.*, ROWNUM PAGEHELPER_ROW_ID FROM ( SELECT attendance_id,worker_Id,param,project_id,attendance_date,operation_type,update_Time AS createTime,update_Time FROM tf_b_attendance_mirror WHERE (project_id = ?) ) TMP_PAGE) WHERE PAGEHELPER_ROW_ID <= ? AND PAGEHELPER_ROW_ID > ? <dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId> <version>5.2.1</version> </dependency> org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException ### The error may exist in com/example/demo/zhao/AttendanceMirrorMapper.java (best guess) ### The error may involve com.example.demo.zhao.AttendanceMirrorMapper.selectList ### The error occurred while executing a query ### SQL: SELECT * FROM ( SELECT TMP_PAGE.*, ROWNUM PAGEHELPER_ROW_ID FROM ( SELECT attendance_id,worker_Id,param,project_id,attendance_date,operation_type,update_Time AS createTime,update_Time FROM tf_b_attendance_mirror WHERE (project_id = ?) ) TMP_PAGE) WHERE PAGEHELPER_ROW_ID <= ? AND PAGEHELPER_ROW_ID > ? ### Cause: org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.sql.parser.exception.SQLParsingException -- 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]
