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

query with local and remote pushes too much to remote

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • None
    • 12.3.1
    • Query Engine
    • None

    Description

      I have a table "A" in an Oracle database. I have a date dimension "B" in Teiid, which is a materialized view of a recursive query. The date dimension has all dates from 1950 to 2050, 36890 rows in total.

      I run the following query:

      SELECT *
        FROM a
             JOIN b
               ON a.date_column = b.date_key
      

      Teiid sends a query to Oracle, which I will paraphrase as:

      SELECT <columns>
        FROM a
       WHERE date_column IN (to_date('1950-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 
                             <36899 other date values!>)
      

      Oracle breaks either with the length of the query or the number of options in the IN clause.

      I thought that MAKEDEP/MAKENOTDEP/MAKEIND could help, but they didn't seem to change anything.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            kgeis Ken Geis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: