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

Vertica and DB2 translators use incorrect push down of WEEK function

    Details

      Description

      TEIID-3282 changed the semantics of the WEEK function to use the iso behaviour.

      The Vertica database has WEEK_ISO function that returns the iso week, but the translator does not have that alias set.

      This results in the query (the datevalue in question is 2000-12-31)

      select week(datevalue) from source.largea where intkey = 365
      

      to return 54, when the correct value is 52.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                asmigala Andrej Šmigala
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: