PREPARE s FROM "ALTER TABLE t modify b TEXT CHARACTER SET utf8 DEFAULT '' ";
|
SET @@character_set_collations='';
|
EXECUTE s;
|
Leads to:
|
11.2.0 e81fa345020ec6a067583db6a7019d6404b26f93 (Optimized)
|
Core was generated by `/test/MD270723-mariadb-11.2.0-linux-x86_64-opt/bin/mariadbd --no-defaults --cor'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 Reprepare_observer::report_error (this=0x0, thd=<optimized out>)
|
at /test/11.2_opt/sql/sql_prepare.cc:3808
|
[Current thread is 1 (Thread 0x14f500088700 (LWP 3371857))]
|
(gdb) bt
|
#0 Reprepare_observer::report_error (this=0x0, thd=<optimized out>) at /test/11.2_opt/sql/sql_prepare.cc:3808
|
#1 0x0000560e602cf83b in Prepared_statement::check_charset_collation_map_version (this=0x14f4a4016948, this=0x14f4a4016948, observer=<optimized out>, thd=<optimized out>) at /test/11.2_opt/sql/sql_prepare.cc:238
|
#2 Prepared_statement::execute (this=0x14f4a4016948, expanded_query=0x14f500086e00, open_cursor=false) at /test/11.2_opt/sql/sql_prepare.cc:4898
|
#3 0x0000560e602cfb65 in Prepared_statement::execute_loop (this=this@entry=0x14f4a4016948, expanded_query=expanded_query@entry=0x14f500086e00, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/11.2_opt/sql/sql_prepare.cc:4433
|
#4 0x0000560e602cfe7b in mysql_sql_stmt_execute (thd=thd@entry=0x14f4a4000c58) at /test/11.2_opt/sql/sql_prepare.cc:3470
|
#5 0x0000560e602af911 in mysql_execute_command (thd=0x14f4a4000c58, is_called_from_prepared_stmt=<optimized out>) at /test/11.2_opt/sql/sql_parse.cc:3960
|
#6 0x0000560e6029e1e5 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x14f4a4000c58) at /test/11.2_opt/sql/sql_parse.cc:7800
|
#7 mysql_parse (thd=0x14f4a4000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/11.2_opt/sql/sql_parse.cc:7722
|
#8 0x0000560e602aa092 in dispatch_command (command=COM_QUERY, thd=0x14f4a4000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/11.2_opt/sql/sql_class.h:1374
|
#9 0x0000560e602abf7e in do_command (thd=0x14f4a4000c58, blocking=blocking@entry=true) at /test/11.2_opt/sql/sql_parse.cc:1405
|
#10 0x0000560e603cb6cf in do_handle_one_connection (connect=<optimized out>, connect@entry=0x560e628f4b78, put_in_cache=put_in_cache@entry=true) at /test/11.2_opt/sql/sql_connect.cc:1445
|
#11 0x0000560e603cb9bd in handle_one_connection (arg=0x560e628f4b78) at /test/11.2_opt/sql/sql_connect.cc:1347
|
#12 0x000014f519530609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#13 0x000014f51911c133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 11.2.0 (dbg), 11.2.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.31 (dbg), 10.4.31 (opt), 10.5.22 (dbg), 10.5.22 (opt), 10.6.15 (dbg), 10.6.15 (opt), 10.9.8 (dbg), 10.9.8 (opt), 10.10.6 (dbg), 10.10.6 (opt), 10.11.5 (dbg), 10.11.5 (opt), 11.0.2 (dbg), 11.0.3 (dbg), 11.0.3 (opt), 11.1.2 (dbg), 11.1.2 (opt)
{"report":{"fcp":744.8999999761581,"ttfb":205.59999990463257,"pageVisibility":"visible","entityId":123920,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"33aff688-131f-4fa4-89a2-a3cd5277ed1e","navigationType":0,"readyForUser":802.3999999761581,"redirectCount":0,"resourceLoadedEnd":582.3999999761581,"resourceLoadedStart":210.79999995231628,"resourceTiming":[{"duration":31,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":210.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":210.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":241.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":31.600000023841858,"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":211.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":211.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":242.69999992847443,"responseStart":0,"secureConnectionStart":0},{"duration":99.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":211.19999992847443,"connectEnd":211.19999992847443,"connectStart":211.19999992847443,"domainLookupEnd":211.19999992847443,"domainLookupStart":211.19999992847443,"fetchStart":211.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":246.19999992847443,"responseEnd":310.59999990463257,"responseStart":263.7999999523163,"secureConnectionStart":211.19999992847443},{"duration":57.39999997615814,"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":211.39999997615814,"connectEnd":211.39999997615814,"connectStart":211.39999997615814,"domainLookupEnd":211.39999997615814,"domainLookupStart":211.39999997615814,"fetchStart":211.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":247.19999992847443,"responseEnd":268.7999999523163,"responseStart":268.1999999284744,"secureConnectionStart":211.39999997615814},{"duration":108.79999995231628,"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":211.39999997615814,"connectEnd":211.39999997615814,"connectStart":211.39999997615814,"domainLookupEnd":211.39999997615814,"domainLookupStart":211.39999997615814,"fetchStart":211.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":246.69999992847443,"responseEnd":320.1999999284744,"responseStart":264.5,"secureConnectionStart":211.39999997615814},{"duration":62.699999928474426,"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":211.5,"connectEnd":211.5,"connectStart":211.5,"domainLookupEnd":211.5,"domainLookupStart":211.5,"fetchStart":211.5,"redirectEnd":0,"redirectStart":0,"requestStart":250.19999992847443,"responseEnd":274.1999999284744,"responseStart":273.5,"secureConnectionStart":211.5},{"duration":38.40000009536743,"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":211.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":211.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":250,"responseStart":0,"secureConnectionStart":0},{"duration":61.800000071525574,"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":211.59999990463257,"connectEnd":211.59999990463257,"connectStart":211.59999990463257,"domainLookupEnd":211.59999990463257,"domainLookupStart":211.59999990463257,"fetchStart":211.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":250.29999995231628,"responseEnd":273.39999997615814,"responseStart":272.59999990463257,"secureConnectionStart":211.59999990463257},{"duration":69.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":211.79999995231628,"connectEnd":211.79999995231628,"connectStart":211.79999995231628,"domainLookupEnd":211.79999995231628,"domainLookupStart":211.79999995231628,"fetchStart":211.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":252,"responseEnd":281.1999999284744,"responseStart":278.5,"secureConnectionStart":211.79999995231628},{"duration":39.39999997615814,"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":211.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":211.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":251.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":66.39999997615814,"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":212,"connectEnd":212,"connectStart":212,"domainLookupEnd":212,"domainLookupStart":212,"fetchStart":212,"redirectEnd":0,"redirectStart":0,"requestStart":253.39999997615814,"responseEnd":278.39999997615814,"responseStart":277.6999999284744,"secureConnectionStart":212},{"duration":359.89999997615814,"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":221.69999992847443,"connectEnd":221.69999992847443,"connectStart":221.69999992847443,"domainLookupEnd":221.69999992847443,"domainLookupStart":221.69999992847443,"fetchStart":221.69999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":292.09999990463257,"responseEnd":581.5999999046326,"responseStart":574.2999999523163,"secureConnectionStart":221.69999992847443},{"duration":360.5,"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":221.89999997615814,"connectEnd":221.89999997615814,"connectStart":221.89999997615814,"domainLookupEnd":221.89999997615814,"domainLookupStart":221.89999997615814,"fetchStart":221.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":311.59999990463257,"responseEnd":582.3999999761581,"responseStart":576.3999999761581,"secureConnectionStart":221.89999997615814},{"duration":175.89999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":515.7999999523163,"connectEnd":515.7999999523163,"connectStart":515.7999999523163,"domainLookupEnd":515.7999999523163,"domainLookupStart":515.7999999523163,"fetchStart":515.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":658.5999999046326,"responseEnd":691.6999999284744,"responseStart":690.7999999523163,"secureConnectionStart":515.7999999523163},{"duration":93,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":720,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":720,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":813,"responseStart":0,"secureConnectionStart":0},{"duration":155,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":738.3999999761581,"connectEnd":738.3999999761581,"connectStart":738.3999999761581,"domainLookupEnd":738.3999999761581,"domainLookupStart":738.3999999761581,"fetchStart":738.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":861.1999999284744,"responseEnd":893.3999999761581,"responseStart":892.6999999284744,"secureConnectionStart":738.3999999761581}],"fetchStart":0,"domainLookupStart":18,"domainLookupEnd":24,"connectStart":24,"connectEnd":42,"secureConnectionStart":32,"requestStart":42,"responseStart":205,"responseEnd":221,"domLoading":209,"domInteractive":851,"domContentLoadedEventStart":851,"domContentLoadedEventEnd":883,"domComplete":1218,"loadEventStart":1218,"loadEventEnd":1218,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":835.5},{"name":"bigPipe.sidebar-id.end","time":836.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":836.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":837.2999999523163},{"name":"activityTabFullyLoaded","time":897.5999999046326}],"measures":[],"correlationId":"b6ccf63cd04f4f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":89,"dbReadsTimeInMs":10,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
11.3.0 fa64a7a10cb23475c3008ff3d935d12659d2a81f (Optimized, UBASAN)
/test/mtest/MDEV-31606/11.3_opt_san/sql/sql_prepare.cc:238:29: runtime error: member call on null pointer of type 'struct Reprepare_observer'#0 0x5609a6886a39 in Prepared_statement::check_charset_collation_map_version(THD*, Reprepare_observer*) /test/mtest/MDEV-31606/11.3_opt_san/sql/sql_prepare.cc:238