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.8, 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}}