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

Update always modifies the first timestamp column in a table.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • None
    • N/A
    • Data types
    • None
    • windows x64

    Description

      Very surprising issue, reproduced in both mariadb 10.2 and mysql. Different ENGINE doesn't affect the result.

      Reproduce:
      CREATE TABLE `ttt` (`ii` int, `dd` TIMESTAMP, `d2` TIMESTAMP);
      insert into ttt (dd, d2) values ('2017-01-01 00:00:00', '2017-08-02 20:45:10');

      SELECT * FROM ttt; ## OK, returns null 2017-01-01 00:00:00 2017-08-02 20:45:10
      update ttt set ii=1;

      SELECT * FROM ttt; ## Returns 1 2017-09-04 14:14:28 2017-08-02 20:45:10

      Attachments

        Activity

          People

            Unassigned Unassigned
            JDoughnut John Doughnut
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.