]
Steven Hawkins resolved TEIID-2919.
-----------------------------------
Assignee: Steven Hawkins (was: Ramesh Reddy)
Fix Version/s: 8.8
Resolution: Done
Switched to using Double values for these numeric values.
BigInteger and BigDecimal datatypes are converted into string in
MongoDB translator
-------------------------------------------------------------------------------------
Key: TEIID-2919
URL:
https://issues.jboss.org/browse/TEIID-2919
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.4
Reporter: Filip Elias
Assignee: Steven Hawkins
Fix For: 8.7.1, 8.8
Description of problem:
BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
(MongoDBExecutionFactory.java). User can't use these datatypes in the WHERE clause.
For example
The query:
SELECT IntKey FROM SmallA where BIGINTEGERVALUE > 1
returns no results because BIGINTEGERVALUE > 1 is converted into
{ "BIGINTEGERVALUE" : { "$gt" : "1"}}
but is should be
{ "BIGINTEGERVALUE" : { "$gt" : 1}}