[Bug] 严重BUG，参数写反导致BE全挂

[linzhicong1996]

Search before asking

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

Version

Doris 2.0.3

What's Wrong?

使用SPLIT_BY_STRING函数参数写反，将字段写到分割符号，导致3BE直接全部挂掉。分割数量300W+

What You Expected?

可以提示报错，也可以报告执行失败，但是BE直接挂掉太危险了。相当与只要有查询权限就能直接导致集群崩溃

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

[linzhicong1996]

SELECT SPLIT_BY_STRING(check_total_volume,'') AS box_size FROM ex.extable;
err sql :SELECT SPLIT_BY_STRING( '',check_total_volume) AS box_size FROM ex.extable;
check_total_volume: 151.519

[felixwluo]

Please give me the table structure and test data @linzhicong1996

[linzhicong1996]

Please give me the table structure and test data @linzhicong1996

-- 该表结构只有关键字段，全表49个字段
CREATE TABLE ods_test_table (
id varchar(200) NOT NULL,
total_volume varchar(200) NULL,
check_total_volume varchar(200) NULL,
is_deleted boolean NOT NULL DEFAULT "0"',
update_time datetime NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=OLAP
UNIQUE KEY(id)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);

[linzhicong1996]

INSERT INTO ods.ods_oms_parcel (id,total_volume,check_total_volume) VALUES
('ABCAA0273334040KK','101010','111'),
('ABCAA0273334046KK','111','111'),
('ABCAA0273334055KK','111','111'),
('ABCAA0273334078KK','111','111'),
('ABCAA0273334082KK','111','111'),
('ABCAA0273334088KK','111','111'),
('ABCAA0273334091KK','101010','341714'),
('ABCAA0273334095KK','111','111'),
('ABCAA0273334114KK','111','111'),
('ABCAA0273334195KK','20155','111');

[linzhicong1996]

[felixwluo]

Okay, let me repeat that

[felixwluo]

Looks like 2.0.4 has been fixed @linzhicong1996

[BiteTheDDDDt]

#28030