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

tokudb.type_datetime failed in buildbot with wrong result

    XMLWordPrintable

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos6-amd64-openssl/builds/4/steps/test/logs/stdio

      tokudb.type_datetime                     w4 [ fail ]
              Test ended at 2018-01-04 00:00:01
       
      CURRENT_TEST: tokudb.type_datetime
      --- /usr/local/mariadb-10.1.31-linux-x86_64/mysql-test/plugin/tokudb/tokudb/r/type_datetime.result	2018-01-03 22:02:12.000000000 +0200
      +++ /usr/local/mariadb-10.1.31-linux-x86_64/mysql-test/plugin/tokudb/tokudb/r/type_datetime.reject	2018-01-04 00:00:00.872549140 +0200
      @@ -61,8 +61,6 @@
       drop table t1;
       CREATE TABLE t1 (a timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, b date, c time, d datetime);
       insert into t1 (b,c,d) values(now(),curtime(),now());
      -Warnings:
      -Note	1265	Data truncated for column 'b' at row 1
       select date_format(a,"%Y-%m-%d")=b,right(a+0,6)=c+0,a=d+0 from t1;
       date_format(a,"%Y-%m-%d")=b	right(a+0,6)=c+0	a=d+0
       1	1	1
      @@ -235,7 +233,7 @@
       insert into t1(f1) values(curdate());
       select curdate() < now(), f1 < now(), cast(f1 as date) < now() from t1;
       curdate() < now()	f1 < now()	cast(f1 as date) < now()
      -1	1	1
      +0	0	0
       delete from t1;
       insert into t1 values('2001-01-01','2001-01-01 01:01:01','2001-01-01 01:01:01');
       insert into t1 values('2001-02-05','2001-02-05 00:00:00','2001-02-05 01:01:01');
      @@ -302,6 +300,7 @@
       2001-04-15 00:00:00
       SELECT 1 from dual where NOW() BETWEEN CURRENT_DATE() - INTERVAL 1 DAY AND CURRENT_DATE();
       1
      +1
       drop table t1;
       create table t1 (f1 date);
       insert into t1 values('01-01-01'),('01-01-02'),('01-01-03');
       
      mysqltest: Result length mismatch
       
       
      Warnings from just before the error:
      Warning 1265 Data truncated for column 't' at row 1 
      Warning 1264 Out of range value for column 't' at row 1
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            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.