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

    • Enhancement
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Done
    • 7.7.1
    • 8.1
    • JDBC Connector
    • 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

            rhn-engineering-shawkins Steven Hawkins
            pnittel_jira Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: