Reproducible on 10.3 with UNION, INTERSECT, EXCEPT.
Not reproducible with UNION on 10.2.
CREATE TABLE t1 (c1 CHAR(8));
|
INSERT INTO t1 VALUES ('10'),('-10');
|
|
CREATE TABLE t2 (c2 CHAR);
|
SET @a= CAST('10' AS CHAR);
|
|
SELECT c1 FROM t1 UNION SELECT - @a FROM t2;
|
10.3 176000a54ceb8dabe8f8b985aff565dfae6fb0df
|
2017-07-02 20:48:12 139766304167680 [ERROR] mysqld: Table '/data/bld/10.3/mysql-test/var/tmp/mysqld.1/#sql_1f02_0' is marked as crashed and should be repaired
|
mysqld: /data/src/10.3/storage/maria/ma_open.c:1369: _ma_state_info_write: Assertion `(&(&share->intern_lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&share->intern_lock)->m_mutex)->thread)' failed.
|
170702 20:48:12 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f1de6bfdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000563e55783d47 in _ma_state_info_write (share=0x7f1dd0062650, pWrite=1) at /data/src/10.3/storage/maria/ma_open.c:1369
|
#9 0x0000563e557c5b6c in maria_close (info=0x7f1dd00636b0) at /data/src/10.3/storage/maria/ma_close.c:146
|
#10 0x0000563e5574221a in ha_maria::close (this=0x7f1dd0041d78) at /data/src/10.3/storage/maria/ha_maria.cc:1274
|
#11 0x0000563e5553e293 in handler::ha_close (this=0x7f1dd0041d78) at /data/src/10.3/sql/handler.cc:2544
|
#12 0x0000563e55746754 in ha_maria::drop_table (this=0x7f1dd0041d78, name=0x7f1dd007f0c8 "/data/bld/10.3/mysql-test/var/tmp/mysqld.1/#sql_1f02_0") at /data/src/10.3/storage/maria/ha_maria.cc:2680
|
#13 0x0000563e55542b68 in handler::ha_drop_table (this=0x7f1dd0041d78, name=0x7f1dd007f0c8 "/data/bld/10.3/mysql-test/var/tmp/mysqld.1/#sql_1f02_0") at /data/src/10.3/sql/handler.cc:4325
|
#14 0x0000563e552f7415 in free_tmp_table (thd=0x7f1dd0000b00, entry=0x7f1dd007de08) at /data/src/10.3/sql/sql_select.cc:17779
|
#15 0x0000563e55371a2f in st_select_lex_unit::cleanup (this=0x7f1dd0004698) at /data/src/10.3/sql/sql_union.cc:1760
|
#16 0x0000563e5536bf8b in mysql_union (thd=0x7f1dd0000b00, lex=0x7f1dd00045d0, result=0x7f1dd0016218, unit=0x7f1dd0004698, setup_tables_done_option=0) at /data/src/10.3/sql/sql_union.cc:42
|
#17 0x0000563e552c76b0 in handle_select (thd=0x7f1dd0000b00, lex=0x7f1dd00045d0, result=0x7f1dd0016218, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:351
|
#18 0x0000563e552938b5 in execute_sqlcom_select (thd=0x7f1dd0000b00, all_tables=0x7f1dd0014b10) at /data/src/10.3/sql/sql_parse.cc:6476
|
#19 0x0000563e55289c43 in mysql_execute_command (thd=0x7f1dd0000b00) at /data/src/10.3/sql/sql_parse.cc:3590
|
#20 0x0000563e55297306 in mysql_parse (thd=0x7f1dd0000b00, rawbuf=0x7f1dd00148e8 "SELECT c1 FROM t1 UNION SELECT - @a FROM t2", length=43, parser_state=0x7f1de0e94200, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7932
|
#21 0x0000563e55284f93 in dispatch_command (command=COM_QUERY, thd=0x7f1dd0000b00, packet=0x7f1dd0088521 "", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1822
|
#22 0x0000563e5528390d in do_command (thd=0x7f1dd0000b00) at /data/src/10.3/sql/sql_parse.cc:1380
|
#23 0x0000563e553d17e4 in do_handle_one_connection (connect=0x563e58852bb0) at /data/src/10.3/sql/sql_connect.cc:1354
|
#24 0x0000563e553d1571 in handle_one_connection (arg=0x563e58852bb0) at /data/src/10.3/sql/sql_connect.cc:1260
|
#25 0x0000563e5582eb2f in pfs_spawn_thread (arg=0x563e587ada60) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#26 0x00007f1de8b42494 in start_thread (arg=0x7f1de0e95700) at pthread_create.c:333
|
#27 0x00007f1de6cba93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
{"report":{"fcp":964.6999999880791,"ttfb":256.39999997615814,"pageVisibility":"visible","entityId":62129,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d7196ed4-fae1-4825-89ca-76d9fcafd495","navigationType":0,"readyForUser":1088.0999999642372,"redirectCount":0,"resourceLoadedEnd":1200,"resourceLoadedStart":263.0999999642372,"resourceTiming":[{"duration":216.30000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":263.0999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":263.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":479.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":216.4000000357628,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":263.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":263.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":479.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":225.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":263.5,"connectEnd":263.5,"connectStart":263.5,"domainLookupEnd":263.5,"domainLookupStart":263.5,"fetchStart":263.5,"redirectEnd":0,"redirectStart":0,"requestStart":263.5,"responseEnd":488.69999998807907,"responseStart":488.69999998807907,"secureConnectionStart":263.5},{"duration":294.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":263.69999998807907,"connectEnd":263.69999998807907,"connectStart":263.69999998807907,"domainLookupEnd":263.69999998807907,"domainLookupStart":263.69999998807907,"fetchStart":263.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":263.69999998807907,"responseEnd":557.8999999761581,"responseStart":557.8999999761581,"secureConnectionStart":263.69999998807907},{"duration":297.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":263.89999997615814,"connectEnd":263.89999997615814,"connectStart":263.89999997615814,"domainLookupEnd":263.89999997615814,"domainLookupStart":263.89999997615814,"fetchStart":263.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":263.89999997615814,"responseEnd":561.7999999523163,"responseStart":561.7999999523163,"secureConnectionStart":263.89999997615814},{"duration":298.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":264.0999999642372,"connectEnd":264.0999999642372,"connectStart":264.0999999642372,"domainLookupEnd":264.0999999642372,"domainLookupStart":264.0999999642372,"fetchStart":264.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":264.0999999642372,"responseEnd":562.7999999523163,"responseStart":562.7999999523163,"secureConnectionStart":264.0999999642372},{"duration":299.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":264.19999998807907,"connectEnd":264.19999998807907,"connectStart":264.19999998807907,"domainLookupEnd":264.19999998807907,"domainLookupStart":264.19999998807907,"fetchStart":264.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":264.19999998807907,"responseEnd":563.6999999880791,"responseStart":563.6999999880791,"secureConnectionStart":264.19999998807907},{"duration":365.89999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":264.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":264.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":630.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":300,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":264.5999999642372,"connectEnd":264.5999999642372,"connectStart":264.5999999642372,"domainLookupEnd":264.5999999642372,"domainLookupStart":264.5999999642372,"fetchStart":264.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":264.5999999642372,"responseEnd":564.5999999642372,"responseStart":564.5999999642372,"secureConnectionStart":264.5999999642372},{"duration":365.80000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":264.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":264.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":630.5999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":300.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":265,"connectEnd":265,"connectStart":265,"domainLookupEnd":265,"domainLookupStart":265,"fetchStart":265,"redirectEnd":0,"redirectStart":0,"requestStart":265,"responseEnd":565.1999999880791,"responseStart":565.1999999880791,"secureConnectionStart":265},{"duration":431.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":290.0999999642372,"connectEnd":290.0999999642372,"connectStart":290.0999999642372,"domainLookupEnd":290.0999999642372,"domainLookupStart":290.0999999642372,"fetchStart":290.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":290.0999999642372,"responseEnd":721.6999999880791,"responseStart":721.6999999880791,"secureConnectionStart":290.0999999642372},{"duration":909.8000000119209,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":290.19999998807907,"connectEnd":290.19999998807907,"connectStart":290.19999998807907,"domainLookupEnd":290.19999998807907,"domainLookupStart":290.19999998807907,"fetchStart":290.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":290.19999998807907,"responseEnd":1200,"responseStart":1200,"secureConnectionStart":290.19999998807907},{"duration":80.70000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":641.7999999523163,"connectEnd":641.7999999523163,"connectStart":641.7999999523163,"domainLookupEnd":641.7999999523163,"domainLookupStart":641.7999999523163,"fetchStart":641.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":641.7999999523163,"responseEnd":722.5,"responseStart":722.5,"secureConnectionStart":641.7999999523163},{"duration":348.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":913.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":913.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1261.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":317.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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":914.2999999523163,"connectEnd":914.2999999523163,"connectStart":914.2999999523163,"domainLookupEnd":914.2999999523163,"domainLookupStart":914.2999999523163,"fetchStart":914.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":914.2999999523163,"responseEnd":1231.5999999642372,"responseStart":1231.5999999642372,"secureConnectionStart":914.2999999523163},{"duration":324.0999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":914.6999999880791,"connectEnd":914.6999999880791,"connectStart":914.6999999880791,"domainLookupEnd":914.6999999880791,"domainLookupStart":914.6999999880791,"fetchStart":914.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":914.6999999880791,"responseEnd":1238.7999999523163,"responseStart":1238.7999999523163,"secureConnectionStart":914.6999999880791}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":67,"responseStart":257,"responseEnd":290,"domLoading":262,"domInteractive":1219,"domContentLoadedEventStart":1219,"domContentLoadedEventEnd":1262,"domComplete":2423,"loadEventStart":2423,"loadEventEnd":2425,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1202.3999999761581},{"name":"bigPipe.sidebar-id.end","time":1203.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1203.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1205.8999999761581},{"name":"activityTabFullyLoaded","time":1273.699999988079}],"measures":[],"correlationId":"c86e157893f714","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":106,"dbReadsTimeInMs":19,"dbConnsTimeInMs":28,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}