peilinqian commented on issue #22480: URL: https://github.com/apache/shardingsphere/issues/22480#issuecomment-1348135908
**version** ``` we find java version: java8, full_version=1.8.0_282, full_path=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.282.b08-1.el7_9.x86_64/bin/java ShardingSphere-5.2.2-SNAPSHOT Commit ID: dirty-631fdf40f87223e176abe5c851a51b3287b4d6de Commit Message: Fix wrong decide result when execute same sharding condition subquery with sql federation (https://github.com/apache/shardingsphere/pull/22754) Branch: https://github.com/apache/shardingsphere/commit/631fdf40f87223e176abe5c851a51b3287b4d6de Build time: 2022-12-12T10:48:40+0800 ``` **result ：pass** ``` test_db=> --create view test_db=> create view left_join_view as select o.order_id, o.user_id, m.merchant_name from t_new_order o left join t_merchant m on o.merchant_id = m.merchant_id where o.user_id > 20 order by 1,2,3; CREATE VIEW test_db=> --select view test_db=> select * from left_join_view; order_id | user_id | merchant_name ----------+---------+--------------- 2100 | 21 | baidu 2101 | 21 | xiaomi 2200 | 22 | google 2201 | 22 | walmart 2300 | 23 | microsoft 2301 | 23 | dell 2400 | 24 | hp 2401 | 24 | tesla 2500 | 25 | huawei 2501 | 25 | alibaba 2600 | 26 | baidu 2601 | 26 | xiaomi 2700 | 27 | google 2701 | 27 | walmart 2800 | 28 | microsoft 2801 | 28 | dell 2900 | 29 | hp 2901 | 29 | tesla 2902 | 29 | hp 2903 | 29 | tesla (20 rows) test_db=> --select limit 4,5 test_db=> select * from left_join_view limit 4,5; order_id | user_id | merchant_name ----------+---------+--------------- 2300 | 23 | microsoft 2301 | 23 | dell 2400 | 24 | hp 2401 | 24 | tesla 2500 | 25 | huawei (5 rows) test_db=> ``` -- 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-unsubscr...@shardingsphere.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
