Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13511

MariaDB no longer accepts ISO 8601 with trailing Z

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 10.2.7
    • N/A
    • Time zones
    • None

    Description

      It works with ADDTIME, but not when inserting.

      MariaDB [(none)]> SELECT ADDTIME('2016-10-12T23:00:00Z', '1');
      +--------------------------------------+
      | ADDTIME('2016-10-12T23:00:00Z', '1') |
      +--------------------------------------+
      | 2016-10-12 23:00:01                  |
      +--------------------------------------+
      1 row in set, 1 warning (0.00 sec)
       
      MariaDB [(none)]> INSERT INTO db.table (start) VALUES ('2016-10-12T23:00:00Z');
      ERROR 1292 (22007): Incorrect datetime value: '2016-10-12T23:00:00Z' for column 'start' at row 1
       
      MariaDB [(none)]> INSERT INTO db.table (start) VALUES ('2016-10-12T23:00:00');
      Query OK, 1 row affected (0.00 sec)
      

      Inserting with a trailing Z does work in another db that is 10.1.19. What has changed? It's valid ISO8601 as far as I know.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            sarke Peter Sarkozi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.