zy1263188600 commented on issue #24648:
URL:
https://github.com/apache/shardingsphere/issues/24648#issuecomment-1475836604
@sandynz
This is the original log
Logic SQL and Actual SQL：
```log
[2023-03-20 09:29:36] [INFO ] [main] [ShardingSphere-SQL.74] : Logic SQL:
SELECT * FROM f_busi
WHERE (start_time >= ? AND start_time <= ?)
[2023-03-20 09:29:36] [INFO ] [main] [ShardingSphere-SQL.74] : Actual SQL:
fbusi-2022 :::
SELECT * FROM f_busi_01 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_02 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_03 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_04 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_05 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_06 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_07 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_08 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_09 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_10 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_11 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_12 WHERE (start_time >= ? AND start_time <= ?) :::
[2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01
00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00,
2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01
00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00,
2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01
00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00,
2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00]
[2023-03-20 09:29:36] [INFO ] [main] [ShardingSphere-SQL.74] : Actual SQL:
fbusi-2023 :::
SELECT * FROM f_busi_01 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_02 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_03 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_04 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_05 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_06 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_07 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_08 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_09 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_10 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_11 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_12 WHERE (start_time >= ? AND start_time <= ?) :::
[2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01
00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00,
2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01
00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00,
2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01
00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00,
2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00]
[2023-03-20 09:29:36] [INFO ] [main] [ShardingSphere-SQL.74] : Actual SQL:
fbusi-2024 :::
SELECT * FROM f_busi_01 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_02 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_03 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_04 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_05 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_06 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_07 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_08 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_09 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_10 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_11 WHERE (start_time >= ? AND start_time <= ?) UNION
ALL
SELECT * FROM f_busi_12 WHERE (start_time >= ? AND start_time <= ?) :::
[2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01
00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00,
2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01
00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00,
2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01
00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00, 2022-11-01 00:00:00,
2024-03-01 00:00:00, 2022-11-01 00:00:00, 2024-03-01 00:00:00]
```
demo What is it like A SpringBoot project?
--
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]
