[I] [Bug] couldn't resolve slot descriptor when join [doris]

[via GitHub]

nextdreamblue opened a new issue, #35009:
URL: https://github.com/apache/doris/issues/35009

   ### 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
   
   master
   
   ### What's Wrong?
   
   CREATE TABLE `dws_mf_wms_join_t1` (
             `ddate` DATE NULL COMMENT '日期字段',
             `game_id` VARCHAR(65533) NULL,
             `main_currency_stock` BIGINT NULL
             ) ENGINE=OLAP
             DUPLICATE KEY(`ddate`)
             DISTRIBUTED BY HASH(`ddate`) BUCKETS 10
             PROPERTIES (
             "replication_allocation" = "tag.location.default: 1"
            );
   
   
   CREATE TABLE `dws_mf_wms_join_t2` (
             `game_id` VARCHAR(65533) NULL,
             ) ENGINE=OLAP
             DUPLICATE KEY(`game_id`)
             DISTRIBUTED BY HASH(`game_id`) BUCKETS 10
             PROPERTIES (
             "replication_allocation" = "tag.location.default: 1"
            );
   
   SELECT
                   a1.ddate
               FROM
                   (
                       SELECT
                           aaa.ddate
                       FROM
                           (
                               SELECT
                                   aa.ddate,
                                   CONCAT('main', aa.main_currency_stock) AS 
arr,
                                   ROW_NUMBER() OVER (
                                       PARTITION BY aa.ddate
                                   ) AS rn
                               FROM
                                   (
                                       SELECT
                                           ddate,
                                           main_currency_stock,
                                           game_id
                                       FROM
                                           dws_mf_wms_join_t1 a
                                   ) aa
                                   LEFT JOIN (
                                       SELECT
                                           game_id
                                       FROM
                                           dws_mf_wms_join_t2
                                   ) b ON aa.game_id = b.game_id
                           ) aaa
                           CROSS JOIN (
                               select
                                   1 as newarr
                           ) b
                       WHERE
                           rn = 1
                   ) a1
               GROUP BY
                   GROUPING SETS (
                       (
                           a1.ddate
                       )
                   );
   ERROR 1105 (HY000): errCode = 2, detailMessage = 
(9.134.167.25)[INTERNAL_ERROR]couldn't resolve slot descriptor 21, desc: tuples:
   Tuple(id=19 slots=[Slot(id=47 type=TINYINT col=-1, colname=newarr, 
nullable=0)] has_varlen_slots=0)
   Tuple(id=18 slots=[Slot(id=42 type=DATEV2 col=-1, colname=ddate, 
nullable=1), Slot(id=43 type=VARCHAR col=-1, colname=game_id, nullable=1), 
Slot(id=44 type=VARCHAR col=-1, colname=game_id, nullable=1), Slot(id=45 
type=DATEV2 col=-1, colname=ddate, nullable=1), Slot(id=46 type=BIGINT col=-1, 
colname=,
   
   ### What You Expected?
   
   return success
   
   ### 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: 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