Anricx commented on issue #2369: Sharding-JDBC 4.0.0-RC1 Compatibility? URL: https://github.com/apache/incubator-shardingsphere/issues/2369#issuecomment-492155853 Version: 4.0.0-RC1 Logic SQL: ```sql SELECT pp.merchant, pp.plate, pp.park_uuid, pp.pay_serial FROM `_parking_payment_plus` pp FORCE INDEX (`IDX-RESULT_TIME`) WHERE pp.result = 1 ORDER BY pp.`id` DESC ``` Actual SQL: parking_default ::: ```sql SELECT pp.merchant, pp.plate, pp.park_uuid, pp.pay_serial, pp.id AS ORDER_BY_DERIVED_0 FROM `_parking_payment` pp FORCE INDEX (`IDX-RESULT_TIME`__parking_payment) WHERE pp.result = 1 ORDER BY pp.`id` DESC ``` Error: ``` ### 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 '__parking_payment) WHERE pp.result = 1 ' at line 44 ; 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 '__parking_payment) WHERE pp.result = 1 ' at line 44 ```
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
