VARIANT data: Rounding changes to some of the fixed numeric values cast to floating-point (Preview)¶

For the current status of the bundle, refer to Bundle History.

When this bundle is enabled and you extract a fixed numeric value from a VARIANT value and cast the numeric value to a floating-point type, the resulting value might be rounded differently or to a different value.

This behavior change occurs in cases when the cast is narrow — in other words, when the cast type cannot hold the value, so the value needs to be rounded.

For example, when the fixed numeric value 264208207.9326154526043824 in a VARIANT column is cast to FLOAT, the resulting value before the behavior change is different than the value after the behavior change:

• Original numeric value (before casting to FLOAT):

  264208207.9326154526043824
  

  Copy

• Numeric value before the behavior change (after casting to FLOAT):

  264208207.9326154
  

  Copy

• Numeric value after the behavior change (after casting to FLOAT):

  264208207.93261546
  

  Copy

This behavior change is being introduced to make the casting result consistent with casting a numeric value that is not in a VARIANT value.

Ref: 2106