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

Unable to insert valid value to TIMESTAMP column

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 5.5.46
    • Fix Version/s: N/A
    • Component/s: Temporal Types
    • Labels:
    • Environment:
      Linux 3.11.10-32-desktop x86_64 (OpenSUSE 13.1), Intel Core i5

      Description

      Unable to insert some valid values to TIMESTAMP column.
      Steps to reproduce the bug:

      1. Create new database: `create database SANDBOX;`
      2. Create new table: `create table test (id int primary key auto_increment, time timestamp not null);`
      3. Insert new row: `insert into test (time) values ('1984-04-01 00:59:37');`
        Expected result:
        `Query OK, 1 row affected (X.XX sec)`
        Actual result:
        `ERROR 1292 (22007): Incorrect datetime value: '1984-04-01 00:59:37' for column 'time' at row 1`

      Additional info:
      Another one value that causes the error: '2000-03-26 02:15:36'.
      But, if I try to insert, say, '1974-04-01 00:59:37' or '1994-04-01 00:59:37' or '2001-03-26 02:15:36', it inserts without any error.
      The error also happens if I try to update columns to set these values.

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            bbb914 Sergey
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: