Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
10.8.2 , 10.2(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11
CREATE TABLE `t1` (
`c0` int(10) unsigned NOT NULL,
PRIMARY KEY (`c0`),
KEY `ic3` (`c0`) USING BTREE
);
INSERT INTO `t1` VALUES (1332945389);
CREATE TABLE `t2` (
`c0` int(10) unsigned NOT NULL,
PRIMARY KEY (`c0`)
);
INSERT INTO `t2` VALUES (1180244875), (1951338178);
mysql> SET SESSION join_buffer_size = 5250229460064350213;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> SET SESSION join_cache_level = 4;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT t2.c0 FROM t2 LEFT OUTER JOIN t1 ON t1.c0 = t2.c0 WHERE t1.c0;
Empty set (0.00 sec)
mysql> SET optimizer_switch='optimize_join_buffer_size=off';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT t2.c0 FROM t2 LEFT OUTER JOIN t1 ON t1.c0 = t2.c0 WHERE t1.c0;
+------------+
| c0 |
+------------+
| 1180244875 |
| 1951338178 |
+------------+
2 rows in set (0.00 sec)
relates to
MDEV-23949
Assertion `0' failed in JOIN_CACHE::get_match_flag_by_pos
Closed
{"report":{"fcp":941,"ttfb":261.19999999925494,"pageVisibility":"visible","entityId":109426,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"9059a090-d8a4-459a-a017-f037a5c9c067","navigationType":0,"readyForUser":1057.3999999985099,"redirectCount":0,"resourceLoadedEnd":1146.3999999985099,"resourceLoadedStart":267.09999999962747,"resourceTiming":[{"duration":196.19999999925494,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":267.09999999962747,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.09999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":463.2999999988824,"responseStart":0,"secureConnectionStart":0},{"duration":196.30000000074506,"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":267.2999999988824,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.2999999988824,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":463.59999999962747,"responseStart":0,"secureConnectionStart":0},{"duration":205,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":267.5,"connectEnd":267.5,"connectStart":267.5,"domainLookupEnd":267.5,"domainLookupStart":267.5,"fetchStart":267.5,"redirectEnd":0,"redirectStart":0,"requestStart":267.5,"responseEnd":472.5,"responseStart":472.5,"secureConnectionStart":267.5},{"duration":280.69999999925494,"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":267.69999999925494,"connectEnd":267.69999999925494,"connectStart":267.69999999925494,"domainLookupEnd":267.69999999925494,"domainLookupStart":267.69999999925494,"fetchStart":267.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":267.69999999925494,"responseEnd":548.3999999985099,"responseStart":548.3999999985099,"secureConnectionStart":267.69999999925494},{"duration":284.2000000011176,"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":267.8999999985099,"connectEnd":267.8999999985099,"connectStart":267.8999999985099,"domainLookupEnd":267.8999999985099,"domainLookupStart":267.8999999985099,"fetchStart":267.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":267.8999999985099,"responseEnd":552.0999999996275,"responseStart":552.0999999996275,"secureConnectionStart":267.8999999985099},{"duration":284.40000000037253,"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":268.09999999962747,"connectEnd":268.09999999962747,"connectStart":268.09999999962747,"domainLookupEnd":268.09999999962747,"domainLookupStart":268.09999999962747,"fetchStart":268.09999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":268.09999999962747,"responseEnd":552.5,"responseStart":552.5,"secureConnectionStart":268.09999999962747},{"duration":284.59999999962747,"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":268.19999999925494,"connectEnd":268.19999999925494,"connectStart":268.19999999925494,"domainLookupEnd":268.19999999925494,"domainLookupStart":268.19999999925494,"fetchStart":268.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":268.19999999925494,"responseEnd":552.7999999988824,"responseStart":552.7999999988824,"secureConnectionStart":268.19999999925494},{"duration":349.30000000074506,"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":268.3999999985099,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":268.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":617.6999999992549,"responseStart":0,"secureConnectionStart":0},{"duration":284.59999999962747,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":268.59999999962747,"connectEnd":268.59999999962747,"connectStart":268.59999999962747,"domainLookupEnd":268.59999999962747,"domainLookupStart":268.59999999962747,"fetchStart":268.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":268.59999999962747,"responseEnd":553.1999999992549,"responseStart":553.1999999992549,"secureConnectionStart":268.59999999962747},{"duration":349.09999999962747,"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":268.7999999988824,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":268.7999999988824,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":617.8999999985099,"responseStart":0,"secureConnectionStart":0},{"duration":284.90000000037253,"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":268.8999999985099,"connectEnd":268.8999999985099,"connectStart":268.8999999985099,"domainLookupEnd":268.8999999985099,"domainLookupStart":268.8999999985099,"fetchStart":268.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":268.8999999985099,"responseEnd":553.7999999988824,"responseStart":553.7999999988824,"secureConnectionStart":268.8999999985099},{"duration":441,"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":269.69999999925494,"connectEnd":269.69999999925494,"connectStart":269.69999999925494,"domainLookupEnd":269.69999999925494,"domainLookupStart":269.69999999925494,"fetchStart":269.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":269.69999999925494,"responseEnd":710.6999999992549,"responseStart":710.5999999996275,"secureConnectionStart":269.69999999925494},{"duration":865.1999999992549,"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":269.69999999925494,"connectEnd":269.69999999925494,"connectStart":269.69999999925494,"domainLookupEnd":269.69999999925494,"domainLookupStart":269.69999999925494,"fetchStart":269.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":269.69999999925494,"responseEnd":1134.8999999985099,"responseStart":1134.8999999985099,"secureConnectionStart":269.69999999925494},{"duration":109.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":646.5,"connectEnd":646.5,"connectStart":646.5,"domainLookupEnd":646.5,"domainLookupStart":646.5,"fetchStart":646.5,"redirectEnd":0,"redirectStart":0,"requestStart":646.5,"responseEnd":756,"responseStart":756,"secureConnectionStart":646.5},{"duration":252,"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":894.3999999985099,"connectEnd":894.3999999985099,"connectStart":894.3999999985099,"domainLookupEnd":894.3999999985099,"domainLookupStart":894.3999999985099,"fetchStart":894.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":894.3999999985099,"responseEnd":1146.3999999985099,"responseStart":1146.3999999985099,"secureConnectionStart":894.3999999985099},{"duration":226.60000000149012,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":934.8999999985099,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":934.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1161.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":81,"responseStart":262,"responseEnd":264,"domLoading":265,"domInteractive":1162,"domContentLoadedEventStart":1162,"domContentLoadedEventEnd":1208,"domComplete":1511,"loadEventStart":1511,"loadEventEnd":1512,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1136.699999999255},{"name":"bigPipe.sidebar-id.end","time":1137.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1137.699999999255},{"name":"bigPipe.activity-panel-pipe-id.end","time":1140},{"name":"activityTabFullyLoaded","time":1227.5999999996275}],"measures":[],"correlationId":"fb7c85186e22b1","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":117,"dbReadsTimeInMs":13,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Thanks! I repeated on 10.2 53b580a91c12e92726-10.8 as described:
--source include/have_innodb.inc