[
https://issues.jboss.org/browse/TEIID-2919?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2919:
-------------------------------------
I do not think Mongo has big decimal type, need to see what are the alternatives
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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira