CREATE TABLE t1 (i INT );
INSERT INTO t1 VALUES (1),(2);
SELECT Nth_value(i,1) OVER() FROM t1
UNION ALL
( SELECT Nth_value(i,2) OVER() FROM t1 LIMIT 0 )
;
10.2 bc75c57cfc18be64f167d91c431076f581b0382b
#3 <signal handler called>
#4 0x00007f66354d542f in st_select_lex::set_explain_type (this=0x7f661c012f88, on_the_fly=true) at /data/src/10.2/sql/sql_lex.cc:4401
#5 0x00007f66355622d0 in JOIN::save_explain_data_intern (this=0x7f661c014dc0, output=0x7f661c017510, need_tmp_table_arg=true, need_order_arg=false, distinct_arg=false, message=0x7f6635f55d8e "Impossible WHERE") at /data/src/10.2/sql/sql_select.cc:24668
#6 0x00007f663552b7bd in JOIN::save_explain_data (this=0x7f661c014dc0, output=0x7f661c017510, can_overwrite=false, need_tmp_table=true, need_order=false, distinct=false) at /data/src/10.2/sql/sql_select.cc:3240
#7 0x00007f6635523cae in JOIN::optimize (this=0x7f661c014dc0) at /data/src/10.2/sql/sql_select.cc:1093
#8 0x00007f66355c8962 in st_select_lex_unit::optimize (this=0x7f661c0045e8) at /data/src/10.2/sql/sql_union.cc:906
#9 0x00007f66355c8b99 in st_select_lex_unit::exec (this=0x7f661c0045e8) at /data/src/10.2/sql/sql_union.cc:940
#10 0x00007f66355c5aba in mysql_union (thd=0x7f661c000b00, lex=0x7f661c004520, result=0x7f661c014390, unit=0x7f661c0045e8, setup_tables_done_option=0) at /data/src/10.2/sql/sql_union.cc:41
#11 0x00007f6635521430 in handle_select (thd=0x7f661c000b00, lex=0x7f661c004520, result=0x7f661c014390, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:351
#12 0x00007f66354ed3c8 in execute_sqlcom_select (thd=0x7f661c000b00, all_tables=0x7f661c012960) at /data/src/10.2/sql/sql_parse.cc:6443
#13 0x00007f66354e3407 in mysql_execute_command (thd=0x7f661c000b00) at /data/src/10.2/sql/sql_parse.cc:3458
#14 0x00007f66354f0d88 in mysql_parse (thd=0x7f661c000b00, rawbuf=0x7f661c012378 "SELECT Nth_value(i,1) OVER() FROM t1 \nUNION ALL \n( SELECT Nth_value(i,2) OVER() FROM t1 LIMIT 0 )", length=97, parser_state=0x7f662d0da200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879
#15 0x00007f66354dee34 in dispatch_command (command=COM_QUERY, thd=0x7f661c000b00, packet=0x7f661c168011 "SELECT Nth_value(i,1) OVER() FROM t1 \nUNION ALL \n( SELECT Nth_value(i,2) OVER() FROM t1 LIMIT 0 )\n", packet_length=98, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817
#16 0x00007f66354dd775 in do_command (thd=0x7f661c000b00) at /data/src/10.2/sql/sql_parse.cc:1362
#17 0x00007f66356294e7 in do_handle_one_connection (connect=0x7f66383f6760) at /data/src/10.2/sql/sql_connect.cc:1354
#18 0x00007f6635629274 in handle_one_connection (arg=0x7f66383f6760) at /data/src/10.2/sql/sql_connect.cc:1260
#19 0x00007f6635970922 in pfs_spawn_thread (arg=0x7f6638498f40) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#20 0x00007f6634b00064 in start_thread (arg=0x7f662d0db700) at pthread_create.c:309
#21 0x00007f6632ce562d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Sergei Petrunia
made changes -
2017-07-21 17:06
Field
Original Value
New Value
Assignee
Vicentiu Ciorbaru
[ cvicentiu
]
Sergei Petrunia
[ psergey
]
Sergei Petrunia
made changes -
2017-07-21 17:09
Fix Version/s
10.2.8
[ 22544
]
Fix Version/s
10.2
[ 14601
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:45
Workflow
MariaDB v3
[ 81711
]
MariaDB v4
[ 152505
]
{"report":{"fcp":1102.4000000953674,"ttfb":311.40000009536743,"pageVisibility":"visible","entityId":62309,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"9383802d-1869-46b4-b6f1-f16137e08275","navigationType":0,"readyForUser":1190.7000000476837,"redirectCount":0,"resourceLoadedEnd":1506.4000000953674,"resourceLoadedStart":317.8000000715256,"resourceTiming":[{"duration":187.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":317.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":317.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":505.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":187.89999997615814,"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":318.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":318.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":506.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":248,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":318.3000000715256,"connectEnd":318.3000000715256,"connectStart":318.3000000715256,"domainLookupEnd":318.3000000715256,"domainLookupStart":318.3000000715256,"fetchStart":318.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":318.3000000715256,"responseEnd":566.3000000715256,"responseStart":566.3000000715256,"secureConnectionStart":318.3000000715256},{"duration":317.5,"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":318.5,"connectEnd":318.5,"connectStart":318.5,"domainLookupEnd":318.5,"domainLookupStart":318.5,"fetchStart":318.5,"redirectEnd":0,"redirectStart":0,"requestStart":318.5,"responseEnd":636,"responseStart":636,"secureConnectionStart":318.5},{"duration":325.39999997615814,"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":318.8000000715256,"connectEnd":318.8000000715256,"connectStart":318.8000000715256,"domainLookupEnd":318.8000000715256,"domainLookupStart":318.8000000715256,"fetchStart":318.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":318.8000000715256,"responseEnd":644.2000000476837,"responseStart":644.2000000476837,"secureConnectionStart":318.8000000715256},{"duration":326.10000002384186,"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":319,"connectEnd":319,"connectStart":319,"domainLookupEnd":319,"domainLookupStart":319,"fetchStart":319,"redirectEnd":0,"redirectStart":0,"requestStart":319,"responseEnd":645.1000000238419,"responseStart":645.1000000238419,"secureConnectionStart":319},{"duration":326.3000000715256,"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":319.10000002384186,"connectEnd":319.10000002384186,"connectStart":319.10000002384186,"domainLookupEnd":319.10000002384186,"domainLookupStart":319.10000002384186,"fetchStart":319.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":319.10000002384186,"responseEnd":645.4000000953674,"responseStart":645.4000000953674,"secureConnectionStart":319.10000002384186},{"duration":413.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":319.3000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":319.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":732.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":326.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":319.5,"connectEnd":319.5,"connectStart":319.5,"domainLookupEnd":319.5,"domainLookupStart":319.5,"fetchStart":319.5,"redirectEnd":0,"redirectStart":0,"requestStart":319.5,"responseEnd":646.2000000476837,"responseStart":646.2000000476837,"secureConnectionStart":319.5},{"duration":413.5,"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":319.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":319.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":733.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":328.2999999523163,"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":319.8000000715256,"connectEnd":319.8000000715256,"connectStart":319.8000000715256,"domainLookupEnd":319.8000000715256,"domainLookupStart":319.8000000715256,"fetchStart":319.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":319.8000000715256,"responseEnd":648.1000000238419,"responseStart":648.1000000238419,"secureConnectionStart":319.8000000715256},{"duration":744.2000000476837,"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":320.7000000476837,"connectEnd":320.7000000476837,"connectStart":320.7000000476837,"domainLookupEnd":320.7000000476837,"domainLookupStart":320.7000000476837,"fetchStart":320.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":320.7000000476837,"responseEnd":1064.9000000953674,"responseStart":1064.9000000953674,"secureConnectionStart":320.7000000476837},{"duration":1185.7000000476837,"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":320.7000000476837,"connectEnd":320.7000000476837,"connectStart":320.7000000476837,"domainLookupEnd":320.7000000476837,"domainLookupStart":320.7000000476837,"fetchStart":320.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":320.7000000476837,"responseEnd":1506.4000000953674,"responseStart":1506.4000000953674,"secureConnectionStart":320.7000000476837},{"duration":319.1999999284744,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":746.8000000715256,"connectEnd":746.8000000715256,"connectStart":746.8000000715256,"domainLookupEnd":746.8000000715256,"domainLookupStart":746.8000000715256,"fetchStart":746.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":746.8000000715256,"responseEnd":1066,"responseStart":1066,"secureConnectionStart":746.8000000715256},{"duration":490.7999999523163,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1094.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1094.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1585.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":145,"responseStart":311,"responseEnd":313,"domLoading":315,"domInteractive":1586,"domContentLoadedEventStart":1586,"domContentLoadedEventEnd":1640,"domComplete":1940,"loadEventStart":1940,"loadEventEnd":1941,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1509.3000000715256},{"name":"bigPipe.sidebar-id.end","time":1510.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1510.3000000715256},{"name":"bigPipe.activity-panel-pipe-id.end","time":1512},{"name":"activityTabFullyLoaded","time":1654.2000000476837}],"measures":[],"correlationId":"e9ca27bb4db","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":105,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}