Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.5
When I run the main.derived test on 10.5 with ASAN enabled then the test fails and the stack trace is
Server log from this test:
----------SERVER LOG START-----------
=================================================================
==27857==ERROR: AddressSanitizer: use-after-poison on address 0x62b000174cf8 at pc 0x561e0a9d36ec bp 0x7f110b606820 sp 0x7f110b606810
READ of size 8 at 0x62b000174cf8 thread T8
#0 0x561e0a9d36eb in st_select_lex::collect_grouping_fields(THD*) /home/varunraiko/MariaDB/maria-dev/sql/sql_lex.cc:7901
#1 0x561e0a9e2b67 in st_select_lex::pushdown_from_having_into_where(THD*, Item*) /home/varunraiko/MariaDB/maria-dev/sql/sql_lex.cc:10194
#2 0x561e0aad2cfe in JOIN::optimize_inner() /home/varunraiko/MariaDB/maria-dev/sql/sql_select.cc:1980
#3 0x561e0aace910 in JOIN::optimize() /home/varunraiko/MariaDB/maria-dev/sql/sql_select.cc:1575
#4 0x561e0aaee72a in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /home/varunraiko/MariaDB/maria-dev/sql/sql_select.cc:4598
#5 0x561e0aac1795 in handle_select(THD*, LEX*, select_result*, unsigned long) /home/varunraiko/MariaDB/maria-dev/sql/sql_select.cc:425
#6 0x561e0aa38205 in execute_sqlcom_select /home/varunraiko/MariaDB/maria-dev/sql/sql_parse.cc:6319
#7 0x561e0aa24810 in mysql_execute_command(THD*) /home/varunraiko/MariaDB/maria-dev/sql/sql_parse.cc:3882
#8 0x561e0aa413fd in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /home/varunraiko/MariaDB/maria-dev/sql/sql_parse.cc:7868
#9 0x561e0aa172c2 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /home/varunraiko/MariaDB/maria-dev/sql/sql_parse.cc:1826
#10 0x561e0aa13a62 in do_command(THD*) /home/varunraiko/MariaDB/maria-dev/sql/sql_parse.cc:1359
#11 0x561e0ae1dfd8 in do_handle_one_connection(CONNECT*, bool) /home/varunraiko/MariaDB/maria-dev/sql/sql_connect.cc:1413
#12 0x561e0ae1d883 in handle_one_connection /home/varunraiko/MariaDB/maria-dev/sql/sql_connect.cc:1309
#13 0x561e0ba86b58 in pfs_spawn_thread /home/varunraiko/MariaDB/maria-dev/storage/perfschema/pfs.cc:1862
#14 0x7f11156506da in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76da)
#15 0x7f111483688e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x12188e)
The commit I tested against
commit 46553c250808f0cc21e91f7e13439add2903aea0 (origin/HEAD, origin/10.5, 10.5)
Author: Noel Kuntze <noel@familie-kuntze.de>
Date: Fri May 31 04:18:24 2019 +0200
Fix compiler warnings GCC8
made changes -
2019-07-31 14:37
Field
Original Value
New Value
Assignee
Galina Shalygina
[ shagalla
]
Varun Gupta
[ varun
]
made changes -
2019-07-31 14:39
Description
When I run the main.derived test on 10.5 with ASAN enabled then the test fails and the stack trace is
noel@familie-kuntze.de >
made changes -
2019-08-01 06:14
Assignee
Varun Gupta
[ varun
]
Igor Babaev
[ igor
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
made changes -
2019-08-01 11:33
Fix Version/s
10.5.0
[ 23709
]
Fix Version/s
10.4.8
[ 23721
]
Fix Version/s
10.5
[ 23123
]
Assignee
Igor Babaev
[ igor
]
Varun Gupta
[ varun
]
Resolution
Fixed
[ 1
]
Status
In Review
[ 10002
]
Closed
[ 6
]
made changes -
2021-12-06 21:50
Workflow
MariaDB v3
[ 98620
]
MariaDB v4
[ 156555
]
{"report":{"fcp":874.6999999880791,"ttfb":211.9000000357628,"pageVisibility":"visible","entityId":77913,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d2d922fb-63fc-4e25-8338-f0104fbed2d3","navigationType":0,"readyForUser":947.9000000357628,"redirectCount":0,"resourceLoadedEnd":832,"resourceLoadedStart":217,"resourceTiming":[{"duration":209.30000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":217,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":217,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":426.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":209.30000001192093,"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":217.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":217.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":426.5,"responseStart":0,"secureConnectionStart":0},{"duration":217.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":217.4000000357628,"connectEnd":217.4000000357628,"connectStart":217.4000000357628,"domainLookupEnd":217.4000000357628,"domainLookupStart":217.4000000357628,"fetchStart":217.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":217.4000000357628,"responseEnd":435.19999998807907,"responseStart":435.19999998807907,"secureConnectionStart":217.4000000357628},{"duration":269,"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":217.60000002384186,"connectEnd":217.60000002384186,"connectStart":217.60000002384186,"domainLookupEnd":217.60000002384186,"domainLookupStart":217.60000002384186,"fetchStart":217.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":217.60000002384186,"responseEnd":486.60000002384186,"responseStart":486.60000002384186,"secureConnectionStart":217.60000002384186},{"duration":272.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":217.80000001192093,"connectEnd":217.80000001192093,"connectStart":217.80000001192093,"domainLookupEnd":217.80000001192093,"domainLookupStart":217.80000001192093,"fetchStart":217.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":217.80000001192093,"responseEnd":490.19999998807907,"responseStart":490.19999998807907,"secureConnectionStart":217.80000001192093},{"duration":273.5,"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":218,"connectEnd":218,"connectStart":218,"domainLookupEnd":218,"domainLookupStart":218,"fetchStart":218,"redirectEnd":0,"redirectStart":0,"requestStart":218,"responseEnd":491.5,"responseStart":491.5,"secureConnectionStart":218},{"duration":274.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":218.10000002384186,"connectEnd":218.10000002384186,"connectStart":218.10000002384186,"domainLookupEnd":218.10000002384186,"domainLookupStart":218.10000002384186,"fetchStart":218.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":218.10000002384186,"responseEnd":492.60000002384186,"responseStart":492.60000002384186,"secureConnectionStart":218.10000002384186},{"duration":354.89999997615814,"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":218.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":218.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":573.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":275.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":218.5,"connectEnd":218.5,"connectStart":218.5,"domainLookupEnd":218.5,"domainLookupStart":218.5,"fetchStart":218.5,"redirectEnd":0,"redirectStart":0,"requestStart":218.5,"responseEnd":493.80000001192093,"responseStart":493.80000001192093,"secureConnectionStart":218.5},{"duration":354.7000000476837,"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":218.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":218.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":573.4000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":276.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":218.80000001192093,"connectEnd":218.80000001192093,"connectStart":218.80000001192093,"domainLookupEnd":218.80000001192093,"domainLookupStart":218.80000001192093,"fetchStart":218.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":218.80000001192093,"responseEnd":495.19999998807907,"responseStart":495.19999998807907,"secureConnectionStart":218.80000001192093},{"duration":401.80000001192093,"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":224.19999998807907,"connectEnd":224.19999998807907,"connectStart":224.19999998807907,"domainLookupEnd":224.19999998807907,"domainLookupStart":224.19999998807907,"fetchStart":224.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":224.19999998807907,"responseEnd":626,"responseStart":626,"secureConnectionStart":224.19999998807907},{"duration":499.19999998807907,"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":226.5,"connectEnd":226.5,"connectStart":226.5,"domainLookupEnd":226.5,"domainLookupStart":226.5,"fetchStart":226.5,"redirectEnd":0,"redirectStart":0,"requestStart":226.5,"responseEnd":725.6999999880791,"responseStart":725.6999999880791,"secureConnectionStart":226.5},{"duration":43.40000003576279,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":584.1999999880791,"connectEnd":584.1999999880791,"connectStart":584.1999999880791,"domainLookupEnd":584.1999999880791,"domainLookupStart":584.1999999880791,"fetchStart":584.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":584.1999999880791,"responseEnd":627.6000000238419,"responseStart":627.6000000238419,"secureConnectionStart":584.1999999880791},{"duration":201.30000001192093,"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":630.6999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":630.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":832,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":25,"responseStart":212,"responseEnd":226,"domLoading":215,"domInteractive":1046,"domContentLoadedEventStart":1046,"domContentLoadedEventEnd":1095,"domComplete":1359,"loadEventStart":1359,"loadEventEnd":1359,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1019},{"name":"bigPipe.sidebar-id.end","time":1019.8000000119209},{"name":"bigPipe.activity-panel-pipe-id.start","time":1019.9000000357628},{"name":"bigPipe.activity-panel-pipe-id.end","time":1023.4000000357628},{"name":"activityTabFullyLoaded","time":1115.5}],"measures":[],"correlationId":"6cb8fae114f8af","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":124,"dbReadsTimeInMs":22,"dbConnsTimeInMs":31,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
The test case where this fails
EXPLAINSELECT Customer, Success, SUM(OrderSize)FROM (SELECT Customer,CASE WHEN DeliveryStatus='Success' THEN 'Yes' ELSE 'No' END AS Success,OrderSizeFROM example1463) as subQGROUP BY Success, CustomerHAVING Success IS NOT NULL;Inside the function st_select_lex::collect_grouping_fields we try to collect list of group by items that are of type Item_field.
For the above case the item Success is Item_direct_view_ref and the ref is to a Functional Item.
So this Item should not be added to the grouping_fields list