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

MySQL 5.5 dropped support for SQL_TSI_FRAC_SECOND; now using non-standard MICROSECOND

    XMLWordPrintable

    Details

    • Type: Enhancement
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Done
    • Affects Version/s: 7.7.1
    • Fix Version/s: 8.1
    • Component/s: JDBC Connector
    • Labels:
      None

      Description

      MySQL used to support SQL_TSI_FRAC_SECOND, but (for whatever reason) dropped that in favor of MICROSECOND. Our translator now needs to be able to recognize this new value.

      Unless changed, users cannot add fractions of seconds to a timestamp using the timestampadd function. (A small-probability usecase.)

        Attachments

          Activity

            People

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            pnittel Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: