Reproducible on 10.4 with MyIsam/Innodb
create table t1 (pk int, i2 int, id int, v1 varchar(1));
|
|
create table t2 (vr varchar(1));
|
insert into t2 values ('v'),( null);
|
|
create view view1 as
|
select t1.v1
|
from (t1 join (select distinct * from t1) a1 on (a1.v1 = t1.v1))
|
where (select min(vr) from t2) is null
|
group by t1.v1;
|
select * from view1;
|
10.4 4932aba921755cfbc351b9
|
#0 0x5572db98331f in JOIN::optimize() /10.4/sql/sql_select.cc:1490
|
#1 0x5572db82f100 in mysql_derived_optimize(THD*, LEX*, TABLE_LIST*) /10.4/sql/sql_derived.cc:1006
|
#2 0x5572db82a526 in mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int) /10.4/sql/sql_derived.cc:201
|
#3 0x5572dbbb341a in TABLE_LIST::handle_derived(LEX*, unsigned int) /10.4/sql/table.cc:8317
|
#4 0x5572db887191 in st_select_lex::handle_derived(LEX*, unsigned int) /10.4/sql/sql_lex.cc:4194
|
#5 0x5572dbbb33cf in TABLE_LIST::handle_derived(LEX*, unsigned int) /10.4/sql/table.cc:8314
|
#6 0x5572db887191 in st_select_lex::handle_derived(LEX*, unsigned int) /10.4/sql/sql_lex.cc:4194
|
#7 0x5572db989a8f in JOIN::optimize_stage2() /10.4/sql/sql_select.cc:2174
|
#8 0x5572db9895b7 in JOIN::optimize_inner() /10.4/sql/sql_select.cc:2147
|
#9 0x5572db983562 in JOIN::optimize() /10.4/sql/sql_select.cc:1508
|
#10 0x5572db9a0570 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*) /10.4/sql/sql_select.cc:4518
|
#11 0x5572db978647 in handle_select(THD*, LEX*, select_result*, unsigned long) /10.4/sql/sql_select.cc:423
|
#12 0x5572db8fd221 in execute_sqlcom_select /10.4/sql/sql_parse.cc:6588
|
#13 0x5572db8e9fd3 in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:3825
|
#14 0x5572db9056fe in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:8141
|
#15 0x5572db8de290 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1820
|
#16 0x5572db8db2b2 in do_command(THD*) /10.4/sql/sql_parse.cc:1358
|
#17 0x5572dbc456f7 in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1399
|
#18 0x5572dbc450c1 in handle_one_connection /10.4/sql/sql_connect.cc:1302
|
#19 0x5572dcffa92c in pfs_spawn_thread /10.4/storage/perfschema/pfs.cc:1862
|
#20 0x7f0852c236b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)
|
#21 0x7f0851eb441c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)
|
{"report":{"fcp":878.8000001907349,"ttfb":154,"pageVisibility":"visible","entityId":72753,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"3306a939-73c6-40f7-8fd5-0658005efc94","navigationType":0,"readyForUser":959.1000003814697,"redirectCount":0,"resourceLoadedEnd":940.1000003814697,"resourceLoadedStart":159.30000019073486,"resourceTiming":[{"duration":238,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":159.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":159.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":397.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":237.69999980926514,"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":159.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":159.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":397.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":246.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":159.69999980926514,"connectEnd":159.69999980926514,"connectStart":159.69999980926514,"domainLookupEnd":159.69999980926514,"domainLookupStart":159.69999980926514,"fetchStart":159.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":159.69999980926514,"responseEnd":406.30000019073486,"responseStart":406.30000019073486,"secureConnectionStart":159.69999980926514},{"duration":355.19999980926514,"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":159.9000005722046,"connectEnd":159.9000005722046,"connectStart":159.9000005722046,"domainLookupEnd":159.9000005722046,"domainLookupStart":159.9000005722046,"fetchStart":159.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":159.9000005722046,"responseEnd":515.1000003814697,"responseStart":515.1000003814697,"secureConnectionStart":159.9000005722046},{"duration":358.5,"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":160.10000038146973,"connectEnd":160.10000038146973,"connectStart":160.10000038146973,"domainLookupEnd":160.10000038146973,"domainLookupStart":160.10000038146973,"fetchStart":160.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":160.10000038146973,"responseEnd":518.6000003814697,"responseStart":518.6000003814697,"secureConnectionStart":160.10000038146973},{"duration":358.80000019073486,"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":160.10000038146973,"connectEnd":160.10000038146973,"connectStart":160.10000038146973,"domainLookupEnd":160.10000038146973,"domainLookupStart":160.10000038146973,"fetchStart":160.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":160.10000038146973,"responseEnd":518.9000005722046,"responseStart":518.9000005722046,"secureConnectionStart":160.10000038146973},{"duration":359.1000003814697,"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":160.19999980926514,"connectEnd":160.19999980926514,"connectStart":160.19999980926514,"domainLookupEnd":160.19999980926514,"domainLookupStart":160.19999980926514,"fetchStart":160.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":160.19999980926514,"responseEnd":519.3000001907349,"responseStart":519.3000001907349,"secureConnectionStart":160.19999980926514},{"duration":359.5,"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":160.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":160.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":519.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":359.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":160.4000005722046,"connectEnd":160.4000005722046,"connectStart":160.4000005722046,"domainLookupEnd":160.4000005722046,"domainLookupStart":160.4000005722046,"fetchStart":160.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":160.4000005722046,"responseEnd":519.8000001907349,"responseStart":519.8000001907349,"secureConnectionStart":160.4000005722046},{"duration":359.69999980926514,"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":160.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":160.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":520.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":359.6000003814697,"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":160.69999980926514,"connectEnd":160.69999980926514,"connectStart":160.69999980926514,"domainLookupEnd":160.69999980926514,"domainLookupStart":160.69999980926514,"fetchStart":160.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":160.69999980926514,"responseEnd":520.3000001907349,"responseStart":520.3000001907349,"secureConnectionStart":160.69999980926514},{"duration":451,"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":165.80000019073486,"connectEnd":165.80000019073486,"connectStart":165.80000019073486,"domainLookupEnd":165.80000019073486,"domainLookupStart":165.80000019073486,"fetchStart":165.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":165.80000019073486,"responseEnd":616.8000001907349,"responseStart":616.8000001907349,"secureConnectionStart":165.80000019073486},{"duration":774.1999998092651,"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":165.9000005722046,"connectEnd":165.9000005722046,"connectStart":165.9000005722046,"domainLookupEnd":165.9000005722046,"domainLookupStart":165.9000005722046,"fetchStart":165.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":165.9000005722046,"responseEnd":940.1000003814697,"responseStart":940.1000003814697,"secureConnectionStart":165.9000005722046},{"duration":59.59999942779541,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":558.1000003814697,"connectEnd":558.1000003814697,"connectStart":558.1000003814697,"domainLookupEnd":558.1000003814697,"domainLookupStart":558.1000003814697,"fetchStart":558.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":558.1000003814697,"responseEnd":617.6999998092651,"responseStart":617.6999998092651,"secureConnectionStart":558.1000003814697}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":16,"responseStart":154,"responseEnd":158,"domLoading":157,"domInteractive":1016,"domContentLoadedEventStart":1016,"domContentLoadedEventEnd":1064,"domComplete":1879,"loadEventStart":1879,"loadEventEnd":1880,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":996.6000003814697},{"name":"bigPipe.sidebar-id.end","time":997.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":997.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1000.4000005722046},{"name":"activityTabFullyLoaded","time":1077.1000003814697}],"measures":[],"correlationId":"53188c2f599c97","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":66,"dbReadsTimeInMs":8,"dbConnsTimeInMs":14,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}