MariaDB crashes when executing the following statement:
drop database if exists test123;
|
create database if not exists test123;
|
use test123;
|
DESC FOR CONNECTION + INTERVAL TRUE IN ( SELECT 'string' ) YEAR_MONTH + FALSE <=> TRUE NOT IN ( SELECT * );
|
Crash stack:
#0 0x0000000001bbe8bc in Item_subselect::init (this=0xffff7e8f2640, select_lex=0xffff7e8f17b8, result=0xffff7e8f2850)
|
at /home/mariadb/mariadb-server/sql/item_subselect.cc:124
|
#1 0x0000000001bccc44 in Item_in_subselect::Item_in_subselect (this=0xffff7e8f2640, thd=0xffff58e5b218, left_exp=<optimized out>,
|
select_lex=0xffff7e8f17b8) at /home/mariadb/mariadb-server/sql/item_subselect.cc:1664
|
#2 0x0000000001649b48 in MYSQLparse (thd=<optimized out>) at /home/mariadb/mariadb-server/sql/sql_yacc.yy:9670
|
#3 0x0000000000d575c0 in parse_sql (thd=0xffff58e5b218, parser_state=<optimized out>, creation_ctx=0x0, do_pfs_digest=true)
|
at /home/mariadb/mariadb-server/sql/sql_parse.cc:10328
|
#4 0x0000000000d1c8b8 in mysql_parse (thd=0xffff58e5b218,
|
rawbuf=0xffff7e8f0438 "DESC FOR CONNECTION + INTERVAL TRUE IN ( SELECT 'string' ) YEAR_MONTH + FALSE <=> TRUE NOT IN ( SELECT * )",
|
length=<optimized out>, parser_state=<optimized out>) at /home/mariadb/mariadb-server/sql/sql_parse.cc:7867
|
#5 0x0000000000d120f0 in dispatch_command (command=<optimized out>, thd=<optimized out>, packet=<optimized out>, packet_length=<optimized out>,
|
blocking=<optimized out>) at /home/mariadb/mariadb-server/sql/sql_parse.cc:1902
|
#6 0x0000000000d1dbf4 in do_command (thd=0xffff58e5b218, blocking=true) at /home/mariadb/mariadb-server/sql/sql_parse.cc:1415
|
#7 0x00000000012846f8 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /home/mariadb/mariadb-server/sql/sql_connect.cc:1415
|
#8 0x00000000012841b4 in handle_one_connection (arg=0xffff84a34db8) at /home/mariadb/mariadb-server/sql/sql_connect.cc:1327
|
#9 0x0000000002200c38 in pfs_spawn_thread (arg=0xffff7e405f18) at /home/mariadb/mariadb-server/storage/perfschema/pfs.cc:2198
|
#10 0x0000ffff8a44d624 in start_thread (arg=0x883ac8 <asan_thread_start(void*)>) at pthread_create.c:477
|
#11 0x0000ffff8a16f66c in thread_start () at ../sysdeps/unix/sysv/linux/aarch64/clone.S:78
|
{"report":{"fcp":1362,"ttfb":179.2999997138977,"pageVisibility":"visible","entityId":133436,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"692b8343-0180-40f5-a8fe-72caf2cae967","navigationType":0,"readyForUser":1463.0999999046326,"redirectCount":0,"resourceLoadedEnd":1813,"resourceLoadedStart":186.2999997138977,"resourceTiming":[{"duration":575.3000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":186.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":761.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":575.5,"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":186.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":762.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":585.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":186.7999997138977,"connectEnd":186.7999997138977,"connectStart":186.7999997138977,"domainLookupEnd":186.7999997138977,"domainLookupStart":186.7999997138977,"fetchStart":186.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":186.7999997138977,"responseEnd":772.5,"responseStart":772.5,"secureConnectionStart":186.7999997138977},{"duration":628.6999998092651,"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":186.90000009536743,"connectEnd":186.90000009536743,"connectStart":186.90000009536743,"domainLookupEnd":186.90000009536743,"domainLookupStart":186.90000009536743,"fetchStart":186.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":186.90000009536743,"responseEnd":815.5999999046326,"responseStart":815.5999999046326,"secureConnectionStart":186.90000009536743},{"duration":632.4000000953674,"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":187.09999990463257,"connectEnd":187.09999990463257,"connectStart":187.09999990463257,"domainLookupEnd":187.09999990463257,"domainLookupStart":187.09999990463257,"fetchStart":187.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":187.09999990463257,"responseEnd":819.5,"responseStart":819.5,"secureConnectionStart":187.09999990463257},{"duration":632.8000001907349,"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":187.2999997138977,"connectEnd":187.2999997138977,"connectStart":187.2999997138977,"domainLookupEnd":187.2999997138977,"domainLookupStart":187.2999997138977,"fetchStart":187.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":187.2999997138977,"responseEnd":820.0999999046326,"responseStart":820.0999999046326,"secureConnectionStart":187.2999997138977},{"duration":633.0999999046326,"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":187.5,"connectEnd":187.5,"connectStart":187.5,"domainLookupEnd":187.5,"domainLookupStart":187.5,"fetchStart":187.5,"redirectEnd":0,"redirectStart":0,"requestStart":187.5,"responseEnd":820.5999999046326,"responseStart":820.5999999046326,"secureConnectionStart":187.5},{"duration":758.5,"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":187.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":946.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":633.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":187.7999997138977,"connectEnd":187.7999997138977,"connectStart":187.7999997138977,"domainLookupEnd":187.7999997138977,"domainLookupStart":187.7999997138977,"fetchStart":187.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":187.7999997138977,"responseEnd":821.4000000953674,"responseStart":821.4000000953674,"secureConnectionStart":187.7999997138977},{"duration":759.0999999046326,"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":187.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":947,"responseStart":0,"secureConnectionStart":0},{"duration":634.6999998092651,"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":188.09999990463257,"connectEnd":188.09999990463257,"connectStart":188.09999990463257,"domainLookupEnd":188.09999990463257,"domainLookupStart":188.09999990463257,"fetchStart":188.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":188.09999990463257,"responseEnd":822.7999997138977,"responseStart":822.7999997138977,"secureConnectionStart":188.09999990463257},{"duration":1241.5,"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":189,"connectEnd":189,"connectStart":189,"domainLookupEnd":189,"domainLookupStart":189,"fetchStart":189,"redirectEnd":0,"redirectStart":0,"requestStart":189,"responseEnd":1430.5,"responseStart":1430.5,"secureConnectionStart":189},{"duration":1623.9000000953674,"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":189.09999990463257,"connectEnd":189.09999990463257,"connectStart":189.09999990463257,"domainLookupEnd":189.09999990463257,"domainLookupStart":189.09999990463257,"fetchStart":189.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":189.09999990463257,"responseEnd":1813,"responseStart":1813,"secureConnectionStart":189.09999990463257},{"duration":449.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":997.6999998092651,"connectEnd":997.6999998092651,"connectStart":997.6999998092651,"domainLookupEnd":997.6999998092651,"domainLookupStart":997.6999998092651,"fetchStart":997.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":997.6999998092651,"responseEnd":1447.5,"responseStart":1447.5,"secureConnectionStart":997.6999998092651},{"duration":489.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1346,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1346,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1835.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":12,"responseStart":179,"responseEnd":183,"domLoading":184,"domInteractive":1838,"domContentLoadedEventStart":1838,"domContentLoadedEventEnd":1886,"domComplete":3548,"loadEventStart":3548,"loadEventEnd":3551,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1814.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1815.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1815.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1818},{"name":"activityTabFullyLoaded","time":1940.2999997138977}],"measures":[],"correlationId":"a94669dc4eb1da","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":100,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}