Initial valgrind error from maria revno 3503: (release build)
Invalid read of size 8
|
at: Item_func_int_div::val_int (my_decimal.h:95)
|
by: Item::send (item.cc:6370)
|
by: Protocol::send_result_set_row (protocol.cc:900)
|
by: select_send::send_data (sql_class.cc:2448)
|
by: end_send (sql_select.cc:17355)
|
by: evaluate_join_record (sql_select.cc:16478)
|
by: sub_select (sql_select.cc:16259)
|
by: do_select (sql_select.cc:15929)
|
by: JOIN::exec_inner (sql_select.cc:2964)
|
by: JOIN::exec (sql_select.cc:2255)
|
by: mysql_select (sql_select.cc:3192)
|
by: handle_select (sql_select.cc:363)
|
by: execute_sqlcom_select (sql_parse.cc:5004)
|
by: mysql_execute_command (sql_parse.cc:2472)
|
by: mysql_parse (sql_parse.cc:6124)
|
by: dispatch_command (sql_parse.cc:1266)
|
by: do_handle_one_connection (sql_connect.cc:1267)
|
by: handle_one_connection (sql_connect.cc:1181)
|
by: start_thread (pthread_create.c:309)
|
by: clone (clone.S:115)
|
Address 0x0 is not stack'd, malloc'd or (recently) free'd
|
drop table if exists c;
|
create table c(a int) select null;
|
select 1 div convert(a using utf8) from c;
|
{"report":{"fcp":785.0999999940395,"ttfb":158.59999999403954,"pageVisibility":"visible","entityId":23242,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"aafaed28-28df-411e-88d2-49b8076b530a","navigationType":0,"readyForUser":852.9000000059605,"redirectCount":0,"resourceLoadedEnd":973.6999999880791,"resourceLoadedStart":166.40000000596046,"resourceTiming":[{"duration":9.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":166.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":175.90000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":9.599999994039536,"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":166.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":176.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":62.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":166.90000000596046,"connectEnd":166.90000000596046,"connectStart":166.90000000596046,"domainLookupEnd":166.90000000596046,"domainLookupStart":166.90000000596046,"fetchStart":166.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":166.90000000596046,"responseEnd":229.59999999403954,"responseStart":229.59999999403954,"secureConnectionStart":166.90000000596046},{"duration":319.89999997615814,"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":167.30000001192093,"connectEnd":167.30000001192093,"connectStart":167.30000001192093,"domainLookupEnd":167.30000001192093,"domainLookupStart":167.30000001192093,"fetchStart":167.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":167.30000001192093,"responseEnd":487.19999998807907,"responseStart":487.09999999403954,"secureConnectionStart":167.30000001192093},{"duration":323.09999999403954,"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":167.59999999403954,"connectEnd":167.59999999403954,"connectStart":167.59999999403954,"domainLookupEnd":167.59999999403954,"domainLookupStart":167.59999999403954,"fetchStart":167.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":167.59999999403954,"responseEnd":490.69999998807907,"responseStart":490.69999998807907,"secureConnectionStart":167.59999999403954},{"duration":323.39999997615814,"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":167.80000001192093,"connectEnd":167.80000001192093,"connectStart":167.80000001192093,"domainLookupEnd":167.80000001192093,"domainLookupStart":167.80000001192093,"fetchStart":167.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":167.80000001192093,"responseEnd":491.19999998807907,"responseStart":491.19999998807907,"secureConnectionStart":167.80000001192093},{"duration":323.69999998807907,"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":167.80000001192093,"connectEnd":167.80000001192093,"connectStart":167.80000001192093,"domainLookupEnd":167.80000001192093,"domainLookupStart":167.80000001192093,"fetchStart":167.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":167.80000001192093,"responseEnd":491.5,"responseStart":491.5,"secureConnectionStart":167.80000001192093},{"duration":324.40000000596046,"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":168,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":492.40000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":323.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":168.19999998807907,"connectEnd":168.19999998807907,"connectStart":168.19999998807907,"domainLookupEnd":168.19999998807907,"domainLookupStart":168.19999998807907,"fetchStart":168.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":168.19999998807907,"responseEnd":492,"responseStart":492,"secureConnectionStart":168.19999998807907},{"duration":324.19999998807907,"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":168.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":492.59999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":323.90000000596046,"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":168.5,"connectEnd":168.5,"connectStart":168.5,"domainLookupEnd":168.5,"domainLookupStart":168.5,"fetchStart":168.5,"redirectEnd":0,"redirectStart":0,"requestStart":168.5,"responseEnd":492.40000000596046,"responseStart":492.40000000596046,"secureConnectionStart":168.5},{"duration":566.9000000059605,"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":219.69999998807907,"connectEnd":219.69999998807907,"connectStart":219.69999998807907,"domainLookupEnd":219.69999998807907,"domainLookupStart":219.69999998807907,"fetchStart":219.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":219.69999998807907,"responseEnd":786.5999999940395,"responseStart":786.5999999940395,"secureConnectionStart":219.69999998807907},{"duration":544.6999999880791,"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":250.30000001192093,"connectEnd":250.30000001192093,"connectStart":250.30000001192093,"domainLookupEnd":250.30000001192093,"domainLookupStart":250.30000001192093,"fetchStart":250.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":250.30000001192093,"responseEnd":795,"responseStart":795,"secureConnectionStart":250.30000001192093},{"duration":414.2999999821186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":371.80000001192093,"connectEnd":371.80000001192093,"connectStart":371.80000001192093,"domainLookupEnd":371.80000001192093,"domainLookupStart":371.80000001192093,"fetchStart":371.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":371.80000001192093,"responseEnd":786.0999999940395,"responseStart":786.0999999940395,"secureConnectionStart":371.80000001192093},{"duration":192.2000000178814,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":779.0999999940395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":779.0999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":971.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":53.599999994039536,"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":920.0999999940395,"connectEnd":920.0999999940395,"connectStart":920.0999999940395,"domainLookupEnd":920.0999999940395,"domainLookupStart":920.0999999940395,"fetchStart":920.0999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":920.0999999940395,"responseEnd":973.6999999880791,"responseStart":973.6999999880791,"secureConnectionStart":920.0999999940395}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":159,"responseEnd":250,"domLoading":162,"domInteractive":1007,"domContentLoadedEventStart":1007,"domContentLoadedEventEnd":1044,"domComplete":1195,"loadEventStart":1195,"loadEventEnd":1195,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":980.4000000059605},{"name":"bigPipe.sidebar-id.end","time":981.1999999880791},{"name":"bigPipe.activity-panel-pipe-id.start","time":981.3000000119209},{"name":"bigPipe.activity-panel-pipe-id.end","time":982.5},{"name":"activityTabFullyLoaded","time":1056.5}],"measures":[],"correlationId":"f321f8e6a7e00a","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Also:
select convert(a using utf8) from c; returns null
select convert(a using utf8) + 0 from c; returns 0
Mysql returns null in both cases.