Type:
Bug
Priority:
Blocker
Resolution:
Fixed
Affects Version/s:
10.6.1 , 10.5.11 , 10.2(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6
Environment:
Linux 5.4.0-39-generic #43-Ubuntu SMP Fri Jun 19 10:28:31 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
Steps to reproduce:
CREATE TABLE v0 ( v1 INT PRIMARY KEY ) ;
INSERT INTO v0 VALUES ( ( ( 23695630.000000 ) ) NOT IN ( SELECT DISTINCT - ( 89 IN ( 127 , 'x' , NULL ) ) IN ( 'x' , 127 ) FROM v0 AS v2 WHERE v1 IS NOT NULL GROUP BY ( ( SELECT DISTINCT - ( 'x' IN ( 65 , NULL ) ) IN ( 'x' , -2147483648 ) AND ( SELECT NULL WHERE - ( 16 ) AND ( v1 IN ( ( ( v1 = v1 ) ) = 'x' ) ) = -2147483648 ) ) ) ORDER BY ( v1 = 'x' AND 84 ) OR ( v1 = 8 AND v1 = -1 ) ASC ) ) ;
CREATE TABLE v3 ( v4 INTEGER , v5 INT PRIMARY KEY , v6 VARCHAR ( 24 ) , v7 INT , v8 INT , v9 INT ) ;
INSERT INTO v3 ( v5 ) VALUES ( ( ( - ( ( 'x' IS NOT NULL ) ) ) ) ) , ( 55 BETWEEN - 80445159.000000 AND - ( ( ( SELECT DISTINCT v1 IN ( ( -1 IN ( ( SELECT DISTINCT - ( 58 IN ( ( -128 IN ( 54560735.000000 ) ) ) ) NOT IN ( 'x' , - ( ( 54 IN ( ( NULL IN ( ( SELECT v1 FROM v0 AS v12 WHERE - ( 99 ) AND v1 = 95 GROUP BY 89382485.000000 ) ) ) ) ) ) ) AS v11 ) ) ) = 'x' ) FROM v0 AS v10 WHERE v1 IS NOT NULL GROUP BY 'x' , 5612101.000000 ) ) ) ) ;
Backtrace:
Core was generated by `/home/supersix/fuzz/security/MariaDB/install/bin/mysqld --defaults-file=/home/s'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=0xb)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
[Current thread is 1 (Thread 0x7f0f26251300 (LWP 1437547))]
gdb-peda$ #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=0xb)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1 0x0000559d3cff698f in my_write_core (sig=sig@entry=0xb)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/mysys/stacktrace.c:424
#2 0x0000559d3ba63583 in handle_fatal_signal (sig=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/signal_handler.cc:344
#3 <signal handler called>
#4 0x0000559d3be106ea in Item_subselect::init_expr_cache_tracker (
this=0x6290021eddb8, thd=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_lex.h:982
#5 0x0000559d3be108df in Item_singlerow_subselect::expr_cache_insert_transformer (this=0x6290021eddb8, tmp_thd=0x62b000070218, unused=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/item_subselect.cc:1389
#6 0x0000559d3bab3024 in Item::transform (this=<optimized out>,
thd=<optimized out>, transformer=<optimized out>, arg=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/item.cc:610
#7 0x0000559d3bb7d48a in Item_cond::transform (this=<optimized out>,
thd=<optimized out>, transformer=&virtual table offset 1328,
arg=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/item_cmpfunc.cc:5135
#8 0x0000559d3b235270 in JOIN::setup_subquery_caches (this=0x62900222e478)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_select.cc:4225
#9 0x0000559d3b31b21f in JOIN::optimize_stage2 (this=0x62900222e478)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_select.cc:3065
#10 0x0000559d3b327252 in JOIN::optimize_inner (this=0x62900222e478)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_select.cc:2477
#11 0x0000559d3b329eda in JOIN::optimize (this=this@entry=0x62900222e478)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_select.cc:1807
#12 0x0000559d3b09fb28 in st_select_lex::optimize_unflattened_subqueries (
this=0x62b000079968, const_only=const_only@entry=0x0)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_lex.cc:4936
#13 0x0000559d3b0643e5 in mysql_insert (thd=thd@entry=0x62b000070218,
table_list=<optimized out>, fields=..., values_list=...,
update_fields=..., update_values=..., duplic=<optimized out>,
ignore=<optimized out>, result=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_lex.h:982
#14 0x0000559d3b15ca9c in mysql_execute_command (thd=<optimized out>,
is_called_from_prepared_stmt=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_parse.cc:4568
#15 0x0000559d3b1188dd in mysql_parse (thd=0x62b000070218,
rawbuf=<optimized out>, length=<optimized out>,
parser_state=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_parse.cc:8028
#16 0x0000559d3b14edb9 in dispatch_command (command=COM_QUERY,
thd=0x62b000070218, packet=<optimized out>, packet_length=<optimized out>,
blocking=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_parse.cc:1995
#17 0x0000559d3b153704 in do_command (thd=0x62b000070218,
blocking=blocking@entry=0x1)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_parse.cc:1406
#18 0x0000559d3b61314d in do_handle_one_connection (connect=<optimized out>,
put_in_cache=<optimized out>)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_connect.cc:1410
#19 0x0000559d3b614807 in handle_one_connection (arg=arg@entry=0x608008ba4fb8)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/sql/sql_connect.cc:1312
#20 0x0000559d3c45fef0 in pfs_spawn_thread (arg=0x617000005b98)
at /home/supersix/fuzz/security/MariaDB/mariadb-10.6.2/storage/perfschema/pfs.cc:2201
#21 0x00007f0f481e3609 in start_thread (arg=<optimized out>)
at pthread_create.c:477
#22 0x00007f0f47db7293 in clone ()
at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
gdb-peda$ quit
{"report":{"fcp":772.5,"ttfb":214.5,"pageVisibility":"visible","entityId":100906,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"a1083036-1caf-4b56-a44c-daf67ade8a6b","navigationType":0,"readyForUser":938.4000000953674,"redirectCount":0,"resourceLoadedEnd":821.7999997138977,"resourceLoadedStart":220.69999980926514,"resourceTiming":[{"duration":6.099999904632568,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":220.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":226.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":6,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":220.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":226.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":63.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":221.09999990463257,"connectEnd":221.09999990463257,"connectStart":221.09999990463257,"domainLookupEnd":221.09999990463257,"domainLookupStart":221.09999990463257,"fetchStart":221.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":221.09999990463257,"responseEnd":284.69999980926514,"responseStart":284.69999980926514,"secureConnectionStart":221.09999990463257},{"duration":212.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":221.2999997138977,"connectEnd":221.2999997138977,"connectStart":221.2999997138977,"domainLookupEnd":221.2999997138977,"domainLookupStart":221.2999997138977,"fetchStart":221.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":221.2999997138977,"responseEnd":433.7999997138977,"responseStart":433.7999997138977,"secureConnectionStart":221.2999997138977},{"duration":216.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":221.5,"connectEnd":221.5,"connectStart":221.5,"domainLookupEnd":221.5,"domainLookupStart":221.5,"fetchStart":221.5,"redirectEnd":0,"redirectStart":0,"requestStart":221.5,"responseEnd":437.90000009536743,"responseStart":437.90000009536743,"secureConnectionStart":221.5},{"duration":216.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":221.7999997138977,"connectEnd":221.7999997138977,"connectStart":221.7999997138977,"domainLookupEnd":221.7999997138977,"domainLookupStart":221.7999997138977,"fetchStart":221.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":221.7999997138977,"responseEnd":438.40000009536743,"responseStart":438.40000009536743,"secureConnectionStart":221.7999997138977},{"duration":216.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":222,"connectEnd":222,"connectStart":222,"domainLookupEnd":222,"domainLookupStart":222,"fetchStart":222,"redirectEnd":0,"redirectStart":0,"requestStart":222,"responseEnd":438.69999980926514,"responseStart":438.69999980926514,"secureConnectionStart":222},{"duration":217.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":222.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":222.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":439.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":216.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":222.2999997138977,"connectEnd":222.2999997138977,"connectStart":222.2999997138977,"domainLookupEnd":222.2999997138977,"domainLookupStart":222.2999997138977,"fetchStart":222.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":222.2999997138977,"responseEnd":439.09999990463257,"responseStart":439.09999990463257,"secureConnectionStart":222.2999997138977},{"duration":217.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":222.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":222.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":440.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":217.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":222.59999990463257,"connectEnd":222.59999990463257,"connectStart":222.59999990463257,"domainLookupEnd":222.59999990463257,"domainLookupStart":222.59999990463257,"fetchStart":222.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":222.59999990463257,"responseEnd":439.69999980926514,"responseStart":439.69999980926514,"secureConnectionStart":222.59999990463257},{"duration":483.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":224.5,"connectEnd":224.5,"connectStart":224.5,"domainLookupEnd":224.5,"domainLookupStart":224.5,"fetchStart":224.5,"redirectEnd":0,"redirectStart":0,"requestStart":224.5,"responseEnd":708.2999997138977,"responseStart":708.2999997138977,"secureConnectionStart":224.5},{"duration":572.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":224.5,"connectEnd":224.5,"connectStart":224.5,"domainLookupEnd":224.5,"domainLookupStart":224.5,"fetchStart":224.5,"redirectEnd":0,"redirectStart":0,"requestStart":224.5,"responseEnd":796.5999999046326,"responseStart":796.5999999046326,"secureConnectionStart":224.5},{"duration":257.19999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":451.40000009536743,"connectEnd":451.40000009536743,"connectStart":451.40000009536743,"domainLookupEnd":451.40000009536743,"domainLookupStart":451.40000009536743,"fetchStart":451.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":451.40000009536743,"responseEnd":708.5999999046326,"responseStart":708.5999999046326,"secureConnectionStart":451.40000009536743},{"duration":80,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/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&whisper-enabled=true","startTime":724.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":724.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":804.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":82.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/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&whisper-enabled=true","startTime":725.0999999046326,"connectEnd":725.0999999046326,"connectStart":725.0999999046326,"domainLookupEnd":725.0999999046326,"domainLookupStart":725.0999999046326,"fetchStart":725.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":725.0999999046326,"responseEnd":807.5999999046326,"responseStart":807.5999999046326,"secureConnectionStart":725.0999999046326},{"duration":96.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/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&whisper-enabled=true","startTime":725.5,"connectEnd":725.5,"connectStart":725.5,"domainLookupEnd":725.5,"domainLookupStart":725.5,"fetchStart":725.5,"redirectEnd":0,"redirectStart":0,"requestStart":725.5,"responseEnd":821.7999997138977,"responseStart":821.7999997138977,"secureConnectionStart":725.5},{"duration":229.59999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":766,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":766,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":995.5999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":21,"responseStart":215,"responseEnd":217,"domLoading":218,"domInteractive":1021,"domContentLoadedEventStart":1021,"domContentLoadedEventEnd":1080,"domComplete":1254,"loadEventStart":1254,"loadEventEnd":1255,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1005.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1006},{"name":"bigPipe.activity-panel-pipe-id.start","time":1006.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1007.7999997138977},{"name":"activityTabFullyLoaded","time":1112.4000000953674}],"measures":[],"correlationId":"e5d5f8cfb62231","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":117,"dbReadsTimeInMs":18,"dbConnsTimeInMs":27,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
A patch: https://github.com/MariaDB/server/commit/c01ee954bf3b10fef85af7b8c77d319ff7bd6b61