[teiid-issues] [JBoss JIRA] (TEIID-2919) BigInteger and BigDecimal datatypes are converted into string in MongoDB translator

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965937#comment-12965937 ] 

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)