示例sql:
SELECT
ranking,
p.assignee_name,
work_month,
(
SELECT
median AS median
FROM
day_p AS day_p
WHERE
work_month = p.work_month) AS median_p
FROM
p_data AS p
GROUP BY
p.assignee_name,
p.work_month,
p.leave_days,
p.work_days
在select 子语句中使用标量子查询执行查询正常，创建为视图执行报错
Viewed 44
3 Answers
复现步骤：
1、查询sql执行执行不报错
WITH gtp_done_issue(assignee_name, story_point, label, done_time) AS (
SELECT '张三', CAST(5.0 AS DOUBLE), '急', CAST('2025-01-10 10:00:00' AS DATETIME) UNION ALL
SELECT '李四', CAST(3.0 AS DOUBLE), '运维任务', CAST('2025-01-22 14:00:00' AS DATETIME) UNION ALL
SELECT '王五', CAST(8.0 AS DOUBLE), '重要任务', CAST('2025-02-05 09:00:00' AS DATETIME) UNION ALL
SELECT '张三', CAST(2.0 AS DOUBLE), '普通', CAST('2025-02-18 16:00:00' AS DATETIME) UNION ALL
SELECT '李四', CAST(5.0 AS DOUBLE), '难', CAST('2025-02-25 11:00:00' AS DATETIME) UNION ALL
SELECT '赵六', CAST(4.0 AS DOUBLE), '普通', CAST('2025-02-28 09:00:00' AS DATETIME)
),
org(user_name,org_name) as (
select '张三','部门1' UNION ALL
select '李四','部门2'
)
select *,(select org_name from org where user_name = t1.assignee_name) as org_name from gtp_done_issue t1
2、将第一步的sql创建为view 不会报错
3、查询第二步创建的view报错 SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Index 5 out of bounds for length 5
doris版本：doris version doris-4.1.1-rc01-b10073ad9ca
Related Questions
doris 4.0.5疑似page cache bug
2 answers
SQL Error [1105] [HY000]: errCode =2, detailMessage= type UNSUPPORTED is unsupported for Nereids
2 answers
分区表查询延迟
1 answers
升级Doris4.1 集群 doris_cluster 发生 Critical (default) 告警
2 answers
如何通过flink cdc来实时获取doris中的数据？
1 answers
在select 子语句中使用标量子查询执行查询正常，创建为视图执行报错
3 answers