Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4650

Predicates in HAVING clause should be pushed down to restricted VTIs

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 10.6.1.0
    • None
    • SQL
    • Normal
    • Repro attached
    • Performance

    Description

      If you perform a query with an aggregate function against a restricted table function, the predicates in the HAVING clause are not pushed down to the table function.

      Attachments

        1. test.diff
          1 kB
          Knut Anders Hatlen

        Activity

          People

            Unassigned Unassigned
            knutanders Knut Anders Hatlen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: