当前使用版本 3.5.6 当前环境信息 例如: Java8 + Mysql5.7 java11 Mysql8.4
描述bug现象
当 page.addOrder( orderItemList ) 添加多个排序字段时,
通过Page
提供完整堆栈日志(可选)
SQL: SELECT id, username, password, phone, info, status, balance, create_time, update_time FROM user ORDER BY [balance DESC, id DESC, price] DESC LIMIT ?
Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[balance DESC, id DESC, price] DESC LIMIT 10' at line 1
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[balance DESC, id DESC, price] DESC LIMIT 10' at line 1] with root cause
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[balance DESC, id DESC, price] DESC LIMIT 10' at line 1 提供问题复现工程(可选) 请尽量提供复现工程,减少大家排错的时间.