How to repeat
Start server with @@optimizer_use_condition_selectivity=4 and execute the following commands:
--source include/have_innodb.inc
|
|
drop table if exists t1, t2;
|
drop view if exists v1;
|
|
create table t1 (a int not null, b int, c int) engine=InnoDB;
|
create trigger trgi before insert on t1 for each row set new.a=if(new.a is null,new.b,new.c);
|
|
create table t2 (d int, e int) engine=InnoDB;
|
update t1, t2 set a=NULL, b=2, c=NULL where b=d and e=200;
|
|
create view v1 as select * from t1, t2 where d=2;
|
insert v1 (a,c) values (NULL, 20);
|
Stacktrace
mysqld: /home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc:532: void Protocol::end_statement(): Assertion `0' failed.
|
|
Thread 28 "mysqld" received signal SIGABRT, Aborted.
|
[Switching to Thread 0x7fffec473b00 (LWP 7029)]
|
0x00007ffff6498418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
54 ../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
|
(gdb) bt
|
#0 0x00007ffff6498418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#1 0x00007ffff649a01a in __GI_abort () at abort.c:89
|
#2 0x00007ffff6490bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x555556362f2f "0",
|
file=file@entry=0x555556363020 "/home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc",
|
line=line@entry=532,
|
function=function@entry=0x555556363960 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()") at assert.c:92
|
#3 0x00007ffff6490c82 in __GI___assert_fail (assertion=0x555556362f2f "0",
|
file=0x555556363020 "/home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc", line=532,
|
function=0x555556363960 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()")
|
at assert.c:101
|
#4 0x000055555596b24c in Protocol::end_statement (this=0x555557a17540)
|
at /home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc:532
|
#5 0x0000555555a211d7 in dispatch_command (command=COM_QUERY, thd=0x555557a16fb0,
|
packet=0x555557a1d811 "insert v1 (a,c) values (NULL, 20)", packet_length=33)
|
at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_parse.cc:1940
|
#6 0x0000555555a1e90d in do_command (thd=0x555557a16fb0)
|
at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_parse.cc:1108
|
#7 0x0000555555b54ddb in do_handle_one_connection (thd_arg=0x555557a16fb0)
|
at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_connect.cc:1350
|
#8 0x0000555555b54b2a in handle_one_connection (arg=0x555557a16fb0)
|
at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_connect.cc:1262
|
#9 0x00007ffff6ebe6fa in start_thread (arg=0x7fffec473b00) at pthread_create.c:333
|
#10 0x00007ffff6569b5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
The following tests in the main suite also fail due to this issue (when started with -mysqld=-optimizer_use_condition_selectivity=4):
- main.strict
- main.gis
- main.ps_2myisam
- main.ps_3innodb
- main.ps_4heap
- main.trigger_null-8605
- main.view
- relates to
-
MDEV-7635
update defaults and simplify mysqld config parameters
-
-
Closed
{"report":{"fcp":759.5999999046326,"ttfb":215,"pageVisibility":"visible","entityId":58504,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"ea594622-13e2-4a0d-870f-ec852b640623","navigationType":0,"readyForUser":873.7999999523163,"redirectCount":0,"resourceLoadedEnd":495.7999999523163,"resourceLoadedStart":219.90000009536743,"resourceTiming":[{"duration":8,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":219.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":227.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":9.300000190734863,"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":220.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":229.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":154.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":220.20000004768372,"connectEnd":220.20000004768372,"connectStart":220.20000004768372,"domainLookupEnd":220.20000004768372,"domainLookupStart":220.20000004768372,"fetchStart":220.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":230.79999995231628,"responseEnd":374.59999990463257,"responseStart":250.70000004768372,"secureConnectionStart":220.20000004768372},{"duration":45.89999985694885,"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":220.40000009536743,"connectEnd":220.40000009536743,"connectStart":220.40000009536743,"domainLookupEnd":220.40000009536743,"domainLookupStart":220.40000009536743,"fetchStart":220.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":233.29999995231628,"responseEnd":266.2999999523163,"responseStart":260.2999999523163,"secureConnectionStart":220.40000009536743},{"duration":275.39999985694885,"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":220.40000009536743,"connectEnd":220.40000009536743,"connectStart":220.40000009536743,"domainLookupEnd":220.40000009536743,"domainLookupStart":220.40000009536743,"fetchStart":220.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":232.70000004768372,"responseEnd":495.7999999523163,"responseStart":254.40000009536743,"secureConnectionStart":220.40000009536743},{"duration":46,"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":220.5,"connectEnd":220.5,"connectStart":220.5,"domainLookupEnd":220.5,"domainLookupStart":220.5,"fetchStart":220.5,"redirectEnd":0,"redirectStart":0,"requestStart":234.29999995231628,"responseEnd":266.5,"responseStart":260.90000009536743,"secureConnectionStart":220.5},{"duration":46.10000014305115,"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":220.59999990463257,"connectEnd":220.59999990463257,"connectStart":220.59999990463257,"domainLookupEnd":220.59999990463257,"domainLookupStart":220.59999990463257,"fetchStart":220.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":234.5,"responseEnd":266.7000000476837,"responseStart":261.5,"secureConnectionStart":220.59999990463257},{"duration":12.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":220.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":233.20000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":47.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":220.79999995231628,"connectEnd":220.79999995231628,"connectStart":220.79999995231628,"domainLookupEnd":220.79999995231628,"domainLookupStart":220.79999995231628,"fetchStart":220.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":236.59999990463257,"responseEnd":268.2999999523163,"responseStart":263.7999999523163,"secureConnectionStart":220.79999995231628},{"duration":13.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":220.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":234.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":47.89999985694885,"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":220.90000009536743,"connectEnd":220.90000009536743,"connectStart":220.90000009536743,"domainLookupEnd":220.90000009536743,"domainLookupStart":220.90000009536743,"fetchStart":220.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":240.09999990463257,"responseEnd":268.7999999523163,"responseStart":265.09999990463257,"secureConnectionStart":220.90000009536743},{"duration":249.59999990463257,"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":227,"connectEnd":227,"connectStart":227,"domainLookupEnd":227,"domainLookupStart":227,"fetchStart":227,"redirectEnd":0,"redirectStart":0,"requestStart":246.79999995231628,"responseEnd":476.59999990463257,"responseStart":469.7999999523163,"secureConnectionStart":227},{"duration":248.89999985694885,"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":228.20000004768372,"connectEnd":228.20000004768372,"connectStart":228.20000004768372,"domainLookupEnd":228.20000004768372,"domainLookupStart":228.20000004768372,"fetchStart":228.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":251.40000009536743,"responseEnd":477.09999990463257,"responseStart":471.2000000476837,"secureConnectionStart":228.20000004768372},{"duration":87.29999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":520.5,"connectEnd":520.5,"connectStart":520.5,"domainLookupEnd":520.5,"domainLookupStart":520.5,"fetchStart":520.5,"redirectEnd":0,"redirectStart":0,"requestStart":577.2000000476837,"responseEnd":607.7999999523163,"responseStart":606.9000000953674,"secureConnectionStart":520.5},{"duration":142.70000004768372,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":753.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":753.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":895.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":166.79999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":759.7000000476837,"connectEnd":759.7000000476837,"connectStart":759.7000000476837,"domainLookupEnd":759.7000000476837,"domainLookupStart":759.7000000476837,"fetchStart":759.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":896.2000000476837,"responseEnd":926.5,"responseStart":926.0999999046326,"secureConnectionStart":759.7000000476837}],"fetchStart":0,"domainLookupStart":19,"domainLookupEnd":40,"connectStart":40,"connectEnd":60,"secureConnectionStart":49,"requestStart":61,"responseStart":215,"responseEnd":226,"domLoading":218,"domInteractive":968,"domContentLoadedEventStart":968,"domContentLoadedEventEnd":1018,"domComplete":1324,"loadEventStart":1324,"loadEventEnd":1324,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":916.7999999523163},{"name":"bigPipe.sidebar-id.end","time":917.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":917.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":923.0999999046326},{"name":"activityTabFullyLoaded","time":1035.5}],"measures":[],"correlationId":"16213b4ea27371","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":14,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Requires InnoDB.