This SQL script:
SET timestamp=UNIX_TIMESTAMP('2014-04-14 10:20:30');
|
SELECT CAST(TIME'10:20:30' AS DATETIME), TIME'10:20:30'=TIMESTAMP'2014-04-14 10:20:30' AS cmp;
|
demonstrates that conversion between TIME and DATETIME
does not add CURRENT_DATE to TIME.
+----------------------------------+-----+
|
| CAST(TIME'10:20:30' AS DATETIME) | cmp |
|
+----------------------------------+-----+
|
| 2014-04-14 10:20:30 | 0 |
|
+----------------------------------+-----+
|
MySQL-5.6 returns "1" in the "cmp" field in the same scenario.
There are no comments yet on this issue.
{"report":{"fcp":913.4000000059605,"ttfb":268.09999999403954,"pageVisibility":"visible","entityId":35117,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"4e043cf0-f260-48ae-9b66-8a14a67d2055","navigationType":0,"readyForUser":969,"redirectCount":0,"resourceLoadedEnd":692.0999999940395,"resourceLoadedStart":275,"resourceTiming":[{"duration":135.90000000596046,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":275,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":275,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":410.90000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":135.89999997615814,"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":275.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":275.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":411.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":191,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":275.59999999403954,"connectEnd":275.59999999403954,"connectStart":275.59999999403954,"domainLookupEnd":275.59999999403954,"domainLookupStart":275.59999999403954,"fetchStart":275.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":415,"responseEnd":466.59999999403954,"responseStart":427.90000000596046,"secureConnectionStart":275.59999999403954},{"duration":204.90000000596046,"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":275.69999998807907,"connectEnd":275.69999998807907,"connectStart":275.69999998807907,"domainLookupEnd":275.69999998807907,"domainLookupStart":275.69999998807907,"fetchStart":275.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":415,"responseEnd":480.59999999403954,"responseStart":428.40000000596046,"secureConnectionStart":275.69999998807907},{"duration":150.89999997615814,"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":275.80000001192093,"connectEnd":275.80000001192093,"connectStart":275.80000001192093,"domainLookupEnd":275.80000001192093,"domainLookupStart":275.80000001192093,"fetchStart":275.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":415.69999998807907,"responseEnd":426.69999998807907,"responseStart":426,"secureConnectionStart":275.80000001192093},{"duration":156.30000001192093,"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":276,"connectEnd":276,"connectStart":276,"domainLookupEnd":276,"domainLookupStart":276,"fetchStart":276,"redirectEnd":0,"redirectStart":0,"requestStart":417,"responseEnd":432.30000001192093,"responseStart":431.80000001192093,"secureConnectionStart":276},{"duration":161.60000002384186,"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":276.19999998807907,"connectEnd":276.19999998807907,"connectStart":276.19999998807907,"domainLookupEnd":276.19999998807907,"domainLookupStart":276.19999998807907,"fetchStart":276.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":418.09999999403954,"responseEnd":437.80000001192093,"responseStart":437.30000001192093,"secureConnectionStart":276.19999998807907},{"duration":141.39999997615814,"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":276.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":276.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":417.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":169.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":276.5,"connectEnd":276.5,"connectStart":276.5,"domainLookupEnd":276.5,"domainLookupStart":276.5,"fetchStart":276.5,"redirectEnd":0,"redirectStart":0,"requestStart":420.90000000596046,"responseEnd":445.80000001192093,"responseStart":445.19999998807907,"secureConnectionStart":276.5},{"duration":142.80000001192093,"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":276.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":276.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":419.5,"responseStart":0,"secureConnectionStart":0},{"duration":171.09999999403954,"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":276.90000000596046,"connectEnd":276.90000000596046,"connectStart":276.90000000596046,"domainLookupEnd":276.90000000596046,"domainLookupStart":276.90000000596046,"fetchStart":276.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":421.90000000596046,"responseEnd":448,"responseStart":447.5,"secureConnectionStart":276.90000000596046},{"duration":396.40000000596046,"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":283.69999998807907,"connectEnd":283.69999998807907,"connectStart":283.69999998807907,"domainLookupEnd":283.69999998807907,"domainLookupStart":283.69999998807907,"fetchStart":283.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":523.9000000059605,"responseEnd":680.0999999940395,"responseStart":678.4000000059605,"secureConnectionStart":283.69999998807907},{"duration":408.19999998807907,"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":283.90000000596046,"connectEnd":283.90000000596046,"connectStart":283.90000000596046,"domainLookupEnd":283.90000000596046,"domainLookupStart":283.90000000596046,"fetchStart":283.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":671.0999999940395,"responseEnd":692.0999999940395,"responseStart":691.5,"secureConnectionStart":283.90000000596046},{"duration":174.2000000178814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":675.6999999880791,"connectEnd":675.6999999880791,"connectStart":675.6999999880791,"domainLookupEnd":675.6999999880791,"domainLookupStart":675.6999999880791,"fetchStart":675.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":816.9000000059605,"responseEnd":849.9000000059605,"responseStart":849.0999999940395,"secureConnectionStart":675.6999999880791},{"duration":107.90000000596046,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":887,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":887,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":994.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":48.400000005960464,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":905.9000000059605,"connectEnd":905.9000000059605,"connectStart":905.9000000059605,"domainLookupEnd":905.9000000059605,"domainLookupStart":905.9000000059605,"fetchStart":905.9000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":921.6999999880791,"responseEnd":954.3000000119209,"responseStart":953.6999999880791,"secureConnectionStart":905.9000000059605}],"fetchStart":0,"domainLookupStart":85,"domainLookupEnd":89,"connectStart":89,"connectEnd":110,"secureConnectionStart":98,"requestStart":111,"responseStart":268,"responseEnd":282,"domLoading":271,"domInteractive":1020,"domContentLoadedEventStart":1020,"domContentLoadedEventEnd":1054,"domComplete":1247,"loadEventStart":1247,"loadEventEnd":1247,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1003},{"name":"bigPipe.sidebar-id.end","time":1003.9000000059605},{"name":"bigPipe.activity-panel-pipe-id.start","time":1004.0999999940395},{"name":"bigPipe.activity-panel-pipe-id.end","time":1004.5},{"name":"activityTabFullyLoaded","time":1063}],"measures":[],"correlationId":"75ce7cf9c96bb5","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision
