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

Issues with OData query generation logic

    XMLWordPrintable

    Details

      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

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: