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
|