CREATE TABLE t1 (a INT) ENGINE=MyISAM;
|
|
CREATE TABLE t2 (pk INT, b INT, PRIMARY KEY (pk)) ENGINE=MyISAM;
|
INSERT INTO t2 VALUES (1,2),(3,4);
|
|
CREATE ALGORITHM = MERGE VIEW v2 AS SELECT pk, MIN(b) FROM t2 GROUP BY pk;
|
SELECT * FROM t1 LEFT JOIN v2 ON (a = pk);
|
10.3 ec32c050726
|
#3 <signal handler called>
|
#4 0x000055dc892569b3 in st_join_table::fix_splitting (this=0x7eff1003acb0, spl_plan=0xa5a5a5a5a5a5a5a5, remaining_tables=2) at /data/src/10.3/sql/opt_split.cc:1082
|
#5 0x000055dc89256ae2 in JOIN::fix_all_splittings_in_plan (this=0x7eff100191b8) at /data/src/10.3/sql/opt_split.cc:1128
|
#6 0x000055dc890a99e1 in JOIN::get_best_combination (this=0x7eff100191b8) at /data/src/10.3/sql/sql_select.cc:9472
|
#7 0x000055dc890939cf in JOIN::optimize_stage2 (this=0x7eff100191b8) at /data/src/10.3/sql/sql_select.cc:1993
|
#8 0x000055dc890938e1 in JOIN::optimize_inner (this=0x7eff100191b8) at /data/src/10.3/sql/sql_select.cc:1972
|
#9 0x000055dc890920e1 in JOIN::optimize (this=0x7eff100191b8) at /data/src/10.3/sql/sql_select.cc:1544
|
#10 0x000055dc8909b89c in mysql_select (thd=0x7eff10000b00, tables=0x7eff10014e50, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7eff10019198, unit=0x7eff10004890, select_lex=0x7eff10004fe8) at /data/src/10.3/sql/sql_select.cc:4236
|
#11 0x000055dc8908d88a in handle_select (thd=0x7eff10000b00, lex=0x7eff100047c8, result=0x7eff10019198, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
|
#12 0x000055dc89058956 in execute_sqlcom_select (thd=0x7eff10000b00, all_tables=0x7eff10014e50) at /data/src/10.3/sql/sql_parse.cc:6524
|
#13 0x000055dc8904f040 in mysql_execute_command (thd=0x7eff10000b00) at /data/src/10.3/sql/sql_parse.cc:3745
|
#14 0x000055dc8905c2aa in mysql_parse (thd=0x7eff10000b00, rawbuf=0x7eff10014c38 "SELECT * FROM t1 LEFT JOIN v2 ON (a = pk)", length=41, parser_state=0x7eff205525f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
|
#15 0x000055dc89049aef in dispatch_command (command=COM_QUERY, thd=0x7eff10000b00, packet=0x7eff1000b141 "SELECT * FROM t1 LEFT JOIN v2 ON (a = pk)", packet_length=41, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
|
#16 0x000055dc89048523 in do_command (thd=0x7eff10000b00) at /data/src/10.3/sql/sql_parse.cc:1370
|
#17 0x000055dc891af768 in do_handle_one_connection (connect=0x55dc8cb76ec0) at /data/src/10.3/sql/sql_connect.cc:1401
|
#18 0x000055dc891af4f5 in handle_one_connection (arg=0x55dc8cb76ec0) at /data/src/10.3/sql/sql_connect.cc:1307
|
#19 0x000055dc8964d0b8 in pfs_spawn_thread (arg=0x55dc8cb926a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#20 0x00007eff27fba494 in start_thread (arg=0x7eff20553700) at pthread_create.c:333
|
#21 0x00007eff263a093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
- relates to
-
MDEV-14994
Assertion `join->best_read < double(1.79...15e+308L)' or server crash in JOIN::fix_all_splittings_in_plan
-
-
Closed
{"report":{"fcp":960.0999999046326,"ttfb":316.09999990463257,"pageVisibility":"visible","entityId":65364,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"12ff5275-af0d-4edb-b421-2e104328a9ff","navigationType":0,"readyForUser":1078.9000000953674,"redirectCount":0,"resourceLoadedEnd":709.6999998092651,"resourceLoadedStart":323.40000009536743,"resourceTiming":[{"duration":108.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":323.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":323.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":432,"responseStart":0,"secureConnectionStart":0},{"duration":108.69999980926514,"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":323.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":323.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":432.5,"responseStart":0,"secureConnectionStart":0},{"duration":236.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":324,"connectEnd":434.90000009536743,"connectStart":434.90000009536743,"domainLookupEnd":434.90000009536743,"domainLookupStart":434.90000009536743,"fetchStart":324,"redirectEnd":0,"redirectStart":0,"requestStart":435.19999980926514,"responseEnd":560.1999998092651,"responseStart":447.59999990463257,"secureConnectionStart":434.90000009536743},{"duration":356.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":324.09999990463257,"connectEnd":324.09999990463257,"connectStart":324.09999990463257,"domainLookupEnd":324.09999990463257,"domainLookupStart":324.09999990463257,"fetchStart":324.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":436.69999980926514,"responseEnd":680.5999999046326,"responseStart":456.30000019073486,"secureConnectionStart":324.09999990463257},{"duration":134.59999990463257,"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":324.30000019073486,"connectEnd":324.30000019073486,"connectStart":324.30000019073486,"domainLookupEnd":324.30000019073486,"domainLookupStart":324.30000019073486,"fetchStart":324.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":436.90000009536743,"responseEnd":458.90000009536743,"responseStart":454.30000019073486,"secureConnectionStart":324.30000019073486},{"duration":134.59999990463257,"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":324.5,"connectEnd":324.5,"connectStart":324.5,"domainLookupEnd":324.5,"domainLookupStart":324.5,"fetchStart":324.5,"redirectEnd":0,"redirectStart":0,"requestStart":437.90000009536743,"responseEnd":459.09999990463257,"responseStart":455.30000019073486,"secureConnectionStart":324.5},{"duration":136.40000009536743,"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":324.69999980926514,"connectEnd":324.69999980926514,"connectStart":324.69999980926514,"domainLookupEnd":324.69999980926514,"domainLookupStart":324.69999980926514,"fetchStart":324.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":439.69999980926514,"responseEnd":461.09999990463257,"responseStart":459.59999990463257,"secureConnectionStart":324.69999980926514},{"duration":113.2999997138977,"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":324.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":324.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":438.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":182.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":325,"connectEnd":325,"connectStart":325,"domainLookupEnd":325,"domainLookupStart":325,"fetchStart":325,"redirectEnd":0,"redirectStart":0,"requestStart":441.09999990463257,"responseEnd":507.30000019073486,"responseStart":506,"secureConnectionStart":325},{"duration":115.2000002861023,"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":325.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":325.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":440.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":140.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":325.30000019073486,"connectEnd":325.30000019073486,"connectStart":325.30000019073486,"domainLookupEnd":325.30000019073486,"domainLookupStart":325.30000019073486,"fetchStart":325.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":442.40000009536743,"responseEnd":465.40000009536743,"responseStart":461.40000009536743,"secureConnectionStart":325.30000019073486},{"duration":371.80000019073486,"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":337.09999990463257,"connectEnd":337.09999990463257,"connectStart":337.09999990463257,"domainLookupEnd":337.09999990463257,"domainLookupStart":337.09999990463257,"fetchStart":337.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":553.9000000953674,"responseEnd":708.9000000953674,"responseStart":703.8000001907349,"secureConnectionStart":337.09999990463257},{"duration":372.5,"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":337.19999980926514,"connectEnd":337.19999980926514,"connectStart":337.19999980926514,"domainLookupEnd":337.19999980926514,"domainLookupStart":337.19999980926514,"fetchStart":337.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":650.4000000953674,"responseEnd":709.6999998092651,"responseStart":705.6999998092651,"secureConnectionStart":337.19999980926514},{"duration":124.09999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":690.5999999046326,"connectEnd":690.5999999046326,"connectStart":690.5999999046326,"domainLookupEnd":690.5999999046326,"domainLookupStart":690.5999999046326,"fetchStart":690.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":778.9000000953674,"responseEnd":814.6999998092651,"responseStart":813.9000000953674,"secureConnectionStart":690.5999999046326},{"duration":273.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":915.5,"connectEnd":915.5,"connectStart":915.5,"domainLookupEnd":915.5,"domainLookupStart":915.5,"fetchStart":915.5,"redirectEnd":0,"redirectStart":0,"requestStart":1156.0999999046326,"responseEnd":1188.8000001907349,"responseStart":1187.8000001907349,"secureConnectionStart":915.5}],"fetchStart":1,"domainLookupStart":110,"domainLookupEnd":129,"connectStart":129,"connectEnd":147,"secureConnectionStart":137,"requestStart":148,"responseStart":317,"responseEnd":340,"domLoading":320,"domInteractive":1135,"domContentLoadedEventStart":1136,"domContentLoadedEventEnd":1185,"domComplete":1777,"loadEventStart":1777,"loadEventEnd":1777,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1115.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1116.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1116.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1117.3000001907349},{"name":"activityTabFullyLoaded","time":1204.3000001907349}],"measures":[],"correlationId":"dbcb33db338e04","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Reproducible after commit 1e8a81dea67a66