[GitHub] [shardingsphere] TeslaCN commented on issue #11589: SQL in BenchmarkSQL was not rewrote in subquery

[GitBox <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org