Type:
Bug
Priority:
Major
Resolution:
Duplicate
Affects Version/s:
10.9.0 , 10.2(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL)
Environment:
Linux jie-2 5.4.143-1-pve #1 SMP PVE 5.4.143-1 (Tue, 28 Sep 2021 09:10:37 +0200) x86_64 x86_64 x86_64 GNU/Linux
PoC:
UNLOCK TABLES; COMMIT; DROP DATABASE IF EXISTS walktreedatabase3424886; CREATE DATABASE IF NOT EXISTS walktreedatabase3424886; USE walktreedatabase3424886;;
CREATE TABLE v0 ( v1 INT UNIQUE UNIQUE UNIQUE PRIMARY KEY ) ;
SET GLOBAL READ_ONLY = TRUE ;
INSERT v0 ( ) VALUES ( 85075355.000000 ) , ( 52251370.000000 ) ;
CREATE TABLE v2 ( v3 BIGINT ( 43 ) ) ENGINE = MEMORY ;
INSERT IGNORE v2 SET v3 = DEFAULT ;
ALTER TABLE v0 ADD ( v4 INT AS ( ( TIME ( CASE DAYNAME ( 'x' ) WHEN 'x' THEN RIGHT ( + '' , 78 ) END ) ) ) VIRTUAL ) ;
UPDATE v0 MEMORY SET v1 = v1 ;
SELECT * FROM v0 WHERE v1 LIKE 'x' ORDER BY COALESCE ( 'x' ) ;
report (compiled with ASAN):
Thread pointer: 0x62b00015e218
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f8171428880 thread_stack 0x5fc00
??:0(__interceptor_backtrace)[0x7cbadb]
mysys/stacktrace.c:212(my_print_stacktrace)[0x2a86d37]
sql/signal_handler.cc:0(handle_fatal_signal)[0x15af5d9]
sigaction.c:0(__restore_rt)[0x7f8195bc23c0]
sql/item_cmpfunc.h:2058(Predicant_to_list_comparator::cmp_arg(Item_args*, unsigned int))[0x16ccaaf]
??:0(Item_func_case::str_op(String*))[0x16cd3e2]
sql/sql_type.cc:5665(Type_handler_string_result::Item_func_hybrid_field_type_get_date(THD*, Item_func_hybrid_field_type*, Temporal::Warn*, st_mysql_time*, date_mode_t) const)[0x131bef1]
sql/sql_type.cc:5145(Type_handler::Item_func_hybrid_field_type_get_date_with_warn(THD*, Item_func_hybrid_field_type*, st_mysql_time*, date_mode_t) const)[0x1317054]
sql/sql_type.cc:758(Time::make_from_item(THD*, int*, Item*, Time::Options))[0x12f1254]
??:0(Item_time_typecast::get_date(THD*, st_mysql_time*, date_mode_t))[0x19cfef0]
sql/item.cc:363(Item::save_time_in_field(Field*, bool))[0x1601545]
sql/item.cc:6812(Item::save_in_field(Field*, bool))[0x164ce5a]
sql/table.cc:8761(TABLE::update_virtual_fields(handler*, enum_vcol_update_mode))[0x1072e99]
??:0(handler::ha_rnd_next(unsigned char*))[0x15c4e50]
sql/records.cc:519(rr_sequential(READ_RECORD*))[0x930065]
sql/sql_select.cc:21092(sub_select(JOIN*, st_join_table*, bool))[0xd4c04e]
??:0(JOIN::exec_inner())[0xdc6798]
sql/sql_select.cc:4528(JOIN::exec())[0xdc344d]
sql/sql_select.cc:5009(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*))[0xd4e4e9]
sql/sql_select.cc:543(handle_select(THD*, LEX*, select_result*, unsigned long))[0xd4d74c]
sql/sql_parse.cc:6252(execute_sqlcom_select(THD*, TABLE_LIST*))[0xc74411]
sql/sql_parse.cc:3943(mysql_execute_command(THD*, bool))[0xc609ca]
sql/sql_class.h:2734(THD::enter_stage(PSI_stage_info_v1 const*, char const*, char const*, unsigned int))[0xc4a67f]
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0xc41baa]
sql/sql_parse.cc:1404(do_command(THD*, bool))[0xc4b74c]
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x111f9f3]
sql/sql_connect.cc:0(handle_one_connection)[0x111f249]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x1f3f9de]
nptl/pthread_create.c:478(start_thread)[0x7f8195bb6609]
??:0(clone)[0x7f81958cc163]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x62900008c238): SELECT * FROM v0 WHERE v1 LIKE 'x' ORDER BY COALESCE ( 'x' )
Transition
Time In Source Status
Execution Times
Open
Confirmed
2d 7h 44m
1
Confirmed
Closed
573d 2h 14m
1
{"report":{"fcp":1696.8999996185303,"ttfb":182.0999994277954,"pageVisibility":"visible","entityId":108863,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"b70df687-5857-490f-900d-1efe6e9a7a5b","navigationType":0,"readyForUser":1972.3999996185303,"redirectCount":0,"resourceLoadedEnd":1203.0999994277954,"resourceLoadedStart":198.39999961853027,"resourceTiming":[{"duration":129.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":198.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":328.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":130.20000076293945,"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":198.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":328.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":578,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":198.69999980926514,"connectEnd":198.69999980926514,"connectStart":198.69999980926514,"domainLookupEnd":198.69999980926514,"domainLookupStart":198.69999980926514,"fetchStart":198.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":347.5,"responseEnd":776.6999998092651,"responseStart":363.8999996185303,"secureConnectionStart":198.69999980926514},{"duration":1004.2999992370605,"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":198.80000019073486,"connectEnd":198.80000019073486,"connectStart":198.80000019073486,"domainLookupEnd":198.80000019073486,"domainLookupStart":198.80000019073486,"fetchStart":198.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":348.19999980926514,"responseEnd":1203.0999994277954,"responseStart":435.5999994277954,"secureConnectionStart":198.80000019073486},{"duration":113.5,"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":198.89999961853027,"connectEnd":198.89999961853027,"connectStart":198.89999961853027,"domainLookupEnd":198.89999961853027,"domainLookupStart":198.89999961853027,"fetchStart":198.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":198.89999961853027,"responseEnd":312.3999996185303,"responseStart":312.3999996185303,"secureConnectionStart":198.89999961853027},{"duration":127.89999961853027,"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":199,"connectEnd":199,"connectStart":199,"domainLookupEnd":199,"domainLookupStart":199,"fetchStart":199,"redirectEnd":0,"redirectStart":0,"requestStart":199,"responseEnd":326.8999996185303,"responseStart":326.8999996185303,"secureConnectionStart":199},{"duration":129.5,"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":199,"connectEnd":199,"connectStart":199,"domainLookupEnd":199,"domainLookupStart":199,"fetchStart":199,"redirectEnd":0,"redirectStart":0,"requestStart":199,"responseEnd":328.5,"responseStart":328.5,"secureConnectionStart":199},{"duration":145.20000076293945,"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":199.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":199.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":344.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":138.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":205.69999980926514,"connectEnd":205.69999980926514,"connectStart":205.69999980926514,"domainLookupEnd":205.69999980926514,"domainLookupStart":205.69999980926514,"fetchStart":205.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":205.69999980926514,"responseEnd":344.19999980926514,"responseStart":344.19999980926514,"secureConnectionStart":205.69999980926514},{"duration":145.5,"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.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":142.30000019073486,"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":348.30000019073486,"responseStart":348.30000019073486,"secureConnectionStart":206},{"duration":287.19999980926514,"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":207.19999980926514,"connectEnd":207.19999980926514,"connectStart":207.19999980926514,"domainLookupEnd":207.19999980926514,"domainLookupStart":207.19999980926514,"fetchStart":207.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":207.19999980926514,"responseEnd":494.3999996185303,"responseStart":494.3999996185303,"secureConnectionStart":207.19999980926514},{"duration":291.8999996185303,"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":207.30000019073486,"connectEnd":207.30000019073486,"connectStart":207.30000019073486,"domainLookupEnd":207.30000019073486,"domainLookupStart":207.30000019073486,"fetchStart":207.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":207.30000019073486,"responseEnd":499.19999980926514,"responseStart":499.19999980926514,"secureConnectionStart":207.30000019073486},{"duration":309.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1033.1999998092651,"connectEnd":1033.1999998092651,"connectStart":1033.1999998092651,"domainLookupEnd":1033.1999998092651,"domainLookupStart":1033.1999998092651,"fetchStart":1033.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1307.5999994277954,"responseEnd":1343,"responseStart":1342,"secureConnectionStart":1033.1999998092651},{"duration":229.5999994277954,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1614,"connectEnd":1614,"connectStart":1614,"domainLookupEnd":1614,"domainLookupStart":1614,"fetchStart":1614,"redirectEnd":0,"redirectStart":0,"requestStart":1814.5,"responseEnd":1843.5999994277954,"responseStart":1842.5,"secureConnectionStart":1614},{"duration":372.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1722.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1722.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2094.800000190735,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":11,"responseStart":182,"responseEnd":185,"domLoading":196,"domInteractive":2077,"domContentLoadedEventStart":2077,"domContentLoadedEventEnd":2140,"domComplete":2540,"loadEventStart":2540,"loadEventEnd":2541,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2014.0999994277954},{"name":"bigPipe.sidebar-id.end","time":2015},{"name":"bigPipe.activity-panel-pipe-id.start","time":2015.0999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":2051.3999996185303},{"name":"activityTabFullyLoaded","time":2156.8999996185303}],"measures":[],"correlationId":"ccfdbdd1c77ea7","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":79,"dbReadsTimeInMs":18,"dbConnsTimeInMs":28,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}