SinyoWong opened a new issue, #28878: URL: https://github.com/apache/doris/issues/28878
### 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 Doris 2.0.3 ### What's Wrong? SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = (192.168.219.30)[INTERNAL_ERROR]couldn't resolve slot descriptor 5, desc: tuples: Tuple(id=20 slots=[Slot(id=624 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=625 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=626 type=VARCHAR col=-1, colname=, nullable=1)] has_varlen_slots=1) Tuple(id=19 slots=[Slot(id=623 type=DECIMAL128(38, 9) col=-1, colname=cost_130533_t1, nullable=1)] has_varlen_slots=0) Tuple(id=17 slots=[Slot(id=416 type=DECIMALV2(22, 5) col=-1, colname=cost, nullable=1), Slot(id=424 type=DATEV2 col=-1, colname=dt, nullable=1), Slot(id=444 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=445 type=VARCHAR col=-1, colname=, nullable=0), Slot(id=447 type=VARCHAR col=-1, colname=brand_code, nullable=1), Slot(id=460 type=DATEV2 col=-1, colname=dt, nullable=1), Slot(id=480 type=VARCHAR col=-1, colname=brand_code, nullable=1), Slot(id=493 type=DATEV2 col=-1, colname=dt, nullable=1)] has_varlen_slots=1) Tuple(id=16 slots=[Slot(id=410 type=DECIMAL128(38, 9) col=-1, colname=cost_130533_t1_1, nullable=1)] has_varlen_slots=0) Tuple(id=14 slots=[Slot(id=394 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=395 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=396 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=397 type=DECIMAL128(38, 9) col=-1, colname=, nullable=0)] has_varlen_slots=1) Tuple(id=21 slots=[Slot(id=627 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=628 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=629 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=630 type=DECIMAL128(38, 9) col=-1, colname=, nullable=1)] has_varlen_slots=1) Tuple(id=8 slots=[Slot(id=184 type=VARCHAR col=-1, colname=brand_code, nullable=1), Slot(id=189 type=DECIMALV2(22, 5) col=-1, colname=cost, nullable=1), Slot(id=197 type=DATEV2 col=-1, colname=dt, nullable=1)] has_varlen_slots=1) Tuple(id=18 slots=[Slot(id=518 type=DECIMALV2(22, 5) col=-1, colname=cost, nullable=1), Slot(id=526 type=DATEV2 col=-1, colname=dt, nullable=1), Slot(id=546 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=547 type=VARCHAR col=-1, colname=, nullable=0), Slot(id=548 type=DECIMALV2(22, 5) col=-1, colname=cost, nullable=1), Slot(id=549 type=VARCHAR col=-1, colname=brand_code, nullable=1), Slot(id=554 type=DECIMALV2(22, 5) col=-1, colname=cost, nullable=1), Slot(id=562 type=DATEV2 col=-1, colname=dt, nullable=1), Slot(id=582 type=VARCHAR col=-1, colname=brand_code, nullable=1), Slot(id=587 type=DECIMALV2(22, 5) col=-1, colname=cost, nullable=1), Slot(id=595 type=DATEV2 col=-1, colname=dt, nullable=1), Slot(id=615 type=DATEV2 col=-1, colname=, nullable=1)] has_varlen_slots=1) Tuple(id=5 slots=[Slot(id=172 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=173 type=VARCHAR col=-1, colname=, nullable=1), Slot(id=174 type=VARCHAR col=-1, colname=, nullable=1)] has_varlen_slots=1) Tuple(id=0 slots=[Slot(id=0 type=VARCHAR col=-1, colname=brand_code, nullable=1), Slot(id=13 type=DATEV2 col=-1, colname=dt, nullable=1)] has_varlen_slots=1) ### What You Expected? This BUG need fixed. ### How to Reproduce? select * from ( select (select a1,a2,sum(a3) from table_1 group by a1,a2) as tmp1 left join (select a1,a2,sum(a3) from table_2 group by a1,a2) as tmp2 on tmp1.a1=tmp2.a1 and tmp1.a2=tmp2.a2 ) as tmp3 ### 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
