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

Issues with OData query generation logic

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 9.1, 9.0.4, 8.12.7.6_3
    • 8.12
    • OData
    • None

    Description

      When the ODataExpressionToSQLBuilder changes the ctxExpression, ctxQuery and other state it needs to revert back, but currently does not.

      For example reordering the predicate:

      /odata4/vdb/PM1/G1?$filter=e1 eq $root/G1(1)/e1

      to

      /odata4/vdb/PM1/G1?$filter=$root/G1(1)/e1 eq e1

      results in a source query:

      SELECT g0.e1, g0.e2, g0.e3 FROM PM1.G1 AS g0 WHERE (SELECT g1.e1 FROM PM1.G1 AS g1 WHERE g1.e2 = 1) = (SELECT g1.e1 FROM PM1.G1 AS g1 WHERE g1.e2 = 1) ORDER BY g0.e2

      That has both sides of the predicate as subqueries.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: