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
|