[teiid-issues] [JBoss JIRA] (TEIID-2128) MySQL 5.5 dropped support for SQL_TSI_FRAC_SECOND; now using non-standard MICROSECOND

[Paul Nittel (JIRA)]

Paul Nittel created TEIID-2128:
----------------------------------

             Summary: MySQL 5.5 dropped support for SQL_TSI_FRAC_SECOND; now using non-standard MICROSECOND
                 Key: TEIID-2128
                 URL: https://issues.jboss.org/browse/TEIID-2128
             Project: Teiid
          Issue Type: Enhancement
          Components: JDBC Connector
    Affects Versions: 7.7.1
            Reporter: Paul Nittel
            Assignee: Steven Hawkins
            Priority: Minor


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.)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira