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

MongoDB translator issues with aggregate function expressions

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Backlog
    • 8.7
    • Misc. Connectors
    • None

    Description

      MongoDB queries involing expressions with aggregate functions in the select or having clauses will fail. It appears that another projection phase is needed to handling those computations as they are not valid in the group operation.

      For example, these result in exceptions:

      SELECT min(e1)+1, e2 FROM TIME_TEST GROUP BY e2
      SELECT min(e1), e2 FROM TIME_TEST GROUP BY e2 HAVING year(e2) + count(*) = 2

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: