starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

ERROR_IF_OVERFLOW sql mode doesn‘t take effect in functions like avg

Open packy92 opened this issue 9 months ago • 0 comments

Steps to reproduce the behavior (Required)

  1. CREATE TABLE '...'
  2. INSERT INTO '....'
  3. 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()

packy92 avatar May 09 '24 08:05 packy92