starrocks
starrocks copied to clipboard
ERROR_IF_OVERFLOW sql mode doesn‘t take effect in functions like avg
Steps to reproduce the behavior (Required)
- CREATE TABLE '...'
- INSERT INTO '....'
- SELECT '....'
https://github.com/StarRocks/starrocks/pull/30419
The above pr support error reporting when decimal overflow by introducing a OverflowMode, while only basic math function can take effect. Fucntions like agg may still return a wrong result when
ERROR_IF_OVERFLOW
is enabled.
Expected behavior (Required)
throw exception when set ERROR_IF_OVERFLOW
Real behavior (Required)
StarRocks version (Required)
- You can get the StarRocks version by executing SQL
select current_version()