Some shadowed field return alias name in place of column name. (This is only since 10.4)
Connector then return an exception when using column name to retrieve data.
To reproduced :
|
try (Connection con = DriverManager.getConnection("jdbc:mariadb://localhost:3306/testj?user=root&log")) {
|
Statement stmt = con.createStatement();
|
stmt.execute("CREATE TABLE IF NOT EXISTS foo_outer (original_id varchar(100), key_p2 DATETIME, some_value text, PRIMARY KEY (original_id, key_p2))");
|
stmt.execute("INSERT IGNORE INTO foo_outer (original_id, key_p2, some_value) VALUES ('oid_a', '2020-06-01 00:00', 'some_value_a')");
|
stmt.execute("CREATE TABLE IF NOT EXISTS foo_inner (original_id varchar(100), other_id varchar(100), PRIMARY KEY (original_id, other_id))");
|
stmt.execute("INSERT IGNORE INTO foo_inner (original_id, other_id) VALUES ('oid_a', 'otherid_1')");
|
stmt.execute("INSERT IGNORE INTO foo_inner (original_id, other_id) VALUES ('oid_b', 'otherid_1')");
|
|
ResultSet r = stmt.executeQuery("SELECT original_id AS alt_id, key_p2 as p2, some_value "
|
+ "FROM foo_outer "
|
+ "WHERE original_id IN ("
|
+ "SELECT DISTINCT(inner1.original_id) "
|
+ "FROM foo_inner AS inner1 "
|
+ "RIGHT JOIN foo_inner AS inner2 ON inner1.other_id = inner2.other_id "
|
+ "WHERE inner1.original_id = 'oid_a'"
|
+ ") ORDER BY key_p2");
|
while (r.next()) {
|
// will throw an error, since column name meta return alt_id
|
ResultSetMetaData meta = r.getMetaData();
|
System.out.println(meta.getColumnLabel(1)); // return alt_id, as expected
|
System.out.println(meta.getColumnName(1)); // return alt_id, not original_id
|
|
r.getString("original_id"); // will throw an exception
|
}
|
} catch (Exception ex) {
|
ex.printStackTrace();
|
}
|
same code without order by work without issue.
metadata is wrong :
+--------------------------------------------------+
|
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
|
+--------------------------------------------------+------------------+
|
| 39 00 00 02 03 64 65 66 05 74 65 73 74 6A 09 66 | 9....def.testj.f |
|
| 6F 6F 5F 6F 75 74 65 72 09 66 6F 6F 5F 6F 75 74 | oo_outer.foo_out |
|
| 65 72 06 61 6C 74 5F 69 64 06 61 6C 74 5F 69 64 | er.alt_id.alt_id |
|
| 0C E0 00 90 01 00 00 FD 01 10 00 00 00 | ............. |
|
+--------------------------------------------------+------------------+
|
with 10.3, no problem, original_id is returned as column name :
+--------------------------------------------------+
|
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
|
+--------------------------------------------------+------------------+
|
| 3E 00 00 02 03 64 65 66 05 74 65 73 74 6A 09 66 | >....def.testj.f |
|
| 6F 6F 5F 6F 75 74 65 72 09 66 6F 6F 5F 6F 75 74 | oo_outer.foo_out |
|
| 65 72 06 61 6C 74 5F 69 64 0B 6F 72 69 67 69 6E | er.alt_id.origin |
|
| 61 6C 5F 69 64 0C 2D 00 90 01 00 00 FD 01 10 00 | al_id.-......... |
|
| 00 00 | .. |
|
+--------------------------------------------------+------------------+
|
|
{"report":{"fcp":1743.5,"ttfb":393,"pageVisibility":"visible","entityId":90100,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"922c07aa-8669-4453-a1f7-15b06e2bd9ad","navigationType":0,"readyForUser":1973.2000000476837,"redirectCount":0,"resourceLoadedEnd":1344.2000000476837,"resourceLoadedStart":409.2000000476837,"resourceTiming":[{"duration":30.600000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":409.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":409.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":439.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":31,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":409.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":409.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":440.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":732.8999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":409.8000000715256,"connectEnd":409.8000000715256,"connectStart":409.8000000715256,"domainLookupEnd":409.8000000715256,"domainLookupStart":409.8000000715256,"fetchStart":409.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":643.6000000238419,"responseEnd":1142.7000000476837,"responseStart":703,"secureConnectionStart":409.8000000715256},{"duration":933.6000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":410.60000002384186,"connectEnd":410.60000002384186,"connectStart":410.60000002384186,"domainLookupEnd":410.60000002384186,"domainLookupStart":410.60000002384186,"fetchStart":410.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":643.6000000238419,"responseEnd":1344.2000000476837,"responseStart":707.3000000715256,"secureConnectionStart":410.60000002384186},{"duration":517.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":410.8000000715256,"connectEnd":703.3999999761581,"connectStart":703.3999999761581,"domainLookupEnd":703.3999999761581,"domainLookupStart":703.3999999761581,"fetchStart":410.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":797,"responseEnd":928.2000000476837,"responseStart":859.3000000715256,"secureConnectionStart":703.3999999761581},{"duration":517.6000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":410.89999997615814,"connectEnd":410.89999997615814,"connectStart":410.89999997615814,"domainLookupEnd":410.89999997615814,"domainLookupStart":410.89999997615814,"fetchStart":410.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":797.8000000715256,"responseEnd":928.5,"responseStart":927,"secureConnectionStart":410.89999997615814},{"duration":291.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":411,"connectEnd":411,"connectStart":411,"domainLookupEnd":411,"domainLookupStart":411,"fetchStart":411,"redirectEnd":0,"redirectStart":0,"requestStart":643.2000000476837,"responseEnd":702.8999999761581,"responseStart":659.7000000476837,"secureConnectionStart":411},{"duration":47.199999928474426,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":411.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":411.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":459,"responseStart":0,"secureConnectionStart":0},{"duration":446.3000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":411.89999997615814,"connectEnd":411.89999997615814,"connectStart":411.89999997615814,"domainLookupEnd":411.89999997615814,"domainLookupStart":411.89999997615814,"fetchStart":411.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":643.8999999761581,"responseEnd":858.2000000476837,"responseStart":798,"secureConnectionStart":411.89999997615814},{"duration":47.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":412.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":412.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":459.5,"responseStart":0,"secureConnectionStart":0},{"duration":516.1000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":412.2000000476837,"connectEnd":412.2000000476837,"connectStart":412.2000000476837,"domainLookupEnd":412.2000000476837,"domainLookupStart":412.2000000476837,"fetchStart":412.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":797.7000000476837,"responseEnd":928.3000000715256,"responseStart":924.8999999761581,"secureConnectionStart":412.2000000476837},{"duration":556.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":420,"connectEnd":420,"connectStart":420,"domainLookupEnd":420,"domainLookupStart":420,"fetchStart":420,"redirectEnd":0,"redirectStart":0,"requestStart":643.8999999761581,"responseEnd":976.5,"responseStart":948.3000000715256,"secureConnectionStart":420},{"duration":493.10000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":435.5,"connectEnd":435.5,"connectStart":435.5,"domainLookupEnd":435.5,"domainLookupStart":435.5,"fetchStart":435.5,"redirectEnd":0,"redirectStart":0,"requestStart":797.3999999761581,"responseEnd":928.6000000238419,"responseStart":927.5,"secureConnectionStart":435.5},{"duration":132.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1297.3000000715256,"connectEnd":1297.3000000715256,"connectStart":1297.3000000715256,"domainLookupEnd":1297.3000000715256,"domainLookupStart":1297.3000000715256,"fetchStart":1297.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":1376,"responseEnd":1429.8999999761581,"responseStart":1408.1000000238419,"secureConnectionStart":1297.3000000715256},{"duration":234,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1648.2000000476837,"connectEnd":1648.2000000476837,"connectStart":1648.2000000476837,"domainLookupEnd":1648.2000000476837,"domainLookupStart":1648.2000000476837,"fetchStart":1648.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1850.8999999761581,"responseEnd":1882.2000000476837,"responseStart":1881.6000000238419,"secureConnectionStart":1648.2000000476837},{"duration":541.7999999523163,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1725.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1725.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2267.600000023842,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":105,"domainLookupEnd":176,"connectStart":176,"connectEnd":210,"secureConnectionStart":186,"requestStart":210,"responseStart":393,"responseEnd":433,"domLoading":401,"domInteractive":2269,"domContentLoadedEventStart":2269,"domContentLoadedEventEnd":2329,"domComplete":3063,"loadEventStart":3063,"loadEventEnd":3064,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2235.7000000476837},{"name":"bigPipe.sidebar-id.end","time":2236.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":2236.600000023842},{"name":"bigPipe.activity-panel-pipe-id.end","time":2240.5},{"name":"activityTabFullyLoaded","time":2386.3000000715256}],"measures":[],"correlationId":"a467b7b7eb844c","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":108,"dbReadsTimeInMs":15,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Shouls it be problem for CC? (atually I can make test case with it). I will check at once...