wangchen2019 opened a new issue, #64368: URL: https://github.com/apache/doris/issues/64368
### 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 create table tmps.tmp_trace_link_long_magnetic_sort PROPERTIES ( "replication_num" = "2" ) as with recursive t(id, a) as ( select cast(1 as bigint), array(cast(1 as bigint)) union all select id + 1, array_pushback(a, id) from t where id < 5 ) select * from t; ### What's Wrong? SQL 错误 [1105] [HY000]: fragment has no children ### What You Expected? -- 1. 显式建表（明确指定字段类型） drop table tmps.tmp_trace_link_long_magnetic_sort; CREATE TABLE tmps.tmp_trace_link_long_magnetic_sort ( id BIGINT, a ARRAY<BIGINT> ) PROPERTIES ( "replication_num" = "2" ); -- 方法 1：直接关闭 Nereids 优化器（推荐） SET enable_nereids_planner = false; -- 方法 2：如果方法 1 报错，尝试开启自动回退机制 SET enable_fallback_to_original_planner = true; -- 2. 插入数据 INSERT INTO tmps.tmp_trace_link_long_magnetic_sort WITH RECURSIVE t(id, a) AS ( SELECT CAST(1 AS BIGINT), array(CAST(1 AS BIGINT)) UNION ALL SELECT id + 1, array_pushback(a, id) FROM t WHERE id < 5 ) SELECT * FROM t; SQL 错误 [1105] [HY000]: fragment has no children ### 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: [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]
