[Bug] query plan failed detailMessage = Unknown column 'null' in 'table list'

[wanggx]

Search before asking

• I had searched in the issues and found no similar issues.

Version

25.1.0

What's Wrong?

CREATE OR REPLACE TEMPORARY VIEW doris_ddd_ods_v318test_atest01
using doris OPTIONS(
"table.identifier"="ddd.ods_v318test_atest01",
"fenodes"="xxxx",
"user"="uuuu",
"password"="ppp");

select COALESCE(CAST(A4 AS STRING),'null') from doris_ddd_ods_v318test_atest01 where COALESCE(CAST(A4 AS STRING),'null') in ('1');

What You Expected?

cloud not cause a error

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

• I agree to follow this project's Code of Conduct

[wanggx]

doris create table sql is

CREATE TABLE ods_v318test_atest01 (
ID decimal(38,10) NULL,
NAME varchar(300) NULL,
AGE decimal(38,10) NULL,
CREATE_TIME datetime(3) NULL,
A1 varchar(300) NULL,
A2 varchar(300) NULL,
A3 varchar(300) NULL,
A4 varchar(300) NULL,
__source_ts_ms bigint NULL COMMENT "数据采入kafka的时间戳（集成任务自建）",
__op varchar(10) NULL COMMENT "操作类型 c:增加 u:更新 d:删除（集成任务自建）r:稽核后补采",
__table varchar(100) NULL COMMENT "源表表名（集成任务自建）",
__db varchar(50) NULL COMMENT "源库名称（集成任务自建）",
__deleted varchar(10) NULL COMMENT "删除标志：false代表有效，true代表已删除（集成任务自建）",
__dt datetime NULL COMMENT "入库时间，分区字段（集成任务自建）"
) ENGINE=OLAP
DUPLICATE KEY(ID)
PARTITION BY RANGE(__dt)
(PARTITION p20250905 VALUES [('2025-09-05 00:00:00'), ('2025-09-06 00:00:00')),
PARTITION p20250906 VALUES [('2025-09-06 00:00:00'), ('2025-09-07 00:00:00')),
PARTITION p20250907 VALUES [('2025-09-07 00:00:00'), ('2025-09-08 00:00:00')),
PARTITION p20250908 VALUES [('2025-09-08 00:00:00'), ('2025-09-09 00:00:00')),
PARTITION p20250909 VALUES [('2025-09-09 00:00:00'), ('2025-09-10 00:00:00')),
PARTITION p20250910 VALUES [('2025-09-10 00:00:00'), ('2025-09-11 00:00:00')),
PARTITION p20250911 VALUES [('2025-09-11 00:00:00'), ('2025-09-12 00:00:00')),
PARTITION p20250912 VALUES [('2025-09-12 00:00:00'), ('2025-09-13 00:00:00')),
PARTITION p20250913 VALUES [('2025-09-13 00:00:00'), ('2025-09-14 00:00:00')),
PARTITION p20250914 VALUES [('2025-09-14 00:00:00'), ('2025-09-15 00:00:00')),
PARTITION p20250915 VALUES [('2025-09-15 00:00:00'), ('2025-09-16 00:00:00')),
PARTITION p20250916 VALUES [('2025-09-16 00:00:00'), ('2025-09-17 00:00:00')),
PARTITION p20250917 VALUES [('2025-09-17 00:00:00'), ('2025-09-18 00:00:00')),
PARTITION p20250918 VALUES [('2025-09-18 00:00:00'), ('2025-09-19 00:00:00')),
PARTITION p20250919 VALUES [('2025-09-19 00:00:00'), ('2025-09-20 00:00:00')),
PARTITION p20250920 VALUES [('2025-09-20 00:00:00'), ('2025-09-21 00:00:00')),
PARTITION p20250921 VALUES [('2025-09-21 00:00:00'), ('2025-09-22 00:00:00')),
PARTITION p20250922 VALUES [('2025-09-22 00:00:00'), ('2025-09-23 00:00:00')),
PARTITION p20250923 VALUES [('2025-09-23 00:00:00'), ('2025-09-24 00:00:00')),
PARTITION p20250924 VALUES [('2025-09-24 00:00:00'), ('2025-09-25 00:00:00')),
PARTITION p20250925 VALUES [('2025-09-25 00:00:00'), ('2025-09-26 00:00:00')))
DISTRIBUTED BY RANDOM BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-2147483648",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_allocation" = "tag.location.default: 3",
"dynamic_partition.buckets" = "32",
"dynamic_partition.create_history_partition" = "false",
"dynamic_partition.history_partition_num" = "-1",
"dynamic_partition.hot_partition_num" = "0",
"dynamic_partition.reserved_history_periods" = "NULL",
"dynamic_partition.storage_policy" = "",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);