Sprint:
10.2.4-1, 10.2.4-2, 10.2.6-1
MDEV-8931 implement a new capacity CLIENT_DEPRECATE_EOF that deprecate EOF packet.
Store procedure output parameter identification
When calling a store procedure with output parameters - using prepare statement - server send output parameter in a resultset if client has CLIENT_PS_MULTI_RESULTS capacity. Client must identify this resultset as an "output parameter resultset". This was actually done by a flag on the deleted EOF packet.
Example :
DELIMITER //
create procedure prepareStmtWithOutParameter (x int , INOUT y int )
BEGIN
SELECT 1;
end ;
//
DELIMITER ;
prepare test from "call prepareStmtWithOutParameter(?,?)" ;
set @param1=1;
set @param2=2;
execute test using @param1, @param2;
For this example, if client has CLIENT_PS_MULTI_RESULTS capacity, server will send 2 differents resultset :
first one corresponding to "SELECT 1; "
second result-set contain the INOUT integer parameter "y"
Before CLIENT_DEPRECATE_EOF capability, client can identify that resultset is an "output parameter resulset" with the EOF packet server status value.
Flag SERVER_PS_OUT_PARAM indicate that resultset is an "output param" resultset.
A resultset has 2 EOF packet. SERVER_PS_OUT_PARAM flag is set only on first EOF.
If CLIENT_DEPRECATE_EOF is set, first EOF is deleted, second has to have the SERVER_PS_OUT_PARAM flag.
{"report":{"fcp":1161.1000003814697,"ttfb":207.60000038146973,"pageVisibility":"visible","entityId":59748,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"eae90f56-7701-4291-8157-55087e11b4bb","navigationType":0,"readyForUser":1245,"redirectCount":0,"resourceLoadedEnd":1318.6999998092651,"resourceLoadedStart":213.10000038146973,"resourceTiming":[{"duration":444.5999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":213.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":213.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":657.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":444.69999980926514,"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":213.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":213.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":658.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":467.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":213.60000038146973,"connectEnd":213.60000038146973,"connectStart":213.60000038146973,"domainLookupEnd":213.60000038146973,"domainLookupStart":213.60000038146973,"fetchStart":213.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":213.60000038146973,"responseEnd":681.1000003814697,"responseStart":681.1000003814697,"secureConnectionStart":213.60000038146973},{"duration":556.6000003814697,"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":213.69999980926514,"connectEnd":213.69999980926514,"connectStart":213.69999980926514,"domainLookupEnd":213.69999980926514,"domainLookupStart":213.69999980926514,"fetchStart":213.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":213.69999980926514,"responseEnd":770.3000001907349,"responseStart":770.3000001907349,"secureConnectionStart":213.69999980926514},{"duration":560.3000001907349,"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":214,"connectEnd":214,"connectStart":214,"domainLookupEnd":214,"domainLookupStart":214,"fetchStart":214,"redirectEnd":0,"redirectStart":0,"requestStart":214,"responseEnd":774.3000001907349,"responseStart":774.3000001907349,"secureConnectionStart":214},{"duration":560.5999994277954,"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":214.10000038146973,"connectEnd":214.10000038146973,"connectStart":214.10000038146973,"domainLookupEnd":214.10000038146973,"domainLookupStart":214.10000038146973,"fetchStart":214.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":214.10000038146973,"responseEnd":774.6999998092651,"responseStart":774.6999998092651,"secureConnectionStart":214.10000038146973},{"duration":560.8000001907349,"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":214.30000019073486,"connectEnd":214.30000019073486,"connectStart":214.30000019073486,"domainLookupEnd":214.30000019073486,"domainLookupStart":214.30000019073486,"fetchStart":214.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":214.30000019073486,"responseEnd":775.1000003814697,"responseStart":775.1000003814697,"secureConnectionStart":214.30000019073486},{"duration":611.3000001907349,"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":214.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":214.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":825.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":561.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":214.60000038146973,"connectEnd":214.60000038146973,"connectStart":214.60000038146973,"domainLookupEnd":214.60000038146973,"domainLookupStart":214.60000038146973,"fetchStart":214.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":214.60000038146973,"responseEnd":775.6999998092651,"responseStart":775.6999998092651,"secureConnectionStart":214.60000038146973},{"duration":611,"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":214.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":214.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":825.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":561.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":215,"connectEnd":215,"connectStart":215,"domainLookupEnd":215,"domainLookupStart":215,"fetchStart":215,"redirectEnd":0,"redirectStart":0,"requestStart":215,"responseEnd":776.1000003814697,"responseStart":776.1000003814697,"secureConnectionStart":215},{"duration":829,"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":215.9000005722046,"connectEnd":215.9000005722046,"connectStart":215.9000005722046,"domainLookupEnd":215.9000005722046,"domainLookupStart":215.9000005722046,"fetchStart":215.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":215.9000005722046,"responseEnd":1044.9000005722046,"responseStart":1044.9000005722046,"secureConnectionStart":215.9000005722046},{"duration":1039.8000001907349,"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":216,"connectEnd":216,"connectStart":216,"domainLookupEnd":216,"domainLookupStart":216,"fetchStart":216,"redirectEnd":0,"redirectStart":0,"requestStart":216,"responseEnd":1255.8000001907349,"responseStart":1255.8000001907349,"secureConnectionStart":216},{"duration":211.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":837.1999998092651,"connectEnd":837.1999998092651,"connectStart":837.1999998092651,"domainLookupEnd":837.1999998092651,"domainLookupStart":837.1999998092651,"fetchStart":837.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":837.1999998092651,"responseEnd":1049,"responseStart":1049,"secureConnectionStart":837.1999998092651},{"duration":177.4000005722046,"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":1097.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1097.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1275.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":196.0999994277954,"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":1098.6000003814697,"connectEnd":1098.6000003814697,"connectStart":1098.6000003814697,"domainLookupEnd":1098.6000003814697,"domainLookupStart":1098.6000003814697,"fetchStart":1098.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1098.6000003814697,"responseEnd":1294.6999998092651,"responseStart":1294.6999998092651,"secureConnectionStart":1098.6000003814697},{"duration":219.5999994277954,"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":1099.1000003814697,"connectEnd":1099.1000003814697,"connectStart":1099.1000003814697,"domainLookupEnd":1099.1000003814697,"domainLookupStart":1099.1000003814697,"fetchStart":1099.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1099.1000003814697,"responseEnd":1318.6999998092651,"responseStart":1318.6999998092651,"secureConnectionStart":1099.1000003814697},{"duration":183.19999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1155,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1155,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1338.1999998092651,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":38,"responseStart":208,"responseEnd":209,"domLoading":211,"domInteractive":1339,"domContentLoadedEventStart":1339,"domContentLoadedEventEnd":1387,"domComplete":1679,"loadEventStart":1679,"loadEventEnd":1680,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1327},{"name":"bigPipe.sidebar-id.end","time":1327.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1327.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1328.6000003814697},{"name":"activityTabFullyLoaded","time":1404.1000003814697}],"measures":[],"correlationId":"56bb0296c30a52","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":99,"dbReadsTimeInMs":12,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Patch is attached (tested with the java connector).