TeslaCN commented on issue #11589:
URL:
https://github.com/apache/shardingsphere/issues/11589#issuecomment-920823994
I try the BenchmarkSQL again, it worked!
```
[INFO ] 2021-09-16 19:33:21.723 [Connection-2-ThreadExecutor]
ShardingSphere-SQL - Logic SQL: SELECT o_id, o_entry_d, o_carrier_id FROM
bmsql_oorder WHERE o_w_id = ? AND o_d_id = ? AND o_c_id = ? AND o_id
= ( SELECT max(o_id) FROM bmsql_oorder
WHERE o_w_id = ? AND o_d_id = ? AND o_c_id = ? )
[INFO ] 2021-09-16 19:33:21.723 [Connection-2-ThreadExecutor]
ShardingSphere-SQL - SQLStatement:
PostgreSQLSelectStatement(limit=Optional.empty, lock=Optional.empty,
window=Optional.empty)
[INFO ] 2021-09-16 19:33:21.723 [Connection-2-ThreadExecutor]
ShardingSphere-SQL - Actual SQL: ds_2 ::: SELECT o_id, o_entry_d, o_carrier_id
FROM bmsql_oorder_2 WHERE o_w_id = ? AND o_d_id = ? AND o_c_id = ?
AND o_id = ( SELECT max(o_id) FROM bmsql_oorder_2
WHERE o_w_id = ? AND o_d_id = ? AND o_c_id = ? ) ::: [6, 1,
2286, 6, 1, 2286]
```
--
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]