Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL) , 11.4 , 11.6(EOL)
I reviewed open bugs for this generic assert, but could not locate any bug that looked directly related.
CREATE TABLE t (c INT KEY ) ENGINE=InnoDB;
INSERT INTO t (c) VALUES (0);
SELECT * FROM t WHERE (0,0) IN ( SELECT MAX (c), MIN (c) FROM t);
Leads to:
11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Debug)
mariadbd: /test/11.0_dbg/sql/item_cmpfunc.cc:5514: virtual longlong Item_cond_and::val_int(): Assertion `fixed()' failed.
11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Debug)
Core was generated by `/test/MD180223-mariadb-11.0.1-linux-x86_64-dbg/bin/mariadbd --no-defaults --cor'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22705815160384)
at ./nptl/pthread_kill.c:44
[Current thread is 1 (Thread 0x14a69c0c0640 (LWP 1920928))]
(gdb) bt
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22705815160384) at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=22705815160384) at ./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=22705815160384, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
#3 0x000014a6b534a476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#4 0x000014a6b53307f3 in __GI_abort () at ./stdlib/abort.c:79
#5 0x000014a6b533071b in __assert_fail_base (fmt=0x14a6b54e5150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x563ff4faea79 "fixed()", file=0x563ff5137e48 "/test/11.0_dbg/sql/item_cmpfunc.cc", line=5514, function=<optimized out>) at ./assert/assert.c:92
#6 0x000014a6b5341e96 in __GI___assert_fail (assertion=0x563ff4faea79 "fixed()", file=0x563ff5137e48 "/test/11.0_dbg/sql/item_cmpfunc.cc", line=5514, function=0x563ff5138368 "virtual longlong Item_cond_and::val_int()") at ./assert/assert.c:101
#7 0x0000563ff47a59c6 in Item_cond_and::val_int (this=0x14a5fc06a320) at /test/11.0_dbg/sql/item_cmpfunc.cc:5514
#8 0x0000563ff43a5a2f in Item_func::is_simplified_cond_processor (this=0x14a5fc06a320, arg=arg@entry=0x0) at /test/11.0_dbg/sql/item_func.h:391
#9 0x0000563ff47a78b2 in Item_func_or_sum::walk (arg=0x0, walk_subquery=<optimized out>, processor=&virtual table offset 1144, this=0x14a5fc06a320) at /test/11.0_dbg/sql/item.h:5482
#10 Item_cond::walk (this=0x14a5fc06a320, processor=&virtual table offset 1144, walk_subquery=<optimized out>, arg=0x0) at /test/11.0_dbg/sql/item_cmpfunc.cc:5200
#11 0x0000563ff464cc04 in and_new_conditions_to_optimized_cond (thd=0x14a5fc000d58, cond=0x14a5fc06a320, cond_eq=cond_eq@entry=0x14a5fc016c00, new_conds=@0x14a69c0be790: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14a5fc069fc0, last = 0x14a5fc06a200, elements = 2}, <No data fields>}, cond_value=cond_value@entry=0x14a5fc016ad8) at /test/11.0_dbg/sql/opt_subselect.cc:6273
#12 0x0000563ff4520e74 in JOIN::optimize_inner (this=this@entry=0x14a5fc016738) at /test/11.0_dbg/sql/sql_select.cc:2353
#13 0x0000563ff45219bc in JOIN::optimize (this=this@entry=0x14a5fc016738) at /test/11.0_dbg/sql/sql_select.cc:1897
#14 0x0000563ff4521ac5 in mysql_select (thd=thd@entry=0x14a5fc000d58, tables=0x14a5fc013830, fields=@0x14a5fc0134d0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14a5fc0137e8, last = 0x14a5fc0137e8, elements = 1}, <No data fields>}, conds=0x14a5fc015ae0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x14a5fc016710, unit=0x14a5fc004fa0, select_lex=0x14a5fc013218) at /test/11.0_dbg/sql/sql_select.cc:5132
#15 0x0000563ff452228b in handle_select (thd=thd@entry=0x14a5fc000d58, lex=lex@entry=0x14a5fc004ec8, result=result@entry=0x14a5fc016710, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/11.0_dbg/sql/sql_select.cc:608
#16 0x0000563ff4487e8d in execute_sqlcom_select (thd=thd@entry=0x14a5fc000d58, all_tables=0x14a5fc013830) at /test/11.0_dbg/sql/sql_parse.cc:6267
#17 0x0000563ff44934af in mysql_execute_command (thd=thd@entry=0x14a5fc000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.0_dbg/sql/sql_parse.cc:3949
#18 0x0000563ff449a7cf in mysql_parse (thd=thd@entry=0x14a5fc000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14a69c0bf2c0) at /test/11.0_dbg/sql/sql_parse.cc:8002
#19 0x0000563ff449c963 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14a5fc000d58, packet=packet@entry=0x14a5fc00ae19 "SELECT * FROM t WHERE (0,0) IN (SELECT MAX(c),MIN(c) FROM t)", packet_length=packet_length@entry=60, blocking=blocking@entry=true) at /test/11.0_dbg/sql/sql_class.h:242
#20 0x0000563ff449e7bc in do_command (thd=0x14a5fc000d58, blocking=blocking@entry=true) at /test/11.0_dbg/sql/sql_parse.cc:1407
#21 0x0000563ff45ef6e2 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x563ff78ccaf8, put_in_cache=put_in_cache@entry=true) at /test/11.0_dbg/sql/sql_connect.cc:1416
#22 0x0000563ff45ef941 in handle_one_connection (arg=0x563ff78ccaf8) at /test/11.0_dbg/sql/sql_connect.cc:1318
#23 0x000014a6b539cb43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#24 0x000014a6b542ea00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
Bug confirmed present in:
MariaDB: 10.4.29 (dbg), 10.5.20 (dbg), 10.6.13 (dbg), 10.7.8 (dbg), 10.8.8 (dbg), 10.9.6 (dbg), 10.10.4 (dbg), 10.11.2 (dbg), 11.0.1 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.4.29 (opt), 10.5.20 (opt), 10.6.13 (opt), 10.7.8 (opt), 10.8.8 (opt), 10.9.6 (opt), 10.10.4 (opt), 10.11.2 (opt), 11.0.1 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.40 (dbg), 5.7.40 (opt), 8.0.31 (dbg), 8.0.31 (opt)
relates to
MDEV-23838
Possibly wrong result or Assertion `0' failed in Item_func_round::native_op
Closed
{"report":{"fcp":1004,"ttfb":210.30000007152557,"pageVisibility":"visible","entityId":119665,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"78601a22-bc81-4542-ae06-6c46a5770d92","navigationType":0,"readyForUser":1085.2000000476837,"redirectCount":0,"resourceLoadedEnd":1006.2000000476837,"resourceLoadedStart":218.40000009536743,"resourceTiming":[{"duration":133.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":218.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":218.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":352,"responseStart":0,"secureConnectionStart":0},{"duration":133.5,"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":218.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":218.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":352.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":320.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":218.80000007152557,"connectEnd":218.80000007152557,"connectStart":218.80000007152557,"domainLookupEnd":218.80000007152557,"domainLookupStart":218.80000007152557,"fetchStart":218.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":218.80000007152557,"responseEnd":539.4000000953674,"responseStart":539.4000000953674,"secureConnectionStart":218.80000007152557},{"duration":408.1999999284744,"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":218.90000009536743,"connectEnd":218.90000009536743,"connectStart":218.90000009536743,"domainLookupEnd":218.90000009536743,"domainLookupStart":218.90000009536743,"fetchStart":218.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":218.90000009536743,"responseEnd":627.1000000238419,"responseStart":627.1000000238419,"secureConnectionStart":218.90000009536743},{"duration":412.2000000476837,"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":219,"connectEnd":219,"connectStart":219,"domainLookupEnd":219,"domainLookupStart":219,"fetchStart":219,"redirectEnd":0,"redirectStart":0,"requestStart":219,"responseEnd":631.2000000476837,"responseStart":631.2000000476837,"secureConnectionStart":219},{"duration":414.2000000476837,"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":219.10000002384186,"connectEnd":219.10000002384186,"connectStart":219.10000002384186,"domainLookupEnd":219.10000002384186,"domainLookupStart":219.10000002384186,"fetchStart":219.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":219.10000002384186,"responseEnd":633.3000000715256,"responseStart":633.3000000715256,"secureConnectionStart":219.10000002384186},{"duration":416,"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":219.10000002384186,"connectEnd":219.10000002384186,"connectStart":219.10000002384186,"domainLookupEnd":219.10000002384186,"domainLookupStart":219.10000002384186,"fetchStart":219.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":219.10000002384186,"responseEnd":635.1000000238419,"responseStart":635.1000000238419,"secureConnectionStart":219.10000002384186},{"duration":418.2000000476837,"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":219.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":637.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":417.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":219.30000007152557,"connectEnd":219.30000007152557,"connectStart":219.30000007152557,"domainLookupEnd":219.30000007152557,"domainLookupStart":219.30000007152557,"fetchStart":219.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":219.30000007152557,"responseEnd":637,"responseStart":637,"secureConnectionStart":219.30000007152557},{"duration":419.3000000715256,"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":219.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":638.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":419.2000000476837,"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":219.70000004768372,"connectEnd":219.70000004768372,"connectStart":219.70000004768372,"domainLookupEnd":219.70000004768372,"domainLookupStart":219.70000004768372,"fetchStart":219.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":219.70000004768372,"responseEnd":638.9000000953674,"responseStart":638.9000000953674,"secureConnectionStart":219.70000004768372},{"duration":503.2999999523163,"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":220.20000004768372,"connectEnd":220.20000004768372,"connectStart":220.20000004768372,"domainLookupEnd":220.20000004768372,"domainLookupStart":220.20000004768372,"fetchStart":220.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":220.20000004768372,"responseEnd":723.5,"responseStart":723.5,"secureConnectionStart":220.20000004768372},{"duration":773.1999999284744,"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":220.40000009536743,"connectEnd":220.40000009536743,"connectStart":220.40000009536743,"domainLookupEnd":220.40000009536743,"domainLookupStart":220.40000009536743,"fetchStart":220.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":220.40000009536743,"responseEnd":993.6000000238419,"responseStart":993.6000000238419,"secureConnectionStart":220.40000009536743},{"duration":36,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":698.2000000476837,"connectEnd":698.2000000476837,"connectStart":698.2000000476837,"domainLookupEnd":698.2000000476837,"domainLookupStart":698.2000000476837,"fetchStart":698.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":698.2000000476837,"responseEnd":734.2000000476837,"responseStart":734.2000000476837,"secureConnectionStart":698.2000000476837},{"duration":88.20000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":918,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":918,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1006.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":232.19999992847443,"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":918.9000000953674,"connectEnd":918.9000000953674,"connectStart":918.9000000953674,"domainLookupEnd":918.9000000953674,"domainLookupStart":918.9000000953674,"fetchStart":918.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":918.9000000953674,"responseEnd":1151.1000000238419,"responseStart":1151.1000000238419,"secureConnectionStart":918.9000000953674},{"duration":235.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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":919.3000000715256,"connectEnd":919.3000000715256,"connectStart":919.3000000715256,"domainLookupEnd":919.3000000715256,"domainLookupStart":919.3000000715256,"fetchStart":919.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":919.3000000715256,"responseEnd":1154.8000000715256,"responseStart":1154.8000000715256,"secureConnectionStart":919.3000000715256}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":45,"responseStart":210,"responseEnd":213,"domLoading":214,"domInteractive":1141,"domContentLoadedEventStart":1141,"domContentLoadedEventEnd":1181,"domComplete":1579,"loadEventStart":1579,"loadEventEnd":1580,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1124.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1125.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":1125.3000000715256},{"name":"bigPipe.activity-panel-pipe-id.end","time":1127.7000000476837},{"name":"activityTabFullyLoaded","time":1190}],"measures":[],"correlationId":"6f04c334cc5222","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":10,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}