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

MariaDB no longer accepts ISO 8601 with trailing Z

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 10.2.7
    • Fix Version/s: N/A
    • Component/s: Time zones
    • Labels:
      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

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration