Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.5 , 10.6 , 10.11 , 11.4 , 11.8 , 12.0
Environment:
clang-20.1 or clang-18.1
10.6.22 main.index_intersect_innodb
CURRENT_TEST: main.index_intersect_innodb
/source/sql/sql_lifo_buffer.h:177:17: runtime error: applying non-zero offset 12 to null pointer
#0 0x55b8b4b88c1b in Forward_lifo_buffer::have_space_for(unsigned long) /source/sql/sql_lifo_buffer.h:177:17
#1 0x55b8b4b80797 in DsMrr_impl::dsmrr_init(handler*, st_range_seq_if*, void*, unsigned int, unsigned int, st_handler_buffer*) /source/sql/multi_range_read
.cc:1200:25
#2 0x55b8b5d5ae89 in ha_innobase::multi_range_read_init(st_range_seq_if*, void*, unsigned int, unsigned int, st_handler_buffer*) /source/storage/innobase/h
andler/ha_innodb.cc:20149:18
#3 0x55b8b57374e0 in QUICK_RANGE_SELECT::reset() /source/sql/opt_range.cc:12841:16
#4 0x55b8b572eff3 in read_keys_and_merge_scans(THD*, TABLE*, List<QUICK_RANGE_SELECT>, QUICK_RANGE_SELECT*, READ_RECORD*, bool, Bitmap<64u>*, Unique**) /so
urce/sql/opt_range.cc:12395:39
#5 0x55b8b573183f in QUICK_INDEX_INTERSECT_SELECT::read_keys_and_merge() /source/sql/opt_range.cc:12539:11
#6 0x55b8b4659d2d in join_init_read_record(st_join_table*) /source/sql/sql_select.cc:23390:64
#7 0x55b8b45e6cf6 in sub_select(JOIN*, st_join_table*, bool) /source/sql/sql_select.cc:22388:12
#8 0x55b8b4664752 in do_select(JOIN*, Procedure*) /source/sql/sql_select.cc:21914:14
#9 0x55b8b46623b4 in JOIN::exec_inner() /source/sql/sql_select.cc:4939:50
#10 0x55b8b465f2eb in JOIN::exec() /source/sql/sql_select.cc:4717:3
#11 0x55b8b45e9f34 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_
result*, st_select_lex_unit*, st_select_lex*) /source/sql/sql_select.cc:5196:9
#12 0x55b8b45e9183 in handle_select(THD*, LEX*, select_result*, unsigned long) /source/sql/sql_select.cc:573:10
#13 0x55b8b453598c in execute_sqlcom_select(THD*, TABLE_LIST*) /source/sql/sql_parse.cc:6422:12
#14 0x55b8b45160c1 in mysql_execute_command(THD*, bool) /source/sql/sql_parse.cc:4013:12
#15 0x55b8b44fbab6 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /source/sql/sql_parse.cc:8209:18
#16 0x55b8b44f3d5b in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /source/sql/sql_parse.cc:1908:7
#17 0x55b8b44fda1b in do_command(THD*, bool) /source/sql/sql_parse.cc:1421:17
#18 0x55b8b4a7d94c in do_handle_one_connection(CONNECT*, bool) /source/sql/sql_connect.cc:1386:11
#19 0x55b8b4a7d2d2 in handle_one_connection /source/sql/sql_connect.cc:1298:5
#20 0x55b8b40b1476 in asan_thread_start(void*) asan_interceptors.cpp.o
#21 0x7ff458d351c3 (/lib/x86_64-linux-gnu/libc.so.6+0x891c3) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8)
#22 0x7ff458db585b (/lib/x86_64-linux-gnu/libc.so.6+0x10985b) (BuildId: c047672cae7964324658491e7dee26748ae5d2f8)
SUMMARY: UndefinedBehaviorSanitizer: undefined-behavior /source/sql/sql_lifo_buffer.h:177:17
{"report":{"fcp":812.4000000059605,"ttfb":219.30000001192093,"pageVisibility":"visible","entityId":133420,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"da27e398-201c-414b-a045-5ff9640ab3ac","navigationType":0,"readyForUser":891,"redirectCount":0,"resourceLoadedEnd":956,"resourceLoadedStart":224.70000000298023,"resourceTiming":[{"duration":15.299999997019768,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":224.70000000298023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":240,"responseStart":0,"secureConnectionStart":0},{"duration":15.200000002980232,"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":225.1000000089407,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":225.1000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":240.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":66.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":225.20000000298023,"connectEnd":225.20000000298023,"connectStart":225.20000000298023,"domainLookupEnd":225.20000000298023,"domainLookupStart":225.20000000298023,"fetchStart":225.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":225.20000000298023,"responseEnd":291.70000000298023,"responseStart":291.70000000298023,"secureConnectionStart":225.20000000298023},{"duration":126,"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":225.6000000089407,"connectEnd":225.6000000089407,"connectStart":225.6000000089407,"domainLookupEnd":225.6000000089407,"domainLookupStart":225.6000000089407,"fetchStart":225.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":225.6000000089407,"responseEnd":351.6000000089407,"responseStart":351.6000000089407,"secureConnectionStart":225.6000000089407},{"duration":129.59999999403954,"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":225.80000001192093,"connectEnd":225.80000001192093,"connectStart":225.80000001192093,"domainLookupEnd":225.80000001192093,"domainLookupStart":225.80000001192093,"fetchStart":225.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":225.80000001192093,"responseEnd":355.40000000596046,"responseStart":355.40000000596046,"secureConnectionStart":225.80000001192093},{"duration":130.09999999403954,"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":225.90000000596046,"connectEnd":225.90000000596046,"connectStart":225.90000000596046,"domainLookupEnd":225.90000000596046,"domainLookupStart":225.90000000596046,"fetchStart":225.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":225.90000000596046,"responseEnd":356,"responseStart":356,"secureConnectionStart":225.90000000596046},{"duration":130.3999999910593,"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":226.1000000089407,"connectEnd":226.1000000089407,"connectStart":226.1000000089407,"domainLookupEnd":226.1000000089407,"domainLookupStart":226.1000000089407,"fetchStart":226.1000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":226.1000000089407,"responseEnd":356.5,"responseStart":356.5,"secureConnectionStart":226.1000000089407},{"duration":211.09999999403954,"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":226.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":226.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":437.5,"responseStart":0,"secureConnectionStart":0},{"duration":130.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":226.6000000089407,"connectEnd":226.6000000089407,"connectStart":226.6000000089407,"domainLookupEnd":226.6000000089407,"domainLookupStart":226.6000000089407,"fetchStart":226.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":226.6000000089407,"responseEnd":357.1000000089407,"responseStart":357.1000000089407,"secureConnectionStart":226.6000000089407},{"duration":210.79999999701977,"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":226.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":226.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":437.6000000089407,"responseStart":0,"secureConnectionStart":0},{"duration":131,"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":226.80000001192093,"connectEnd":226.80000001192093,"connectStart":226.80000001192093,"domainLookupEnd":226.80000001192093,"domainLookupStart":226.80000001192093,"fetchStart":226.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":226.80000001192093,"responseEnd":357.80000001192093,"responseStart":357.80000001192093,"secureConnectionStart":226.80000001192093},{"duration":722,"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":232.6000000089407,"connectEnd":232.6000000089407,"connectStart":232.6000000089407,"domainLookupEnd":232.6000000089407,"domainLookupStart":232.6000000089407,"fetchStart":232.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":232.6000000089407,"responseEnd":954.6000000089407,"responseStart":954.6000000089407,"secureConnectionStart":232.6000000089407},{"duration":723.3999999910593,"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":232.6000000089407,"connectEnd":232.6000000089407,"connectStart":232.6000000089407,"domainLookupEnd":232.6000000089407,"domainLookupStart":232.6000000089407,"fetchStart":232.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":232.6000000089407,"responseEnd":956,"responseStart":956,"secureConnectionStart":232.6000000089407},{"duration":93.1000000089407,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":449.20000000298023,"connectEnd":449.20000000298023,"connectStart":449.20000000298023,"domainLookupEnd":449.20000000298023,"domainLookupStart":449.20000000298023,"fetchStart":449.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":449.20000000298023,"responseEnd":542.3000000119209,"responseStart":542.3000000119209,"secureConnectionStart":449.20000000298023}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":41,"responseStart":219,"responseEnd":227,"domLoading":222,"domInteractive":983,"domContentLoadedEventStart":983,"domContentLoadedEventEnd":1028,"domComplete":1582,"loadEventStart":1583,"loadEventEnd":1583,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":958.8000000119209},{"name":"bigPipe.sidebar-id.end","time":959.6000000089407},{"name":"bigPipe.activity-panel-pipe-id.start","time":959.8000000119209},{"name":"bigPipe.activity-panel-pipe-id.end","time":962.1000000089407},{"name":"activityTabFullyLoaded","time":1042.7000000029802}],"measures":[],"correlationId":"5425106b7bb094","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":113,"dbReadsTimeInMs":15,"dbConnsTimeInMs":25,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Looks like pos is undefined, but because set_buffer_space defined/start/end. it looks like the follow may be needed:
diff --git a/sql/multi_range_read.cc b/sql/multi_range_read.cc
index 6e8c4fd35df..174aa503f5a 100644
--- a/sql/multi_range_read.cc
+++ b/sql/multi_range_read.cc
@@ -1197,6 +1197,7 @@ int DsMrr_impl::dsmrr_init(handler *h_arg, RANGE_SEQ_IF *seq_funcs,
{
/* index strategy doesn't need buffer, give all space to rowids*/
rowid_buffer.set_buffer_space(full_buf, full_buf_end);
+ rowid_buffer.reset();
if (!rowid_buffer.have_space_for(primary_file->ref_length +
(int)is_mrr_assoc * sizeof(range_id_t)))
goto use_default_impl;