Doris错误信息不准确

问题描述

查询视图中不存在的字段A，报错信息提示：字段B不存在

Doris 版本： 2.1.9

用例复现

执行

SELECT adi FROM dm_dm_cz_ca_pat_info_view

报错

SQL 错误 [1054] [42S22]: errCode = 2, detailMessage = Unknown column 'pat_id' in 'cdrapp_zengliang_data_test.a'

相关视图与表的创建语句

CREATE VIEW dm_dm_cz_ca_pat_info_view(
`pat_id` COMMENT "患者id",
`pat_name` COMMENT "患者姓名",
`org_id` COMMENT "机构id"
)
 COMMENT "患者信息"
 as 
SELECT
  a.pat_id AS pat_id, /* 患者id */
  a.pat_name AS pat_name, /* 患者姓名 */
   a.org_id AS org_id /* 机构id */
  
FROM dw_dwb_cz_ca_pat_info AS a; 

CREATE TABLE `dw_dwb_cz_ca_pat_info` (
  `pat_id` bigint NOT NULL COMMENT "患者ID",
  `org_id` bigint NOT NULL COMMENT "机构ID",
  `pat_name` varchar(400) NULL COMMENT "患者姓名"
 
) ENGINE=OLAP
UNIQUE KEY(`pat_id`, `org_id`)
DISTRIBUTED BY HASH(`pat_id`, `org_id`) BUCKETS 3
PROPERTIES (
"replication_num" = "1"
);