CREATE TABLE t1 (a INT);
|
CREATE TABLE t2 (b INT);
|
CREATE VIEW v AS SELECT * FROM t1 JOIN t2;
|
--error ER_NO_SUCH_TABLE
|
INSERT INTO t1 SELECT * FROM x;
|
SELECT * FROM information_schema.tables;
|
|
# Cleanup
|
DROP VIEW v;
|
DROP TABLE t1, t2;
|
10.4 81f6a3b0
|
#3 <signal handler called>
|
#4 0x000056230487eecc in alloc_histograms_for_table_share (thd=0x7f1744000b00, table_share=0x7f174414c508, is_safe=false) at /data/src/10.4/sql/sql_statistics.cc:2446
|
#5 0x0000562304880a36 in read_histograms_for_table (thd=0x7f1744000b00, table=0x7f174414eae0, stat_tables=0x7f17540604e0) at /data/src/10.4/sql/sql_statistics.cc:3292
|
#6 0x0000562304880e8a in read_statistics_for_tables_if_needed (thd=0x7f1744000b00, tables=0x7f1744043c38) at /data/src/10.4/sql/sql_statistics.cc:3374
|
#7 0x0000562304865694 in fill_schema_table_by_open (thd=0x7f1744000b00, mem_root=0x7f1754063680, is_show_fields_or_keys=false, table=0x7f1744157e18, schema_table=0x562305e48080 <schema_tables+2048>, orig_db_name=0x7f1744133408, orig_table_name=0x7f1744133460, open_tables_state_backup=0x7f17540636d0, can_deadlock=false) at /data/src/10.4/sql/sql_show.cc:4645
|
#8 0x0000562304866fa9 in get_all_tables (thd=0x7f1744000b00, tables=0x7f1744015c60, cond=0x0) at /data/src/10.4/sql/sql_show.cc:5284
|
#9 0x000056230487803b in get_schema_tables_result (join=0x7f17440186c8, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.4/sql/sql_show.cc:8878
|
#10 0x000056230480cf98 in JOIN::exec_inner (this=0x7f17440186c8) at /data/src/10.4/sql/sql_select.cc:4346
|
#11 0x000056230480c41e in JOIN::exec (this=0x7f17440186c8) at /data/src/10.4/sql/sql_select.cc:4171
|
#12 0x000056230480dad0 in mysql_select (thd=0x7f1744000b00, tables=0x7f1744015c60, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f17440186a0, unit=0x7f1744004a28, select_lex=0x7f1744015688) at /data/src/10.4/sql/sql_select.cc:4603
|
#13 0x00005623047fe040 in handle_select (thd=0x7f1744000b00, lex=0x7f1744004960, result=0x7f17440186a0, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:424
|
#14 0x00005623047c78d9 in execute_sqlcom_select (thd=0x7f1744000b00, all_tables=0x7f1744015c60) at /data/src/10.4/sql/sql_parse.cc:6597
|
#15 0x00005623047bceaf in mysql_execute_command (thd=0x7f1744000b00) at /data/src/10.4/sql/sql_parse.cc:3886
|
#16 0x00005623047cb65f in mysql_parse (thd=0x7f1744000b00, rawbuf=0x7f17440155d8 "SELECT * FROM information_schema.tables", length=39, parser_state=0x7f1754065180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8149
|
#17 0x00005623047b70b6 in dispatch_command (command=COM_QUERY, thd=0x7f1744000b00, packet=0x7f17441398f1 "SELECT * FROM information_schema.tables", packet_length=39, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1828
|
#18 0x00005623047b589c in do_command (thd=0x7f1744000b00) at /data/src/10.4/sql/sql_parse.cc:1361
|
#19 0x000056230492dcad in do_handle_one_connection (connect=0x562307a58530) at /data/src/10.4/sql/sql_connect.cc:1398
|
#20 0x000056230492da1e in handle_one_connection (arg=0x562307a58530) at /data/src/10.4/sql/sql_connect.cc:1301
|
#21 0x0000562304d52d9d in pfs_spawn_thread (arg=0x562307b5c060) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#22 0x00007f175bf86494 in start_thread (arg=0x7f1754066700) at pthread_create.c:333
|
#23 0x00007f1759f4e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
All of debug, ASAN and non-debug builds are affected.
The problem appeared in 10.4 after this merge:
commit e6bdf77e4be48750c4808a09af197ed91fd69a61
|
Merge: 1599825 acf6f92
|
Author: Marko Mäkelä
|
Date: Thu Apr 25 16:05:20 2019 +0300
|
|
Merge 10.3 into 10.4
|
|
In is_eits_usable(), we disable an assertion that fails due to
|
MDEV-19334.
|
Note: Even though the problem appeared after the merge above, I can't reproduce it on 10.3 even with all 10.4-specific optimizer options I can think of:
perl ./mtr bug.2230 --mysqld=--optimizer-use-condition-selectivity=4 --mysqld=--use-stat-tables=PREFERABLY --mysqld=--histogram-size=254 --mysqld=--histogram-type=DOUBLE_PREC_HB
|
|
...
|
bug.2230 [ pass ] 114
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 0.114 of 9 seconds executing testcases
|
|
Completed: All 1 tests were successful.
|
{"report":{"fcp":756.5,"ttfb":158.89999985694885,"pageVisibility":"visible","entityId":75636,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"c988ceeb-37e7-46bd-9b43-920a11425f67","navigationType":0,"readyForUser":843.1999998092651,"redirectCount":0,"resourceLoadedEnd":891.3999998569489,"resourceLoadedStart":164.69999980926514,"resourceTiming":[{"duration":69.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":164.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":164.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":234.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":69.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":165,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":165,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":234.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":99.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":165.19999980926514,"connectEnd":165.19999980926514,"connectStart":165.19999980926514,"domainLookupEnd":165.19999980926514,"domainLookupStart":165.19999980926514,"fetchStart":165.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":165.19999980926514,"responseEnd":264.89999985694885,"responseStart":264.89999985694885,"secureConnectionStart":165.19999980926514},{"duration":213.59999990463257,"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":165.29999995231628,"connectEnd":165.29999995231628,"connectStart":165.29999995231628,"domainLookupEnd":165.29999995231628,"domainLookupStart":165.29999995231628,"fetchStart":165.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":165.29999995231628,"responseEnd":378.89999985694885,"responseStart":378.89999985694885,"secureConnectionStart":165.29999995231628},{"duration":218,"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":165.39999985694885,"connectEnd":165.39999985694885,"connectStart":165.39999985694885,"domainLookupEnd":165.39999985694885,"domainLookupStart":165.39999985694885,"fetchStart":165.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":165.39999985694885,"responseEnd":383.39999985694885,"responseStart":383.39999985694885,"secureConnectionStart":165.39999985694885},{"duration":218.39999985694885,"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":165.5,"connectEnd":165.5,"connectStart":165.5,"domainLookupEnd":165.5,"domainLookupStart":165.5,"fetchStart":165.5,"redirectEnd":0,"redirectStart":0,"requestStart":165.5,"responseEnd":383.89999985694885,"responseStart":383.89999985694885,"secureConnectionStart":165.5},{"duration":218.70000004768372,"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":165.59999990463257,"connectEnd":165.59999990463257,"connectStart":165.59999990463257,"domainLookupEnd":165.59999990463257,"domainLookupStart":165.59999990463257,"fetchStart":165.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":165.59999990463257,"responseEnd":384.2999999523163,"responseStart":384.2999999523163,"secureConnectionStart":165.59999990463257},{"duration":219.20000004768372,"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":165.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":165.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":384.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":219.10000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":165.69999980926514,"connectEnd":165.69999980926514,"connectStart":165.69999980926514,"domainLookupEnd":165.69999980926514,"domainLookupStart":165.69999980926514,"fetchStart":165.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":165.69999980926514,"responseEnd":384.7999999523163,"responseStart":384.7999999523163,"secureConnectionStart":165.69999980926514},{"duration":219.70000004768372,"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":165.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":165.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":385.5,"responseStart":0,"secureConnectionStart":0},{"duration":219.60000014305115,"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":165.89999985694885,"connectEnd":165.89999985694885,"connectStart":165.89999985694885,"domainLookupEnd":165.89999985694885,"domainLookupStart":165.89999985694885,"fetchStart":165.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":165.89999985694885,"responseEnd":385.5,"responseStart":385.5,"secureConnectionStart":165.89999985694885},{"duration":422.39999985694885,"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":171.29999995231628,"connectEnd":171.29999995231628,"connectStart":171.29999995231628,"domainLookupEnd":171.29999995231628,"domainLookupStart":171.29999995231628,"fetchStart":171.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":171.29999995231628,"responseEnd":593.6999998092651,"responseStart":593.6999998092651,"secureConnectionStart":171.29999995231628},{"duration":512.4000000953674,"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":171.39999985694885,"connectEnd":171.39999985694885,"connectStart":171.39999985694885,"domainLookupEnd":171.39999985694885,"domainLookupStart":171.39999985694885,"fetchStart":171.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":171.39999985694885,"responseEnd":683.7999999523163,"responseStart":683.7999999523163,"secureConnectionStart":171.39999985694885},{"duration":176.39999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":417.7999999523163,"connectEnd":417.7999999523163,"connectStart":417.7999999523163,"domainLookupEnd":417.7999999523163,"domainLookupStart":417.7999999523163,"fetchStart":417.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":417.7999999523163,"responseEnd":594.1999998092651,"responseStart":594.1999998092651,"secureConnectionStart":417.7999999523163},{"duration":236.89999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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","startTime":654.5,"connectEnd":654.5,"connectStart":654.5,"domainLookupEnd":654.5,"domainLookupStart":654.5,"fetchStart":654.5,"redirectEnd":0,"redirectStart":0,"requestStart":654.5,"responseEnd":891.3999998569489,"responseStart":891.2999999523163,"secureConnectionStart":654.5},{"duration":170.39999985694885,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":749.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":749.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":919.6999998092651,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":32,"responseStart":159,"responseEnd":167,"domLoading":162,"domInteractive":907,"domContentLoadedEventStart":907,"domContentLoadedEventEnd":962,"domComplete":2027,"loadEventStart":2027,"loadEventEnd":2028,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":883.0999999046326},{"name":"bigPipe.sidebar-id.end","time":884},{"name":"bigPipe.activity-panel-pipe-id.start","time":884.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":886.7999999523163},{"name":"activityTabFullyLoaded","time":969.1999998092651}],"measures":[],"correlationId":"ce3ae2cf763de9","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":67,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}