[teiid-issues] [JBoss JIRA] (TEIID-2919) BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
[
https://issues.jboss.org/browse/TEIID-2919?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2919:
---------------------------------------
It looks like values of those types should be converted to Double, rather than string (at
the risk of some precision loss). As Ramesh is getting at though, it is somewhat of a
usage error to choose a type that not natively supported.
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: Ramesh Reddy
Fix For: 8.7.1
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}}
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)