[MDEV-14322] main.type_datetime failed in buildbot, results mismatch Created: 2017-11-08  Updated: 2018-10-15  Resolved: 2018-10-15

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: 10.0.37, 10.3.11, 10.4.0, 10.1.37, 10.2.19

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None


 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



 Comments   
Comment by Alexander Barkov [ 2017-11-08 ]

This tests seems to fail when the current time is exactle 00:00:00.
It was "2017-11-08 00:00:00" sharp when BuildBot run this tests and failed.

Generated at Thu Feb 08 08:12:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.