Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1084373

Summary: BigInteger and BigDecimal datatypes are converted into string in MongoDB translator
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Filip Elias <felias>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.0.0CC: atangrin, dlesage, felias, vhalbert
Target Milestone: ER1Keywords: QA-Closed
Target Release: 6.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
If the BigInteger and BigDecimal datatypes were converted into strings in the MongoDB translator (MongoDBExecutionFactory.java). the user could not access them in WHERE clauses. That is because these strings should have been converted into the type Double instead. They now convert correctly and uses can access them in WHERE clauses as a result.
Story Points: ---
Clone Of: Environment:
DV 6.0
Last Closed: 2016-02-10 08:49:18 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Filip Elias 2014-04-04 08:23:33 UTC
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}}

Comment 2 Filip Elias 2014-04-07 09:51:26 UTC
The teiid JIRA is created.

Comment 3 JBoss JIRA Server 2014-05-07 16:56:12 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-2919 to Resolved

Comment 4 JBoss JIRA Server 2014-10-21 13:54:07 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-2919 to Closed