Sumuxi9797926 opened a new issue, #29788:
URL: https://github.com/apache/shardingsphere/issues/29788
SELECT
*
FROM
order_info_202401 main
WHERE
EXISTS (
SELECT
1
FROM
order_item sub -- 应该为order_item_202401
WHERE
sub.order_no = main.order_no
AND (
sub.sku_code LIKE concat( '%', '酒精', '%' )
OR sub.product_name LIKE concat( '%', '酒精', '%' )))
AND main.del_flag = 0
AND main.wid = 200
AND main.create_date BETWEEN '2024-01-05 00:00:00'
AND '2024-01-17
23:59:59';这个sql中order_item解析不出来，order_info和order_item都是根据时间分的表，有大佬知道如何解答么？
--
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]
