Type:
Bug
Priority:
Major
Resolution:
Not a Bug
Affects Version/s:
None
MariaDB Connector/J uses java.sql.Time for TIME columns. TIME columns have a range of '-838:59:59.999999' to '838:59:59.999999'. According to Java documentation "java.sql.Time is a thin wrapper around java.util.Date ":
An hour is represented by an integer from 0 to 23. Thus, the hour from midnight to 1 a.m. is hour 0, and the hour from noon to 1 p.m. is hour 12.
A minute is represented by an integer from 0 to 59 in the usual manner.
A second is represented by an integer from 0 to 61; the values 60 and 61 occur only for leap seconds and even then only in Java implementations that actually track leap seconds correctly. Because of the manner in which leap seconds are currently introduced, it is extremely unlikely that two leap seconds will occur in the same minute, but this specification follows the date and time conventions for ISO C.
That means Connector/J supports only a tiny subset of possible values.
How to reproduce:
Create a table with a TIME column
Insert values outside of the range '00:00:00' - '23:59:59'
Try reading them using MariaDB Connector/J
Transition
Time In Source Status
Execution Times
Open
Closed
760d 23h 23m
1
{"report":{"fcp":781.6999999880791,"ttfb":225.30000001192093,"pageVisibility":"visible","entityId":75434,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"bfa6f064-aa63-4f90-8ddc-14f1c61bf12e","navigationType":0,"readyForUser":901.3999999761581,"redirectCount":0,"resourceLoadedEnd":922.8000000119209,"resourceLoadedStart":231.19999998807907,"resourceTiming":[{"duration":51,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":231.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":231.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":282.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":51,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":231.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":231.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":282.5,"responseStart":0,"secureConnectionStart":0},{"duration":96.40000003576279,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":231.5999999642372,"connectEnd":231.5999999642372,"connectStart":231.5999999642372,"domainLookupEnd":231.5999999642372,"domainLookupStart":231.5999999642372,"fetchStart":231.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":231.5999999642372,"responseEnd":328,"responseStart":328,"secureConnectionStart":231.5999999642372},{"duration":230.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":231.80000001192093,"connectEnd":231.80000001192093,"connectStart":231.80000001192093,"domainLookupEnd":231.80000001192093,"domainLookupStart":231.80000001192093,"fetchStart":231.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":231.80000001192093,"responseEnd":462.0999999642372,"responseStart":462.0999999642372,"secureConnectionStart":231.80000001192093},{"duration":233.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":232,"connectEnd":232,"connectStart":232,"domainLookupEnd":232,"domainLookupStart":232,"fetchStart":232,"redirectEnd":0,"redirectStart":0,"requestStart":232,"responseEnd":465.69999998807907,"responseStart":465.69999998807907,"secureConnectionStart":232},{"duration":234.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":232.19999998807907,"connectEnd":232.19999998807907,"connectStart":232.19999998807907,"domainLookupEnd":232.19999998807907,"domainLookupStart":232.19999998807907,"fetchStart":232.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":232.19999998807907,"responseEnd":466.5999999642372,"responseStart":466.5999999642372,"secureConnectionStart":232.19999998807907},{"duration":234.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":232.5,"connectEnd":232.5,"connectStart":232.5,"domainLookupEnd":232.5,"domainLookupStart":232.5,"fetchStart":232.5,"redirectEnd":0,"redirectStart":0,"requestStart":232.5,"responseEnd":467.39999997615814,"responseStart":467.39999997615814,"secureConnectionStart":232.5},{"duration":238.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":232.5999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":232.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":471.0999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":235.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":232.80000001192093,"connectEnd":232.80000001192093,"connectStart":232.80000001192093,"domainLookupEnd":232.80000001192093,"domainLookupStart":232.80000001192093,"fetchStart":232.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":232.80000001192093,"responseEnd":468.19999998807907,"responseStart":468.19999998807907,"secureConnectionStart":232.80000001192093},{"duration":238.4000000357628,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":232.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":232.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":471.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":236.10000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":233.0999999642372,"connectEnd":233.0999999642372,"connectStart":233.0999999642372,"domainLookupEnd":233.0999999642372,"domainLookupStart":233.0999999642372,"fetchStart":233.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":233.0999999642372,"responseEnd":469.19999998807907,"responseStart":469.19999998807907,"secureConnectionStart":233.0999999642372},{"duration":507.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":233.89999997615814,"connectEnd":233.89999997615814,"connectStart":233.89999997615814,"domainLookupEnd":233.89999997615814,"domainLookupStart":233.89999997615814,"fetchStart":233.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":233.89999997615814,"responseEnd":741.1999999880791,"responseStart":741.1999999880791,"secureConnectionStart":233.89999997615814},{"duration":547.3000000119209,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":234,"connectEnd":234,"connectStart":234,"domainLookupEnd":234,"domainLookupStart":234,"fetchStart":234,"redirectEnd":0,"redirectStart":0,"requestStart":234,"responseEnd":781.3000000119209,"responseStart":781.3000000119209,"secureConnectionStart":234},{"duration":259.80000001192093,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":482.39999997615814,"connectEnd":482.39999997615814,"connectStart":482.39999997615814,"domainLookupEnd":482.39999997615814,"domainLookupStart":482.39999997615814,"fetchStart":482.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":482.39999997615814,"responseEnd":742.1999999880791,"responseStart":742.1999999880791,"secureConnectionStart":482.39999997615814},{"duration":154.10000002384186,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":775.1999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":775.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":929.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":125.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":797.6999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":797.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":922.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":82.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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":798.5999999642372,"connectEnd":798.5999999642372,"connectStart":798.5999999642372,"domainLookupEnd":798.5999999642372,"domainLookupStart":798.5999999642372,"fetchStart":798.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":798.5999999642372,"responseEnd":881.3000000119209,"responseStart":881.3000000119209,"secureConnectionStart":798.5999999642372},{"duration":97.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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":799.0999999642372,"connectEnd":799.0999999642372,"connectStart":799.0999999642372,"domainLookupEnd":799.0999999642372,"domainLookupStart":799.0999999642372,"fetchStart":799.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":799.0999999642372,"responseEnd":896.3000000119209,"responseStart":896.3000000119209,"secureConnectionStart":799.0999999642372}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":49,"responseStart":225,"responseEnd":227,"domLoading":229,"domInteractive":966,"domContentLoadedEventStart":966,"domContentLoadedEventEnd":1009,"domComplete":1203,"loadEventStart":1203,"loadEventEnd":1204,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":936.5},{"name":"bigPipe.sidebar-id.end","time":937.3000000119209},{"name":"bigPipe.activity-panel-pipe-id.start","time":937.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":938.3999999761581},{"name":"activityTabFullyLoaded","time":1021.3999999761581}],"measures":[],"correlationId":"b52fadc2624e8a","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":101,"dbReadsTimeInMs":12,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}