If we use the getString() method to get the value from a ResultSet for a integer column with the zerofill option the value we obtain doesn't have the expected leading zeros.
We can reproduce the behavior with the next snippet:
{
Connection connection = DriverManager.getConnection (connectionString, user, password);
Statement st = connection.createStatement();
st.executeUpdate("drop table if exists tmpTest;");
st.executeUpdate("create table tmpTest (id int unsigned primary key auto_increment, value smallint(3) unsigned zerofill not null unique);");
st.executeUpdate("insert into tmpTest(value) values (1), (4), (5), (8);");
PreparedStatement pst1 = connection.prepareStatement("select value from tmpTest");
ResultSet rs1 = pst1.executeQuery();
while(rs1.next())
{
System.out.println("Value: " + rs1.getString("value"));
}
rs1.close();
pst1.close();
st.close();
connection.close();
}
Using the 1.1.8 or 1.2.3 versions of the connector this returns the expected result:
Value: 001
Value: 004
Value: 005
Value: 008
In any version after 1.3.0 the behavior changes:
Value: 1
Value: 4
Value: 5
Value: 8
{"report":{"fcp":793.2000000476837,"ttfb":167.30000001192093,"pageVisibility":"visible","entityId":60393,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"0beee12c-12c5-44f3-b139-c89188bc6e5d","navigationType":0,"readyForUser":864.7000000476837,"redirectCount":0,"resourceLoadedEnd":786.9000000357628,"resourceLoadedStart":176.9000000357628,"resourceTiming":[{"duration":23.19999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":176.9000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":176.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":200.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":23.399999976158142,"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":177.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":177.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":200.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":83.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":177.30000001192093,"connectEnd":177.30000001192093,"connectStart":177.30000001192093,"domainLookupEnd":177.30000001192093,"domainLookupStart":177.30000001192093,"fetchStart":177.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":177.30000001192093,"responseEnd":261,"responseStart":261,"secureConnectionStart":177.30000001192093},{"duration":170,"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":177.5,"connectEnd":177.5,"connectStart":177.5,"domainLookupEnd":177.5,"domainLookupStart":177.5,"fetchStart":177.5,"redirectEnd":0,"redirectStart":0,"requestStart":177.5,"responseEnd":347.5,"responseStart":347.5,"secureConnectionStart":177.5},{"duration":173.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":177.80000001192093,"connectEnd":177.80000001192093,"connectStart":177.80000001192093,"domainLookupEnd":177.80000001192093,"domainLookupStart":177.80000001192093,"fetchStart":177.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":177.80000001192093,"responseEnd":351.5,"responseStart":351.5,"secureConnectionStart":177.80000001192093},{"duration":174.0999999642372,"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":177.9000000357628,"connectEnd":177.9000000357628,"connectStart":177.9000000357628,"domainLookupEnd":177.9000000357628,"domainLookupStart":177.9000000357628,"fetchStart":177.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":177.9000000357628,"responseEnd":352,"responseStart":352,"secureConnectionStart":177.9000000357628},{"duration":174.30000001192093,"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":178.10000002384186,"connectEnd":178.10000002384186,"connectStart":178.10000002384186,"domainLookupEnd":178.10000002384186,"domainLookupStart":178.10000002384186,"fetchStart":178.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":178.10000002384186,"responseEnd":352.4000000357628,"responseStart":352.4000000357628,"secureConnectionStart":178.10000002384186},{"duration":227.79999995231628,"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":178.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":406,"responseStart":0,"secureConnectionStart":0},{"duration":174.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":178.4000000357628,"connectEnd":178.4000000357628,"connectStart":178.4000000357628,"domainLookupEnd":178.4000000357628,"domainLookupStart":178.4000000357628,"fetchStart":178.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":178.4000000357628,"responseEnd":352.9000000357628,"responseStart":352.9000000357628,"secureConnectionStart":178.4000000357628},{"duration":227.60000002384186,"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":178.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":406.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":174.80000001192093,"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":178.60000002384186,"connectEnd":178.60000002384186,"connectStart":178.60000002384186,"domainLookupEnd":178.60000002384186,"domainLookupStart":178.60000002384186,"fetchStart":178.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":178.60000002384186,"responseEnd":353.4000000357628,"responseStart":353.4000000357628,"secureConnectionStart":178.60000002384186},{"duration":426.80000001192093,"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":179.4000000357628,"connectEnd":179.4000000357628,"connectStart":179.4000000357628,"domainLookupEnd":179.4000000357628,"domainLookupStart":179.4000000357628,"fetchStart":179.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":179.4000000357628,"responseEnd":606.2000000476837,"responseStart":606.2000000476837,"secureConnectionStart":179.4000000357628},{"duration":599.1000000238419,"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":179.5,"connectEnd":179.5,"connectStart":179.5,"domainLookupEnd":179.5,"domainLookupStart":179.5,"fetchStart":179.5,"redirectEnd":0,"redirectStart":0,"requestStart":179.5,"responseEnd":778.6000000238419,"responseStart":778.6000000238419,"secureConnectionStart":179.5},{"duration":189.20000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":417.5,"connectEnd":417.5,"connectStart":417.5,"domainLookupEnd":417.5,"domainLookupStart":417.5,"fetchStart":417.5,"redirectEnd":0,"redirectStart":0,"requestStart":417.5,"responseEnd":606.7000000476837,"responseStart":606.7000000476837,"secureConnectionStart":417.5},{"duration":97.80000001192093,"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":689.1000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":689.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":786.9000000357628,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":26,"responseStart":167,"responseEnd":171,"domLoading":174,"domInteractive":914,"domContentLoadedEventStart":914,"domContentLoadedEventEnd":955,"domComplete":1869,"loadEventStart":1869,"loadEventEnd":1871,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":896.1000000238419},{"name":"bigPipe.sidebar-id.end","time":897},{"name":"bigPipe.activity-panel-pipe-id.start","time":897.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":899.7000000476837},{"name":"activityTabFullyLoaded","time":965.4000000357628}],"measures":[],"correlationId":"702f3fff58e7b0","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":90,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}