Archives of the TeradataForum
Message Posted: Mon, 16 Feb 2015 @ 09:35:02 GMT
Exponentiation is a floating point operation which produces an inexact result.
In order to avoid systematic inaccuracies, sometimes it produces a number greater than the exact result, sometimes less than the exact result. The conversion from float to integer is dictated by the SQL standard to be a truncation operation. When the inexact result is less than the exact integer
result, this truncation produces an unexpected result. However, this is the logical result of providing accuracy and confomance to the standard.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|