HolgerWang1999 opened a new issue, #35844: URL: https://github.com/apache/doris/issues/35844
### 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 ### What's Wrong? 升级到2.1.3版本后，如果子查询中使用SUBSTRING函数，再与其他表进行JOIN操作则会提示Merge block not match错误 错误原文： [CANCELLED]Merge block not match, self:[columns: metric_name, metric_value, stat_value, stat_date, DORIS_DELETE_SIGN, metric_name, stat_date, , Int32, VectorizedFnCall[substring](arguments=metric_name, Int32,return=Nullable(String)), types: Nullable(String), Nullable(String), Nullable(String), Nullable(DateV2), Int8, Nullable(String), Nullable(DateV2), Int64, Int32, Nullable(String)], input:[columns: metric_name, metric_value, stat_value, stat_date, DORIS_DELETE_SIGN, metric_name, stat_date, , Int32, VectorizedFnCall[substring](arguments=metric_name, Int32,return=Nullable(String)), strlen, types: Nullable(String), Nullable(String), Nullable(String), Nullable(DateV2), Int8, Nullable(String), Nullable(DateV2), Int64, Int32, Nullable(String), Int32], 比对了self和input发现是多了一个strlen ### What You Expected? 升级前是可以正常执行的，不应该引发此错误 ### How to Reproduce? 表A，字段为id STRING 表B，字段为test_str STRING SQL： SELECT a.id FROM a JOIN ( SELECT SUBSTRING(test_str, 10) AS id FROM b ) tmp ON a.id = tmp.id; ### 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: [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]
