GitHub user traflm opened a pull request:
https://github.com/apache/trafodion/pull/1570
[TRAFODION-3015] query no result when comparing string with BIGNUM
When the column is BIGNUM, and the predicate is comparing to a string.
Trafodion cast the string into FLOAT and the convert FLOAT into BIGNUM,
There is an issue when convert FLOAT into BIGNUM that didn't considering
the rounding:
so 2.73804679999999968E+007 will become 27380467 instead of 27380468
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/traflm/trafodion TRAFODION-3015-2
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1570.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1570
----
commit fac342d0b06c1e248b6389c070ccb62ce37a60a9
Author: Liu Ming <ovis_poly@...>
Date: 2018-05-19T10:47:14Z
[TRAFODION-3015] compare string to BIGNUM return no result
commit a08afe4940b828309e80f91ee0f2c29aaf08f5c6
Author: Liu Ming <ovis_poly@...>
Date: 2018-05-19T11:56:59Z
add regression test
----
---
