-- Version : doris-2.0.11
SELECT 1 FROM DUAL WHERE CAST(2.2222 AS DECIMAL(26, 2)) != 2.22
> 1
SELECT 1 FROM DUAL WHERE CAST(2.2222 AS DECIMAL(26, 2)) = 2.22
>
SELECT 1 FROM DUAL WHERE CAST(0.0002 AS DECIMAL(26, 2)) != 0.00
>
SELECT 1 FROM DUAL WHERE CAST(0.0002 AS DECIMAL(26, 2)) = 0.00
> 1
-- Version : mysql-8.0.32
SELECT 1 FROM DUAL WHERE CAST(2.2222 AS DECIMAL(26, 2)) != 2.22;
>
SELECT 1 FROM DUAL WHERE CAST(2.2222 AS DECIMAL(26, 2)) = 2.22;
> 1
SELECT 1 FROM DUAL WHERE CAST(0.0002 AS DECIMAL(26, 2)) != 0.00
>
SELECT 1 FROM DUAL WHERE CAST(0.0002 AS DECIMAL(26, 2)) = 0.00
> 1