Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
5.3.6
Component/s:
None
https://bugs.launchpad.net/maria/+bug/992722
Simplified version:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 ( a DATE );
SELECT * FROM t1 WHERE ( SELECT a FROM t1 ) IN ('2012-04-25','2012-04-26');
Reproducible on the current maria-5.3 tree (revno 3510).
Reproducible with the default optimizer_switch, as well as with all OFF values.
Could not reproduce on maria-5.1, maria-5.2, maria-5.5, mysql-5.5, mysql-trunk.
#3 <signal handler called>
#4 0x00000000006388fb in get_datetime_value (thd=0x1c2b9a8, item_arg=0x7fb02c5d60f0,
cache_arg=0x0, warn_item=0x0, is_null=0x7fb02c5d60ef) at item_cmpfunc.cc:877
#5 0x00000000006413f2 in in_datetime::set (this=0x1cde590, pos=0, item=0x1cb16e8)
at item_cmpfunc.cc:3455
#6 0x0000000000642fa8 in Item_func_in::fix_length_and_dec (this=0x1cb18a0)
at item_cmpfunc.cc:3958
#7 0x000000000061cc1d in Item_func::fix_fields (this=0x1cb18a0, thd=0x1c2b9a8,
ref=0x1cb1e60) at item_func.cc:207
#8 0x00000000006424cb in Item_func_in::fix_fields (this=0x1cb18a0, thd=0x1c2b9a8,
ref=0x1cb1e60) at item_cmpfunc.cc:3776
#9 0x000000000075b1c1 in setup_conds (thd=0x1c2b9a8, tables=0x1cb0398, leaves=...,
conds=0x1cb1e60) at sql_base.cc:8502
#10 0x00000000007ad527 in setup_without_group (thd=0x1c2b9a8,
ref_pointer_array=0x1cb20a0, tables=0x1cb0398, leaves=..., fields=...,
all_fields=..., conds=0x1cb1e60, order=0x0, group=0x0,
hidden_group_fields=0x1cb1d57) at sql_select.cc:519
#11 0x0000000000771447 in JOIN::prepare (this=0x1cb1a88, rref_pointer_array=0x1c2e5e8,
tables_init=0x1cb0398, wild_num=1, conds_init=0x1cb18a0, og_num=0, order_init=0x0,
group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1c2e398,
unit_arg=0x1c2de90) at sql_select.cc:667
#12 0x0000000000779b83 in mysql_select (thd=0x1c2b9a8, rref_pointer_array=0x1c2e5e8,
tables=0x1cb0398, wild_num=1, fields=..., conds=0x1cb18a0, og_num=0, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x1cb1a68,
unit=0x1c2de90, select_lex=0x1c2e398) at sql_select.cc:2932
#13 0x0000000000770801 in handle_select (thd=0x1c2b9a8, lex=0x1c2ddf0,
result=0x1cb1a68, setup_tables_done_option=0) at sql_select.cc:285
#14 0x00000000006feecc in execute_sqlcom_select (thd=0x1c2b9a8, all_tables=0x1cb0398)
at sql_parse.cc:5151
#15 0x00000000006f5f89 in mysql_execute_command (thd=0x1c2b9a8) at sql_parse.cc:2284
#16 0x00000000007018a7 in mysql_parse (thd=0x1c2b9a8,
rawbuf=0x1cb0140 "SELECT * FROM t1 WHERE ( SELECT a FROM t1 ) IN ('2012-04-25','2012-04-26')", length=74, found_semicolon=0x7fb02c5d7c98) at sql_parse.cc:6152
#17 0x00000000006f3738 in dispatch_command (command=COM_QUERY, thd=0x1c2b9a8,
packet=0x1ca6c89 "SELECT * FROM t1 WHERE ( SELECT a FROM t1 ) IN ('2012-04-25','2012-04-26')", packet_length=74) at sql_parse.cc:1228
#18 0x00000000006f2a6c in do_command (thd=0x1c2b9a8) at sql_parse.cc:923
#19 0x00000000006ef8ba in handle_one_connection (arg=0x1c2b9a8) at sql_connect.cc:1218
#20 0x00007fb035d75a4f in start_thread () from /lib64/libpthread.so.0
#21 0x00007fb03515f82d in clone () from /lib64/libc.so.6
Transition
Time In Source Status
Execution Times
Open
In Progress
2h 29m
1
In Progress
Closed
7h 36m
1
{"report":{"fcp":718.8000001907349,"ttfb":167.10000038146973,"pageVisibility":"visible","entityId":11535,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d773888c-653c-4752-bf33-7be57d90fdcd","navigationType":0,"readyForUser":778.1000003814697,"redirectCount":0,"resourceLoadedEnd":483.6000003814697,"resourceLoadedStart":181.80000019073486,"resourceTiming":[{"duration":5.300000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":181.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":187.10000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":5.199999809265137,"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":182.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":187.39999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":74.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":182.39999961853027,"connectEnd":182.39999961853027,"connectStart":182.39999961853027,"domainLookupEnd":182.39999961853027,"domainLookupStart":182.39999961853027,"fetchStart":182.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":191.60000038146973,"responseEnd":257.1000003814697,"responseStart":203.89999961853027,"secureConnectionStart":182.39999961853027},{"duration":133.69999980926514,"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":183.19999980926514,"connectEnd":183.19999980926514,"connectStart":183.19999980926514,"domainLookupEnd":183.19999980926514,"domainLookupStart":183.19999980926514,"fetchStart":183.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":192,"responseEnd":316.8999996185303,"responseStart":204.80000019073486,"secureConnectionStart":183.19999980926514},{"duration":20.199999809265137,"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":183.30000019073486,"connectEnd":183.30000019073486,"connectStart":183.30000019073486,"domainLookupEnd":183.30000019073486,"domainLookupStart":183.30000019073486,"fetchStart":183.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":192.39999961853027,"responseEnd":203.5,"responseStart":202.39999961853027,"secureConnectionStart":183.30000019073486},{"duration":35.39999961853027,"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":183.30000019073486,"connectEnd":183.30000019073486,"connectStart":183.30000019073486,"domainLookupEnd":183.30000019073486,"domainLookupStart":183.30000019073486,"fetchStart":183.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":193.10000038146973,"responseEnd":218.69999980926514,"responseStart":217.69999980926514,"secureConnectionStart":183.30000019073486},{"duration":39.90000057220459,"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":183.39999961853027,"connectEnd":183.39999961853027,"connectStart":183.39999961853027,"domainLookupEnd":183.39999961853027,"domainLookupStart":183.39999961853027,"fetchStart":183.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":193.89999961853027,"responseEnd":223.30000019073486,"responseStart":222.39999961853027,"secureConnectionStart":183.39999961853027},{"duration":10.299999237060547,"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":183.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":193.89999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":55.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":183.69999980926514,"connectEnd":183.69999980926514,"connectStart":183.69999980926514,"domainLookupEnd":183.69999980926514,"domainLookupStart":183.69999980926514,"fetchStart":183.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":197.30000019073486,"responseEnd":239.19999980926514,"responseStart":238.39999961853027,"secureConnectionStart":183.69999980926514},{"duration":11.59999942779541,"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":183.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":195.39999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":37.09999942779541,"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":183.80000019073486,"connectEnd":201.19999980926514,"connectStart":201.19999980926514,"domainLookupEnd":201.19999980926514,"domainLookupStart":201.19999980926514,"fetchStart":183.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":201.5,"responseEnd":220.89999961853027,"responseStart":213.39999961853027,"secureConnectionStart":201.19999980926514},{"duration":286.80000019073486,"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":186.69999980926514,"connectEnd":186.69999980926514,"connectStart":186.69999980926514,"domainLookupEnd":186.69999980926514,"domainLookupStart":186.69999980926514,"fetchStart":186.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":215.5,"responseEnd":473.5,"responseStart":471.19999980926514,"secureConnectionStart":186.69999980926514},{"duration":296.80000019073486,"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":186.80000019073486,"connectEnd":186.80000019073486,"connectStart":186.80000019073486,"domainLookupEnd":186.80000019073486,"domainLookupStart":186.80000019073486,"fetchStart":186.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":220.60000038146973,"responseEnd":483.6000003814697,"responseStart":473.69999980926514,"secureConnectionStart":186.80000019073486},{"duration":190.5999994277954,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":470.80000019073486,"connectEnd":470.80000019073486,"connectStart":470.80000019073486,"domainLookupEnd":470.80000019073486,"domainLookupStart":470.80000019073486,"fetchStart":470.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":635.1000003814697,"responseEnd":661.3999996185303,"responseStart":660.5,"secureConnectionStart":470.80000019073486},{"duration":185.30000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":687.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":687.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":872.6000003814697,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":33,"responseStart":167,"responseEnd":186,"domLoading":170,"domInteractive":834,"domContentLoadedEventStart":834,"domContentLoadedEventEnd":870,"domComplete":1337,"loadEventStart":1337,"loadEventEnd":1337,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":815.8000001907349},{"name":"bigPipe.sidebar-id.end","time":816.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":816.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":818},{"name":"activityTabFullyLoaded","time":884}],"measures":[],"correlationId":"140bf5b3d7ea73","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":77,"dbReadsTimeInMs":17,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}