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

main.type_datetime failed in buildbot, results mismatch

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/10315/steps/test_3/logs/stdio

      main.type_datetime                       w1 [ fail ]
              Test ended at 2017-11-08 00:00:00
       
      CURRENT_TEST: main.type_datetime
      --- /mnt/buildbot/build/mariadb-10.0.34/mysql-test/r/type_datetime.result	2017-11-07 20:01:16.000000000 +0200
      +++ /mnt/buildbot/build/mariadb-10.0.34/mysql-test/r/type_datetime.reject	2017-11-08 00:00:00.000000000 +0200
      @@ -59,8 +59,6 @@
       drop table t1;
       CREATE TABLE t1 (a 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
      @@ -233,7 +231,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');
      @@ -300,6 +298,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
      

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: