Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.1(EOL) , 10.2(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL) , 11.1(EOL) , 11.2(EOL) , 11.4 , 11.8
ATTENTION: The test case is for reproducing purposes only, don't put it into a regression suite! Create a proper one instead, with debug sync if necessary.
The test case is non-deterministic. It has a loop to avoid running with --repeat. With the current 10K loops it either fails or passes in a few seconds. If it doesn't fail for you, try to increase the number of loops.
CREATE TABLE t1 (a INT ) ENGINE=InnoDB;
--connect (con1,localhost,root,,test)
--let $conid= `select connection_id()`
--delimiter $
--send
BEGIN NOT ATOMIC
DECLARE CONTINUE HANDLER FOR 1054 BEGIN END ;
LOOP
SELECT * FROM t1 WHERE x = 1;
END LOOP;
END $
--delimiter ;
--connection default
--let $run= 10000
while ($run)
{
SELECT * FROM t1 WHERE COLUMN_GET( COLUMN_CREATE( 1, 2 ), 3 AS INT );
--dec $run
}
# Cleanup
--eval KILL $conid
DROP TABLE t1;
10.2 b0df247d
mysqld: /data/src/10.2/sql/item_strfunc.cc:5194: virtual void Item_dyncol_get::print(String*, enum_query_type): Assertion `strncmp(str->ptr() + str->length() - 5, "cast(", 5) == 0' failed.
200723 19:34:18 [ERROR] mysqld got signal 6 ;
#7 0x00007f7e56e48f12 in __GI___assert_fail (assertion=0x55dcf59f0a40 "strncmp(str->ptr() + str->length() - 5, \"cast(\", 5) == 0", file=0x55dcf59f0520 "/data/src/10.2/sql/item_strfunc.cc", line=5194, function=0x55dcf59f2200 <Item_dyncol_get::print(String*, enum_query_type)::__PRETTY_FUNCTION__> "virtual void Item_dyncol_get::print(String*, enum_query_type)") at assert.c:101
#8 0x000055dcf51ad52f in Item_dyncol_get::print (this=0x7f7e40013030, str=0x7f7e5117b280, query_type=QT_EXPLAIN) at /data/src/10.2/sql/item_strfunc.cc:5194
#9 0x000055dcf516d719 in Item_func_signed::print (this=0x7f7e400130f0, str=0x7f7e5117b280, query_type=QT_EXPLAIN) at /data/src/10.2/sql/item_func.cc:1079
#10 0x000055dcf51272d3 in dbug_print_item (item=0x7f7e400130f0) at /data/src/10.2/sql/item.cc:10835
#11 0x000055dcf4eb93cd in JOIN::prepare (this=0x7f7e40013298, tables_init=0x7f7e400126a0, wild_num=1, conds_init=0x7f7e400130f0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f7e40004e28, unit_arg=0x7f7e400046e8) at /data/src/10.2/sql/sql_select.cc:711
#12 0x000055dcf4ec437c in mysql_select (thd=0x7f7e40000af0, tables=0x7f7e400126a0, wild_num=1, fields=..., conds=0x7f7e400130f0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f7e40013278, unit=0x7f7e400046e8, select_lex=0x7f7e40004e28) at /data/src/10.2/sql/sql_select.cc:3811
#13 0x000055dcf4eb85ec in handle_select (thd=0x7f7e40000af0, lex=0x7f7e40004628, result=0x7f7e40013278, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:361
#14 0x000055dcf4e84036 in execute_sqlcom_select (thd=0x7f7e40000af0, all_tables=0x7f7e400126a0) at /data/src/10.2/sql/sql_parse.cc:6218
#15 0x000055dcf4e7a8b7 in mysql_execute_command (thd=0x7f7e40000af0) at /data/src/10.2/sql/sql_parse.cc:3524
#16 0x000055dcf4e87d6d in mysql_parse (thd=0x7f7e40000af0, rawbuf=0x7f7e40012458 "SELECT * FROM t1 WHERE COLUMN_GET( COLUMN_CREATE( 1, 2 ), 3 AS INT )", length=68, parser_state=0x7f7e5117c610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733
#17 0x000055dcf4e76099 in dispatch_command (command=COM_QUERY, thd=0x7f7e40000af0, packet=0x7f7e4008d451 "SELECT * FROM t1 WHERE COLUMN_GET( COLUMN_CREATE( 1, 2 ), 3 AS INT )", packet_length=68, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
#18 0x000055dcf4e74b14 in do_command (thd=0x7f7e40000af0) at /data/src/10.2/sql/sql_parse.cc:1377
#19 0x000055dcf4fcaaef in do_handle_one_connection (connect=0x55dcf7f77ca0) at /data/src/10.2/sql/sql_connect.cc:1336
#20 0x000055dcf4fca85a in handle_one_connection (arg=0x55dcf7f77ca0) at /data/src/10.2/sql/sql_connect.cc:1241
#21 0x000055dcf57e0f12 in pfs_spawn_thread (arg=0x55dcf7ec4a70) at /data/src/10.2/storage/perfschema/pfs.cc:1869
#22 0x00007f7e58dd14a4 in start_thread (arg=0x7f7e5117d700) at pthread_create.c:456
#23 0x00007f7e56f05d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
The table engine seems unimportant, reproducible with at least MyISAM, InnoDB, Aria.
No obvious problem on a non-debug build.
Alice Sherepa
made changes -
2021-10-12 09:23
Field
Original Value
New Value
Affects Version/s
10.6
[ 24028
]
Alice Sherepa
made changes -
2021-10-12 09:23
Fix Version/s
10.6
[ 24028
]
Alice Sherepa
made changes -
2021-10-12 09:23
Status
Open
[ 1
]
Confirmed
[ 10101
]
Sergei Golubchik
made changes -
2021-12-06 21:36
Workflow
MariaDB v3
[ 111644
]
MariaDB v4
[ 144284
]
Alice Sherepa
made changes -
2022-04-27 05:40
Affects Version/s
10.7
[ 24805
]
Affects Version/s
10.8
[ 26121
]
Alice Sherepa
made changes -
2022-04-27 05:40
Fix Version/s
10.7
[ 24805
]
Ralf Gebhardt
made changes -
2022-08-04 08:46
Fix Version/s
10.2
[ 14601
]
Julien Fritsch
made changes -
2023-03-03 17:33
Fix Version/s
10.7
[ 24805
]
Julien Fritsch
made changes -
2023-04-27 13:56
Fix Version/s
10.3
[ 22126
]
Alice Sherepa
made changes -
2023-05-04 14:38
Fix Version/s
10.9
[ 26905
]
Fix Version/s
10.10
[ 27530
]
Fix Version/s
10.11
[ 27614
]
Alice Sherepa
made changes -
2023-10-26 11:10
Affects Version/s
10.9
[ 26905
]
Affects Version/s
10.10
[ 27530
]
Affects Version/s
10.11
[ 27614
]
Affects Version/s
11.0
[ 28320
]
Affects Version/s
11.1
[ 28549
]
Affects Version/s
11.2
[ 28603
]
Affects Version/s
10.7
[ 24805
]
Affects Version/s
10.8
[ 26121
]
Alice Sherepa
made changes -
2023-10-26 11:10
Fix Version/s
11.0
[ 28320
]
Fix Version/s
11.1
[ 28549
]
Fix Version/s
11.2
[ 28603
]
Julien Fritsch
made changes -
2023-11-28 10:21
Fix Version/s
10.9
[ 26905
]
Julien Fritsch
made changes -
2023-11-28 10:31
Fix Version/s
10.10
[ 27530
]
Julien Fritsch
made changes -
2024-05-03 14:41
Fix Version/s
11.0
[ 28320
]
Julien Fritsch
made changes -
2024-09-10 15:01
Fix Version/s
10.4
[ 22408
]
Julien Fritsch
made changes -
2024-09-10 15:26
Fix Version/s
11.1
[ 28549
]
Julien Fritsch
made changes -
2024-11-22 17:12
Fix Version/s
11.2(EOL)
[ 28603
]
Alice Sherepa
made changes -
2025-03-26 15:03
Fix Version/s
11.4
[ 29301
]
Fix Version/s
11.8
[ 29921
]
Alice Sherepa
made changes -
2025-03-26 15:03
Affects Version/s
11.4
[ 29301
]
Affects Version/s
11.8
[ 29921
]
{"report":{"fcp":1163,"ttfb":356,"pageVisibility":"visible","entityId":89929,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d03e2bbb-3da2-461f-8b01-0ef412f91cc4","navigationType":0,"readyForUser":1271.1000000238419,"redirectCount":0,"resourceLoadedEnd":860.6000000238419,"resourceLoadedStart":365.60000002384186,"resourceTiming":[{"duration":19.399999976158142,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":365.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":365.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":385,"responseStart":0,"secureConnectionStart":0},{"duration":27.300000071525574,"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":365.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":365.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":393.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":280.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":366.10000002384186,"connectEnd":366.10000002384186,"connectStart":366.10000002384186,"domainLookupEnd":366.10000002384186,"domainLookupStart":366.10000002384186,"fetchStart":366.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":397.2000000476837,"responseEnd":646.3999999761581,"responseStart":416.39999997615814,"secureConnectionStart":366.10000002384186},{"duration":494.39999997615814,"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":366.2000000476837,"connectEnd":366.2000000476837,"connectStart":366.2000000476837,"domainLookupEnd":366.2000000476837,"domainLookupStart":366.2000000476837,"fetchStart":366.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":397.7000000476837,"responseEnd":860.6000000238419,"responseStart":418.10000002384186,"secureConnectionStart":366.2000000476837},{"duration":27.200000047683716,"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":366.2999999523163,"connectEnd":366.2999999523163,"connectStart":366.2999999523163,"domainLookupEnd":366.2999999523163,"domainLookupStart":366.2999999523163,"fetchStart":366.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":366.2999999523163,"responseEnd":393.5,"responseStart":393.5,"secureConnectionStart":366.2999999523163},{"duration":27.800000071525574,"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":366.2999999523163,"connectEnd":366.2999999523163,"connectStart":366.2999999523163,"domainLookupEnd":366.2999999523163,"domainLookupStart":366.2999999523163,"fetchStart":366.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":366.2999999523163,"responseEnd":394.10000002384186,"responseStart":394.10000002384186,"secureConnectionStart":366.2999999523163},{"duration":32.60000002384186,"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":366.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":366.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":399.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":28.899999976158142,"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":366.5,"connectEnd":366.5,"connectStart":366.5,"domainLookupEnd":366.5,"domainLookupStart":366.5,"fetchStart":366.5,"redirectEnd":0,"redirectStart":0,"requestStart":366.5,"responseEnd":395.39999997615814,"responseStart":395.39999997615814,"secureConnectionStart":366.5},{"duration":32,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":366.60000002384186,"connectEnd":366.60000002384186,"connectStart":366.60000002384186,"domainLookupEnd":366.60000002384186,"domainLookupStart":366.60000002384186,"fetchStart":366.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":366.60000002384186,"responseEnd":398.60000002384186,"responseStart":398.60000002384186,"secureConnectionStart":366.60000002384186},{"duration":33.799999952316284,"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":366.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":366.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":400.5,"responseStart":0,"secureConnectionStart":0},{"duration":33.10000002384186,"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":366.7999999523163,"connectEnd":366.7999999523163,"connectStart":366.7999999523163,"domainLookupEnd":366.7999999523163,"domainLookupStart":366.7999999523163,"fetchStart":366.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":366.7999999523163,"responseEnd":399.89999997615814,"responseStart":399.89999997615814,"secureConnectionStart":366.7999999523163},{"duration":482.5,"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":373.7999999523163,"connectEnd":373.7999999523163,"connectStart":373.7999999523163,"domainLookupEnd":373.7999999523163,"domainLookupStart":373.7999999523163,"fetchStart":373.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":430.5,"responseEnd":856.2999999523163,"responseStart":847.3999999761581,"secureConnectionStart":373.7999999523163},{"duration":477.1999999284744,"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":380.2000000476837,"connectEnd":380.2000000476837,"connectStart":380.2000000476837,"domainLookupEnd":380.2000000476837,"domainLookupStart":380.2000000476837,"fetchStart":380.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":436,"responseEnd":857.3999999761581,"responseStart":848.3999999761581,"secureConnectionStart":380.2000000476837},{"duration":259.39999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":806.7000000476837,"connectEnd":806.7000000476837,"connectStart":806.7000000476837,"domainLookupEnd":806.7000000476837,"domainLookupStart":806.7000000476837,"fetchStart":806.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1025.7999999523163,"responseEnd":1066.1000000238419,"responseStart":1065.2999999523163,"secureConnectionStart":806.7000000476837}],"fetchStart":0,"domainLookupStart":30,"domainLookupEnd":50,"connectStart":50,"connectEnd":70,"secureConnectionStart":58,"requestStart":71,"responseStart":356,"responseEnd":380,"domLoading":364,"domInteractive":1359,"domContentLoadedEventStart":1359,"domContentLoadedEventEnd":1430,"domComplete":2414,"loadEventStart":2414,"loadEventEnd":2415,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1321.5},{"name":"bigPipe.sidebar-id.end","time":1322.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1322.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":1327.2999999523163},{"name":"activityTabFullyLoaded","time":1452.7999999523163}],"measures":[],"correlationId":"e574b7c45b8c49","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":162,"dbReadsTimeInMs":32,"dbConnsTimeInMs":43,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}