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
|
{"report":{"fcp":1207.8999996185303,"ttfb":423,"pageVisibility":"visible","entityId":64182,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"09f1ed0f-cd0e-43a2-89b7-ca68f715cc40","navigationType":0,"readyForUser":1302.6000003814697,"redirectCount":0,"resourceLoadedEnd":1705.6999998092651,"resourceLoadedStart":436.1000003814697,"resourceTiming":[{"duration":156.0999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":436.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":436.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":592.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":158.39999961853027,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":436.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":436.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":594.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":221.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":436.6000003814697,"connectEnd":436.6000003814697,"connectStart":436.6000003814697,"domainLookupEnd":436.6000003814697,"domainLookupStart":436.6000003814697,"fetchStart":436.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":436.6000003814697,"responseEnd":658.5,"responseStart":658.5,"secureConnectionStart":436.6000003814697},{"duration":318.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":436.69999980926514,"connectEnd":436.69999980926514,"connectStart":436.69999980926514,"domainLookupEnd":436.69999980926514,"domainLookupStart":436.69999980926514,"fetchStart":436.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":436.69999980926514,"responseEnd":755,"responseStart":755,"secureConnectionStart":436.69999980926514},{"duration":322.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":436.8999996185303,"connectEnd":436.8999996185303,"connectStart":436.8999996185303,"domainLookupEnd":436.8999996185303,"domainLookupStart":436.8999996185303,"fetchStart":436.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":436.8999996185303,"responseEnd":759.6999998092651,"responseStart":759.6000003814697,"secureConnectionStart":436.8999996185303},{"duration":323.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":437.1000003814697,"connectEnd":437.1000003814697,"connectStart":437.1000003814697,"domainLookupEnd":437.1000003814697,"domainLookupStart":437.1000003814697,"fetchStart":437.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":437.1000003814697,"responseEnd":760.3000001907349,"responseStart":760.3000001907349,"secureConnectionStart":437.1000003814697},{"duration":323.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":437.3999996185303,"connectEnd":437.3999996185303,"connectStart":437.3999996185303,"domainLookupEnd":437.3999996185303,"domainLookupStart":437.3999996185303,"fetchStart":437.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":437.3999996185303,"responseEnd":761.3000001907349,"responseStart":761.3000001907349,"secureConnectionStart":437.3999996185303},{"duration":379.6000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":437.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":437.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":817.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":324.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":437.69999980926514,"connectEnd":437.69999980926514,"connectStart":437.69999980926514,"domainLookupEnd":437.69999980926514,"domainLookupStart":437.69999980926514,"fetchStart":437.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":437.69999980926514,"responseEnd":762,"responseStart":762,"secureConnectionStart":437.69999980926514},{"duration":379.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":437.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":437.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":817.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":325.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":438,"connectEnd":438,"connectStart":438,"domainLookupEnd":438,"domainLookupStart":438,"fetchStart":438,"redirectEnd":0,"redirectStart":0,"requestStart":438,"responseEnd":763.1000003814697,"responseStart":763.1000003814697,"secureConnectionStart":438},{"duration":513,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":438.80000019073486,"connectEnd":438.80000019073486,"connectStart":438.80000019073486,"domainLookupEnd":438.80000019073486,"domainLookupStart":438.80000019073486,"fetchStart":438.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":438.80000019073486,"responseEnd":951.8000001907349,"responseStart":951.8000001907349,"secureConnectionStart":438.80000019073486},{"duration":1223.8999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":438.80000019073486,"connectEnd":438.80000019073486,"connectStart":438.80000019073486,"domainLookupEnd":438.80000019073486,"domainLookupStart":438.80000019073486,"fetchStart":438.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":438.80000019073486,"responseEnd":1662.6999998092651,"responseStart":1662.6999998092651,"secureConnectionStart":438.80000019073486},{"duration":196.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":841,"connectEnd":841,"connectStart":841,"domainLookupEnd":841,"domainLookupStart":841,"fetchStart":841,"redirectEnd":0,"redirectStart":0,"requestStart":841,"responseEnd":1037.3000001907349,"responseStart":1037.3000001907349,"secureConnectionStart":841},{"duration":557.8000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1147.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1147.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1705.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":528.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1148.8999996185303,"connectEnd":1148.8999996185303,"connectStart":1148.8999996185303,"domainLookupEnd":1148.8999996185303,"domainLookupStart":1148.8999996185303,"fetchStart":1148.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1148.8999996185303,"responseEnd":1677.1999998092651,"responseStart":1677.1999998092651,"secureConnectionStart":1148.8999996185303},{"duration":534,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1149.3000001907349,"connectEnd":1149.3000001907349,"connectStart":1149.3000001907349,"domainLookupEnd":1149.3000001907349,"domainLookupStart":1149.3000001907349,"fetchStart":1149.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1149.3000001907349,"responseEnd":1683.3000001907349,"responseStart":1683.3000001907349,"secureConnectionStart":1149.3000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":257,"responseStart":422,"responseEnd":429,"domLoading":433,"domInteractive":1729,"domContentLoadedEventStart":1729,"domContentLoadedEventEnd":1769,"domComplete":2312,"loadEventStart":2312,"loadEventEnd":2313,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1709.3000001907349},{"name":"bigPipe.sidebar-id.end","time":1710.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1710.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1711.3999996185303},{"name":"activityTabFullyLoaded","time":1790.5}],"measures":[],"correlationId":"93bdaa3ffbc92b","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
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.