penglele opened a new issue, #35711: URL: https://github.com/apache/doris/issues/35711
### 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.1.3-rc09 ### What's Wrong? ``` mysql> SET enable_fallback_to_original_planner=false; mysql> select toll_coun_calling_dura from SING_VOICE_1 tab1 where exists( select user_id from USER_INFO_1 union select user_id from USER_INFO_1 where USER_ID = tab1.USER_ID ) ; > 1105 - AnalysisException, msg: Input slot(s) not in child's output: USER_ID#0 in plan: LogicalFilter[217] ( predicates=(USER_ID#7 = USER_ID#0) ) child output is: [USER_ID#7] plan tree: LogicalFilter[217] ( predicates=(USER_ID#7 = USER_ID#0) ) +--LogicalProject[194] ( distinct=false, projects=[USER_ID#7], excepts=[], canEliminate=true ) +--LogicalOlapScan ( qualified=internal.default_cluster:regression.user_info_1, indexName=user_info_1, selectedIndexId=492507, preAgg=ON ) ``` 建表语句： CREATE TABLE `SING_VOICE_1` ( `user_id` varchar(30) NULL COMMENT '用户标识', `month_id` varchar(30) NOT NULL COMMENT '月分区', `prov_id` varchar(10) NOT NULL COMMENT '省分编码', `toll_coun_calling_dura` bigint(20) NULL COMMENT '长途国内主叫通话时长' ) ENGINE=OLAP DUPLICATE KEY(`user_id`, `month_id`, `prov_id`) COMMENT 'OLAP' PARTITION BY LIST(`prov_id`) (PARTITION p1 VALUES IN ("10"), PARTITION p2 VALUES IN ("11"), PARTITION p31 VALUES IN ("97")) DISTRIBUTED BY HASH(`user_id`, `prov_id`) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "is_being_synced" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" ); CREATE TABLE `USER_INFO_1` ( `USER_ID` varchar(30) NULL COMMENT '订购实例标识', `MONTH_ID` varchar(20) NOT NULL, `PROV_ID` varchar(5) NOT NULL ) ENGINE=OLAP DUPLICATE KEY(`USER_ID`, `MONTH_ID`, `PROV_ID`) COMMENT 'OLAP' PARTITION BY LIST(`PROV_ID`) (PARTITION p_vc1 VALUES IN ("10"), PARTITION p_vc2 VALUES IN ("11"), PARTITION p_vc31 VALUES IN ("97")) DISTRIBUTED BY HASH(`USER_ID`) BUCKETS 13 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "is_being_synced" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" ); ### What You Expected? I hope that this SQL will be handled correctly as MySQL ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
