• mhansson/martin@linux-st28.site's avatar
    Bug#33143: Incorrect ORDER BY for ROUND()/TRUNCATE() result · effe27e3
    mhansson/martin@linux-st28.site authored
    The ROUND(X, D) function would change the Item::decimals field during
    execution to achieve the effect of a dynamic number of decimal digits.
    This caused a series of bugs:
    Bug #30617:Round() function not working under some circumstances in InnoDB
    Bug #33402:ROUND with decimal and non-constant cannot round to 0 decimal places
    Bug #30889:filesort and order by with float/numeric crashes server
    Fixed by never changing the number of shown digits for DECIMAL when
    used with a nonconstant number of decimal digits.
    effe27e3
item_func.cc 137 KB