Comven commented on issue #13544: URL: https://github.com/apache/shardingsphere/issues/13544#issuecomment-981363311
> @Comven > > ``` > 2021-11-29 15:25:31.203 INFO 53564 --- [p-nio-80-exec-1] o.d.s.jdbc.controller.TestController : 即将查询[2021-10-01 00:00:00]到[2021-11-30 23:59:59]的订单信息 > 2021-11-29 15:25:31.253 DEBUG 53564 --- [p-nio-80-exec-1] o.d.s.j.mapper.OrderInfoDao.queryInfo : ==> Preparing: select id , order_no, user_id, add_time from order_info where add_time between ? and ? order by add_time > 2021-11-29 15:25:31.878 DEBUG 53564 --- [p-nio-80-exec-1] o.d.s.j.mapper.OrderInfoDao.queryInfo : ==> Parameters: 2021-10-01 00:00:00.0(Timestamp), 2021-11-30 23:59:59.0(Timestamp) > 2021-11-29 15:25:31.956 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL : Logic SQL: select > > id > , order_no, user_id, add_time > > from order_info where add_time between ? and ? order by add_time > 2021-11-29 15:25:31.956 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL : SQLStatement: MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, window=Optional.empty) > 2021-11-29 15:25:31.957 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL : Actual SQL: db1slaver ::: select > > id > , order_no, user_id, add_time > > from order_info_202110 where add_time between ? and ? order by add_time ::: [2021-10-01 00:00:00.0, 2021-11-30 23:59:59.0] > 2021-11-29 15:25:31.957 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL : Actual SQL: db1slaver ::: select > > id > , order_no, user_id, add_time > > from order_info_202111 where add_time between ? and ? order by add_time ::: [2021-10-01 00:00:00.0, 2021-11-30 23:59:59.0] > 2021-11-29 15:25:32.023 DEBUG 53564 --- [p-nio-80-exec-1] o.d.s.j.mapper.OrderInfoDao.queryInfo : <== Total: 4 > ``` Did you use my program completely to test it? -- 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]
