Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2919

BigInteger and BigDecimal datatypes are converted into string in MongoDB translator

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.8, 8.7.1
    • 8.4
    • Misc. Connectors
    • None

    Description

      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}

      }

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            felias_jira Filip Elias (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: