Uploaded image for project: 'Shibboleth User Interface'
  1. Shibboleth User Interface
  2. SHIBUI-2249

Datetime precision above 6 is not supported in Mysql 5.6+

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 1.10.1
    • None
    • None
    • 10/22/21 - 11/5/21

    Description

      As of MySQL 5.6 and above, no more than 6 precision is allowed. Anything higher... (9) will result in an error ala:

       

      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too-big precision 9 specified for 'created_date'. Maximum is 6

      Attachments

        Activity

          People

            charles.hasegawa@at.internet2.edu Charles Hasegawa (unicon.net)
            charles.hasegawa@at.internet2.edu Charles Hasegawa (unicon.net)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: