Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3276 Data result not correct when joinning subquery over a date field
  3. TEIID-3282

inconsistencies with the week function

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Done
    • Major
    • 8.10
    • None
    • Query Engine
    • None
    • Documentation (Ref Guide, User Guide, etc.), Release Notes

    Description

      For consistency we could enforce a standard iso behavior for the week function by default.

      For mysql there is the weekofyear function that matches the iso behavior.
      hsql uses iso by default
      oracle should use iw, not ww

      However:
      h2 uses the locale (the current teiid behavior)
      sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso.

      And there are still several others to verify

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-6016 oracle pushdown of day of week is not iso compatible

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: