guanghuan96 opened a new issue, #29449: URL: https://github.com/apache/doris/issues/29449
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.3 ### What's Wrong? 加上like后把全部数据都过滤掉了 完整sql: select shop_no, full_name from tidb_prod_tikv.ehr_sync.organization where shop_no in ('XDGY01','XDAHDY','XDZZZB','NKBO25','ADJN52','ADJN15') and full_name not like '%虚店%' and full_name not like '%直播%' -- 查询样例数据 select shop_no, full_name from tidb_prod_tikv.ehr_sync.organization -- 这是一张外链表 where shop_no in ('XDGY01','XDAHDY','XDZZZB','NKBO25','ADJN52','ADJN15') 数据如下： shop_no full_name NKBO25 济南历下泉城路恒隆KL ADJN52 济南历下泉城路恒隆AD二店 ADJN15 济南市中经四路振华AD XDGY01 云贵贵阳总部小程序虚店 XDAHDY 安徽抖音虚店 XDZZZB 河南地区直播库存店 -- 执行计划 explain select shop_no, full_name from tidb_prod_tikv.ehr_sync.organization where shop_no in ('XDGY01','XDAHDY','XDZZZB','NKBO25','ADJN52','ADJN15') and full_name not like '%虚店%' and full_name not like '%直播%' PLAN FRAGMENT 0 OUTPUT EXPRS: shop_no[#52] full_name[#8] PARTITION: UNPARTITIONED HAS_COLO_PLAN_NODE: false VRESULT SINK 343:VEXCHANGE offset: 0 PLAN FRAGMENT 1 PARTITION: RANDOM HAS_COLO_PLAN_NODE: false STREAM DATA SINK EXCHANGE ID: 343 UNPARTITIONED 332:VJdbcScanNode TABLE: `ehr_sync`.`organization` QUERY: SELECT `shop_no`, `full_name` FROM `ehr_sync`.`organization` WHERE (full_name like '%虚店%') AND (shop_no IN ('XDGY01', 'XDAHDY', 'XDZZZB', 'NKBO25', 'ADJN52', 'ADJN15')) AND (full_name like '%直播%') PREDICATES: NOT full_name[#8] like '%虚店%' AND shop_no[#52] IN ('XDGY01', 'XDAHDY', 'XDZZZB', 'NKBO25', 'ADJN52', 'ADJN15') AND NOT full_name[#8] like '%直播%' ### What You Expected? 期望得到如下数据： shop_no full_name NKBO25 济南历下泉城路恒隆KL ADJN52 济南历下泉城路恒隆AD二店 ADJN15 济南市中经四路振华AD ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
