I could only reproduce it on 5.3, not sure whether it is fixed in higher versions or just masked.
CREATE TABLE t1 (i INT );
INSERT INTO t1 VALUES (1),(2);
SELECT 1 FROM t1 GROUP BY MONTHNAME(0) WITH ROLLUP ;
#3 <signal handler called>
#4 0x000000000059e102 in String::length (this=0x0) at sql_string.h:116
#5 0x0000000000692771 in sortcmp (s=0x7f8d9801ad98, t=0x0, cs=0x1217f00 <my_charset_latin1>) at sql_string.cc:758
#6 0x00000000005d147a in Cached_item_str::cmp (this=0x7f8d9801ad78) at item_buff.cc:88
#7 0x0000000000758d75 in test_if_group_changed (list=...) at sql_select.cc:20558
#8 0x000000000075110e in end_send_group (join=0x7f8d980197a8, join_tab=0x7f8d9801aab8, end_of_records=false) at sql_select.cc:17489
#9 0x000000000074e76e in evaluate_join_record (join=0x7f8d980197a8, join_tab=0x7f8d9801a798, error=0) at sql_select.cc:16469
#10 0x000000000074df85 in sub_select (join=0x7f8d980197a8, join_tab=0x7f8d9801a798, end_of_records=false) at sql_select.cc:16271
#11 0x000000000074d693 in do_select (join=0x7f8d980197a8, fields=0x7f8d98019b38, table=0x0, procedure=0x0) at sql_select.cc:15924
#12 0x000000000072cb6d in JOIN::exec (this=0x7f8d980197a8) at sql_select.cc:2788
#13 0x000000000072d406 in mysql_select (thd=0x31858d8, rref_pointer_array=0x31885c8, tables=0x7f8d98019100, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x0, group=0x7f8d980196b0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x7f8d98019788, unit=0x3187e68, select_lex=0x3188370) at sql_select.cc:3009
#14 0x0000000000723d9d in handle_select (thd=0x31858d8, lex=0x3187dc8, result=0x7f8d98019788, setup_tables_done_option=0) at sql_select.cc:288
#15 0x00000000006b381c in execute_sqlcom_select (thd=0x31858d8, all_tables=0x7f8d98019100) at sql_parse.cc:5172
#16 0x00000000006aabba in mysql_execute_command (thd=0x31858d8) at sql_parse.cc:2305
#17 0x00000000006b6124 in mysql_parse (thd=0x31858d8, rawbuf=0x7f8d98018f40 "SELECT 1 FROM t1 GROUP BY MONTHNAME(0) WITH ROLLUP", length=50, found_semicolon=0x7f8db0145d08) at sql_parse.cc:6173
#18 0x00000000006a83db in dispatch_command (command=COM_QUERY, thd=0x31858d8, packet=0x31ffbd9 "", packet_length=50) at sql_parse.cc:1243
#19 0x00000000006a76f7 in do_command (thd=0x31858d8) at sql_parse.cc:923
#20 0x00000000006a45cb in handle_one_connection (arg=0x31858d8) at sql_connect.cc:1231
#21 0x00007f8db1c730db in start_thread () from /lib64/libpthread.so.0
revision-id: sanja@askmonty.org-20131218135951-agw2htf09w418t91
revno: 3737
branch-nick: 5.3
made changes -
2014-01-04 13:18
Field
Original Value
New Value
Link
This issue relates to TODO-60
[ TODO-60
]
made changes -
2014-01-24 14:55
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
made changes -
2014-06-13 15:06
Workflow
defaullt
[ 32103
]
MariaDB v2
[ 42377
]
made changes -
2021-12-06 21:39
Workflow
MariaDB v3
[ 62099
]
MariaDB v4
[ 147390
]
{"report":{"fcp":871.3000000715256,"ttfb":198.40000009536743,"pageVisibility":"visible","entityId":28803,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"b1e86d5b-7a3f-4271-a1d6-98791dfc6e57","navigationType":0,"readyForUser":943.8000000715256,"redirectCount":0,"resourceLoadedEnd":1226.4000000953674,"resourceLoadedStart":204,"resourceTiming":[{"duration":201.20000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":204,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":405.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":201.29999995231628,"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":204.30000007152557,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":405.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":210.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":204.5,"connectEnd":204.5,"connectStart":204.5,"domainLookupEnd":204.5,"domainLookupStart":204.5,"fetchStart":204.5,"redirectEnd":0,"redirectStart":0,"requestStart":204.5,"responseEnd":414.7000000476837,"responseStart":414.7000000476837,"secureConnectionStart":204.5},{"duration":274,"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":204.60000002384186,"connectEnd":204.60000002384186,"connectStart":204.60000002384186,"domainLookupEnd":204.60000002384186,"domainLookupStart":204.60000002384186,"fetchStart":204.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":204.60000002384186,"responseEnd":478.60000002384186,"responseStart":478.60000002384186,"secureConnectionStart":204.60000002384186},{"duration":277.7000000476837,"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":205,"connectEnd":205,"connectStart":205,"domainLookupEnd":205,"domainLookupStart":205,"fetchStart":205,"redirectEnd":0,"redirectStart":0,"requestStart":205,"responseEnd":482.7000000476837,"responseStart":482.7000000476837,"secureConnectionStart":205},{"duration":278,"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":205.10000002384186,"connectEnd":205.10000002384186,"connectStart":205.10000002384186,"domainLookupEnd":205.10000002384186,"domainLookupStart":205.10000002384186,"fetchStart":205.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":205.10000002384186,"responseEnd":483.10000002384186,"responseStart":483.10000002384186,"secureConnectionStart":205.10000002384186},{"duration":278.6999999284744,"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":205.30000007152557,"connectEnd":205.30000007152557,"connectStart":205.30000007152557,"domainLookupEnd":205.30000007152557,"domainLookupStart":205.30000007152557,"fetchStart":205.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":205.30000007152557,"responseEnd":484,"responseStart":484,"secureConnectionStart":205.30000007152557},{"duration":351.5,"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":205.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":557,"responseStart":0,"secureConnectionStart":0},{"duration":279.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":205.60000002384186,"connectEnd":205.60000002384186,"connectStart":205.60000002384186,"domainLookupEnd":205.60000002384186,"domainLookupStart":205.60000002384186,"fetchStart":205.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":205.60000002384186,"responseEnd":485.10000002384186,"responseStart":485.10000002384186,"secureConnectionStart":205.60000002384186},{"duration":351.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":205.80000007152557,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":557.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":280.2000000476837,"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":206,"connectEnd":206,"connectStart":206,"domainLookupEnd":206,"domainLookupStart":206,"fetchStart":206,"redirectEnd":0,"redirectStart":0,"requestStart":206,"responseEnd":486.2000000476837,"responseStart":486.2000000476837,"secureConnectionStart":206},{"duration":462.60000002384186,"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":211.10000002384186,"connectEnd":211.10000002384186,"connectStart":211.10000002384186,"domainLookupEnd":211.10000002384186,"domainLookupStart":211.10000002384186,"fetchStart":211.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":211.10000002384186,"responseEnd":673.7000000476837,"responseStart":673.7000000476837,"secureConnectionStart":211.10000002384186},{"duration":998.2999999523163,"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":211.20000004768372,"connectEnd":211.20000004768372,"connectStart":211.20000004768372,"domainLookupEnd":211.20000004768372,"domainLookupStart":211.20000004768372,"fetchStart":211.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":211.20000004768372,"responseEnd":1209.5,"responseStart":1209.5,"secureConnectionStart":211.20000004768372},{"duration":141.20000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":583.5,"connectEnd":583.5,"connectStart":583.5,"domainLookupEnd":583.5,"domainLookupStart":583.5,"fetchStart":583.5,"redirectEnd":0,"redirectStart":0,"requestStart":583.5,"responseEnd":724.7000000476837,"responseStart":724.7000000476837,"secureConnectionStart":583.5},{"duration":399.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2bu7/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":826.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":826.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1226.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":399.3000000715256,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":827.1000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":827.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1226.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":389.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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":827.8000000715256,"connectEnd":827.8000000715256,"connectStart":827.8000000715256,"domainLookupEnd":827.8000000715256,"domainLookupStart":827.8000000715256,"fetchStart":827.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":827.8000000715256,"responseEnd":1217.4000000953674,"responseStart":1217.4000000953674,"secureConnectionStart":827.8000000715256},{"duration":390.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/86ee9bbc76cd1bcd8556fcdcf46241c9-CDN/lu2bu7/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":828.2000000476837,"connectEnd":828.2000000476837,"connectStart":828.2000000476837,"domainLookupEnd":828.2000000476837,"domainLookupStart":828.2000000476837,"fetchStart":828.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":828.2000000476837,"responseEnd":1218.5,"responseStart":1218.5,"secureConnectionStart":828.2000000476837},{"duration":368.1999999284744,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":864.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":864.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1233,"responseStart":0,"secureConnectionStart":0},{"duration":395.8000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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":828.6000000238419,"connectEnd":828.6000000238419,"connectStart":828.6000000238419,"domainLookupEnd":828.6000000238419,"domainLookupStart":828.6000000238419,"fetchStart":828.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":828.6000000238419,"responseEnd":1224.4000000953674,"responseStart":1224.4000000953674,"secureConnectionStart":828.6000000238419}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":21,"responseStart":198,"responseEnd":205,"domLoading":202,"domInteractive":1236,"domContentLoadedEventStart":1236,"domContentLoadedEventEnd":1276,"domComplete":1537,"loadEventStart":1537,"loadEventEnd":1538,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1211.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1212.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":1212.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1214.4000000953674},{"name":"activityTabFullyLoaded","time":1294.1000000238419}],"measures":[],"correlationId":"f27745a5eee9d6","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":116,"dbReadsTimeInMs":18,"dbConnsTimeInMs":27,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
The crash happens because Item_func_monthname::is_null() does not work correctly,
because Item_func_monthname is erroneously derived from Item_func_month.
In MariaDB-5.5 Item_func_monthname was fixed to derive from Item_str_func,
which fixed this problem. Backporting of this change from 5.5 to 5.3 should
fix the problem in 5.3 as well.