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

mroonga/storage.column_datetime_freebsd_before_unix_epoch fails with ER_WARN_DATA_OUT_OF_RANGE

    XMLWordPrintable

Details

    Description

      Other versions are likely affected too, I didn't check

      The test is specific for FreeBSD, yet it fails on FreeBSD. I'm not sure what it tried to achieve and why it was specific to FreeBSD. The error is not MTR-specific, the same CREATE/INSERT fails the same way on a manually started server on FreeBSD, but not on Linux.

      CURRENT_TEST: mroonga/storage.column_datetime_freebsd_before_unix_epoch
      mysqltest: At line 30: query 'INSERT INTO diaries (title, created_at)
      VALUES ('1000-01-01 00:00:00', '1000-01-01 00:00:00')' failed: 1264: Out of range value for column 'created_at' at row 1
       
      The result from queries just before the failure was:
      DROP TABLE IF EXISTS diaries;
      CREATE TABLE diaries (
      id INT PRIMARY KEY AUTO_INCREMENT,
      title TEXT,
      created_at DATETIME
      ) DEFAULT CHARSET UTF8;
      INSERT INTO diaries (title, created_at)
      VALUES ('1000-01-01 00:00:00', '1000-01-01 00:00:00');
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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