Bingchen1512 opened a new issue, #17972: URL: https://github.com/apache/doris/issues/17972
### 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 1.2.3 ### What's Wrong? **创建表，插入查询的数据，报错：[INTERNAL_ERROR]couldn't resolve slot descriptor 32** 而且插入其他表数据的时候，可以正常插入，未报异常。 ```sql create table dim_order_oap_sale_budget( OFFICECODE VARCHAR(64) COMMENT '中心编码', OFFICENAME VARCHAR(255) COMMENT '中心名称', AREACODE VARCHAR(64) comment '大区编码', AREANAME VARCHAR(255) comment '大区名称', DEPTCODE VARCHAR(64) comment '办事处编码', DEPTNAME VARCHAR(255) comment '办事处名称', BLONGMONTH varchar(20) comment '年度月份', SALEBUDGET DECIMAL(18,8) comment '预算' ) DUPLICATE KEY(`OFFICECODE`) COMMENT 'dim_销售预算表_本年度' DISTRIBUTED BY HASH(`OFFICECODE`) BUCKETS 4 PROPERTIES ( "light_schema_change" = "true", "enable_unique_key_merge_on_write" = "true", "replication_allocation" = "tag.location.default: 3" ); insert into dim_order_oap_sale_budget(OFFICECODE, OFFICENAME, AREACODE, AREANAME, DEPTCODE, DEPTNAME, BLONGMONTH, SALEBUDGET) with salebudget_without_area as (select yearMonth as BLONGMONTH, dept_code AS DEPTCODE, dept_name AS DEPTNAME, sum(sales_money) AS SALEBUDGET from ods_cw_ydxsyg_details ocyd where left(yearMonth, 4) = year(now()) group by left(yearMonth, 4), yearMonth, dept_code, dept_name), budget_dept_area_office as (SELECT nvl(d.PK_DEFDOC, c.PK_DEFDOC) AS PK_DEFDOC, nvl(d.CODE, c.CODE) AS DEPTCODE, NVL(d.NAME, c.NAME) AS DEPTNAME, c.CODE AS AREACODE, c.NAME AS AREANAME, a.CODE AS OFFICECODE, a.NAME AS OFFICENAME FROM ods_bd_defdoc a LEFT JOIN (SELECT PK_DEFDOC, CODE, NAME, INNERCODE FROM ods_bd_defdoc doc WHERE doc.PK_DEFDOCLIST = '1001X31000000003MV9U' AND length(doc.INNERCODE) = 8 AND doc.ENABLESTATE = 2) c ON a.INNERCODE = substr(c.INNERCODE, 1, 4) LEFT JOIN (SELECT PK_DEFDOC, CODE, NAME, INNERCODE FROM ods_bd_defdoc doc WHERE doc.PK_DEFDOCLIST = '1001X31000000003MV9U' AND length(doc.INNERCODE) = 12 AND doc.ENABLESTATE = 2) d ON c.INNERCODE = substr(d.INNERCODE, 1, 8) WHERE a.PK_DEFDOCLIST = '1001X31000000003MV9U' AND a.ENABLESTATE = 2 AND length(a.INNERCODE) = 4) select budget_dept_area_office.OFFICECODE as OFFICECODE, budget_dept_area_office.OFFICENAME AS OFFICENAME, budget_dept_area_office.AREACODE AS AREACODE, budget_dept_area_office.AREANAME AS AREANAME, salebudget_without_area.DEPTCODE AS DEPTCODE, salebudget_without_area.DEPTNAME AS DEPTNAME, salebudget_without_area.BLONGMONTH AS BLONGMONTH, salebudget_without_area.SALEBUDGET AS SALEBUDGET from salebudget_without_area left join budget_dept_area_office on budget_dept_area_office.DEPTCODE = salebudget_without_area.DEPTCODE; ``` ### What You Expected? 查看数据类型，无错误。 是否是doris升级问题还是bug？ 希望得到回复，谢谢。 ### 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
