[ERROR_IF_OVERFLOW]If the computed number is a constant, the overflow still returns null

[chengqianli-git]

Steps to reproduce the behavior (Required)

1. CREATE TABLE '...'
2. INSERT INTO '....'
3. SELECT '....'`4.

mysql> show create table test_float;
+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table      | Create Table                                                                                                                                                                                                                                                                                                 |
+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test_float | CREATE TABLE `test_float` (
  `a` int(11) NULL COMMENT "",
  `b` float NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`a`)
DISTRIBUTED BY RANDOM
PROPERTIES (
"bucket_size" = "4294967296",
"compression" = "LZ4",
"fast_schema_evolution" = "true",
"replicated_storage" = "true",
"replication_num" = "3"
); |
+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

mysql> select /*+ SET_VAR(sql_mode='ERROR_IF_OVERFLOW')*/  cast(b * 2147483648 as decimal32(5,2)) from test_float;
ERROR 1064 (HY000): Expr evaluate meet error: The type cast from other types to decimal overflows: BE:10003
mysql>
mysql> select /*+ SET_VAR(sql_mode='ERROR_IF_OVERFLOW')*/  cast(1.234 * 2147483648 as decimal32(5,2)) from test_float;

Expected behavior (Required)

response error info

Real behavior (Required)

mysql> select /*+ SET_VAR(sql_mode='ERROR_IF_OVERFLOW')*/  cast(1.234 * 2147483648 as decimal32(5,2)) from test_float;
+----------------------------------------------+
| CAST((1.234 * 2147483648) AS DECIMAL32(5,2)) |
+----------------------------------------------+
|                                         NULL |
+----------------------------------------------+

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()