关闭了了decimal 转varchar的严格模式, 但是decimal的结果还是补0: 2025.000000

[colagy]

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述

set global cbo_decimal_cast_string_strict=false;

set cbo_decimal_cast_string_strict=false;

drop table test_decimal force;

create table test_decimal (a string,b decimal(38,8));

insert into test_decimal values(2025,2025);

select CONCAT(CONCAT(CONCAT(CONCAT(cast((case when CAST(a AS DECIMAL(38, 8)) is not null then CAST(a AS DECIMAL(38, 8)) else 0 end + 1) AS VARCHAR), '-'), 1), '-'), 1) from test_decimal;

-- 2026.00000000-1-1

select CONCAT(CONCAT(CONCAT(CONCAT(cast((case when CAST(b AS DECIMAL(38, 8)) is not null then CAST(b AS DECIMAL(38, 8)) else 0 end + 1) AS VARCHAR), '-'), 1), '-'), 1) from test_decimal;

-- 2026.00000000-1-1

select CONCAT(CONCAT(CONCAT(CONCAT(cast((CAST(a AS DECIMAL(38, 8)) + 1) AS VARCHAR), '-'), 1), '-'), 1) from test_decimal;

-- 2026.00000000-1-1

select cast(b +1 as varchar) from test_decimal;

-- 2026.00000000

select cast(b as varchar) from test_decimal;

-- 2025.00000000

【StarRocks版本】例如：3.3.12