Note: It might well be a duplicate of MDEV-18153, the results are exactly the same, but it's a different SQL_MODE (and thus different affected versions), and different table structures, so I'm filing it separately just in case.
CREATE TABLE t1 (c CHAR(8), v BINARY(8) AS (c), KEY(v));
|
INSERT INTO t1 (c) VALUES ('foo') ;
|
|
SET SQL_MODE= 'PAD_CHAR_TO_FULL_LENGTH';
|
DELETE FROM t1 WHERE c <> 'bar';
|
|
# Cleanup
|
DROP TABLE t1;
|
|
10.2 0c20b247de with MyISAM
|
mysqltest: At line 5: query 'DELETE FROM t1 WHERE c <> 'bar'' failed: 126: Index for table './test/t1.MYI' is corrupt; try to repair it
|
|
10.2 debug 0c20b247de with InnoDB
|
2019-01-06 22:02:13 140655082366720 [ERROR] InnoDB: Record in index `v` of table `test`.`t1` was not found on update: TUPLE (info_bits=0, 2 fields): {[8]foo (0x666F6F2020202020),[6] (0x000000000200)} at: COMPACT RECORD(info_bits=0, 2 fields): {[8]foo (0x666F6F0000000000),[6] (0x000000000200)}
|
mysqld: /data/src/10.2/storage/innobase/row/row0upd.cc:2436: dberr_t row_upd_sec_index_entry(upd_node_t*, que_thr_t*): Assertion `0' failed.
|
190106 22:02:13 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fecd7f19ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055bf73ba59bb in row_upd_sec_index_entry (node=0x7fec88136de0, thr=0x7fec880848a8) at /data/src/10.2/storage/innobase/row/row0upd.cc:2436
|
#9 0x000055bf73ba6031 in row_upd_sec_step (node=0x7fec88136de0, thr=0x7fec880848a8) at /data/src/10.2/storage/innobase/row/row0upd.cc:2549
|
#10 0x000055bf73ba82b2 in row_upd (node=0x7fec88136de0, thr=0x7fec880848a8) at /data/src/10.2/storage/innobase/row/row0upd.cc:3308
|
#11 0x000055bf73ba8603 in row_upd_step (thr=0x7fec880848a8) at /data/src/10.2/storage/innobase/row/row0upd.cc:3425
|
#12 0x000055bf73b4ec37 in row_update_for_mysql (prebuilt=0x7fec881362d8) at /data/src/10.2/storage/innobase/row/row0mysql.cc:1830
|
#13 0x000055bf73a1536b in ha_innobase::delete_row (this=0x7fec88135498, record=0x7fec880311d0 "\371foo foo ", '\245' <repeats 31 times>, "\030\022\003\210\354\177") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:9098
|
#14 0x000055bf73709360 in handler::ha_delete_row (this=0x7fec88135498, buf=0x7fec880311d0 "\371foo foo ", '\245' <repeats 31 times>, "\030\022\003\210\354\177") at /data/src/10.2/sql/handler.cc:6021
|
#15 0x000055bf73898cb4 in mysql_delete (thd=0x7fec88000b00, table_list=0x7fec88012530, conds=0x7fec88012ce8, order_list=0x7fec88005078, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.2/sql/sql_delete.cc:583
|
#16 0x000055bf73484616 in mysql_execute_command (thd=0x7fec88000b00) at /data/src/10.2/sql/sql_parse.cc:4636
|
#17 0x000055bf7348ef51 in mysql_parse (thd=0x7fec88000b00, rawbuf=0x7fec88012448 "DELETE FROM t1 WHERE c <> 'bar'", length=31, parser_state=0x7fecd0385200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8015
|
#18 0x000055bf7347c88b in dispatch_command (command=COM_QUERY, thd=0x7fec88000b00, packet=0x7fec88096261 "DELETE FROM t1 WHERE c <> 'bar'", packet_length=31, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1826
|
#19 0x000055bf7347b1e2 in do_command (thd=0x7fec88000b00) at /data/src/10.2/sql/sql_parse.cc:1379
|
#20 0x000055bf735cdccd in do_handle_one_connection (connect=0x55bf772692d0) at /data/src/10.2/sql/sql_connect.cc:1335
|
#21 0x000055bf735cda5a in handle_one_connection (arg=0x55bf772692d0) at /data/src/10.2/sql/sql_connect.cc:1241
|
#22 0x000055bf739f397c in pfs_spawn_thread (arg=0x55bf771af6d0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#23 0x00007fecd9bf0494 in start_thread (arg=0x7fecd0386700) at pthread_create.c:333
|
#24 0x00007fecd7fd693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
|
10.2 non-debug 0c20b247de with InnoDB
|
2019-01-06 22:03:36 140321956206336 [ERROR] InnoDB: Record in index `v` of table `test`.`t1` was not found on update: TUPLE (info_bits=0, 2 fields): {[8]foo (0x666F6F2020202020),[6] (0x000000000200)} at: COMPACT RECORD(info_bits=0, 2 fields): {[8]foo (0x666F6F0000000000),[6] (0x000000000200)}
|
{"report":{"fcp":922.6000001430511,"ttfb":141.79999995231628,"pageVisibility":"visible","entityId":71692,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"37299827-deda-46f8-8d2f-3fb3665d0c47","navigationType":0,"readyForUser":1009.4000000953674,"redirectCount":0,"resourceLoadedEnd":1019.2000000476837,"resourceLoadedStart":147.60000014305115,"resourceTiming":[{"duration":165.39999985694885,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":147.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":147.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":313,"responseStart":0,"secureConnectionStart":0},{"duration":165.09999990463257,"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":147.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":147.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":313,"responseStart":0,"secureConnectionStart":0},{"duration":174.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":147.90000009536743,"connectEnd":147.90000009536743,"connectStart":147.90000009536743,"domainLookupEnd":147.90000009536743,"domainLookupStart":147.90000009536743,"fetchStart":147.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":147.90000009536743,"responseEnd":322.7000000476837,"responseStart":322.7000000476837,"secureConnectionStart":147.90000009536743},{"duration":416.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":148.10000014305115,"connectEnd":148.10000014305115,"connectStart":148.10000014305115,"domainLookupEnd":148.10000014305115,"domainLookupStart":148.10000014305115,"fetchStart":148.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":148.10000014305115,"responseEnd":564.6000001430511,"responseStart":564.6000001430511,"secureConnectionStart":148.10000014305115},{"duration":419.7999999523163,"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":148.20000004768372,"connectEnd":148.20000004768372,"connectStart":148.20000004768372,"domainLookupEnd":148.20000004768372,"domainLookupStart":148.20000004768372,"fetchStart":148.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":148.20000004768372,"responseEnd":568,"responseStart":568,"secureConnectionStart":148.20000004768372},{"duration":420.59999990463257,"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":148.20000004768372,"connectEnd":148.20000004768372,"connectStart":148.20000004768372,"domainLookupEnd":148.20000004768372,"domainLookupStart":148.20000004768372,"fetchStart":148.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":148.20000004768372,"responseEnd":568.7999999523163,"responseStart":568.7999999523163,"secureConnectionStart":148.20000004768372},{"duration":421.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":148.29999995231628,"connectEnd":148.29999995231628,"connectStart":148.29999995231628,"domainLookupEnd":148.29999995231628,"domainLookupStart":148.29999995231628,"fetchStart":148.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":148.29999995231628,"responseEnd":569.4000000953674,"responseStart":569.4000000953674,"secureConnectionStart":148.29999995231628},{"duration":421.40000009536743,"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":148.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":148.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":569.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":421.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":148.5,"connectEnd":148.5,"connectStart":148.5,"domainLookupEnd":148.5,"domainLookupStart":148.5,"fetchStart":148.5,"redirectEnd":0,"redirectStart":0,"requestStart":148.5,"responseEnd":569.9000000953674,"responseStart":569.9000000953674,"secureConnectionStart":148.5},{"duration":421.7000000476837,"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":148.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":148.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":570.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":421.90000009536743,"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":148.79999995231628,"connectEnd":148.79999995231628,"connectStart":148.79999995231628,"domainLookupEnd":148.79999995231628,"domainLookupStart":148.79999995231628,"fetchStart":148.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":148.79999995231628,"responseEnd":570.7000000476837,"responseStart":570.7000000476837,"secureConnectionStart":148.79999995231628},{"duration":514.6000001430511,"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":150,"connectEnd":150,"connectStart":150,"domainLookupEnd":150,"domainLookupStart":150,"fetchStart":150,"redirectEnd":0,"redirectStart":0,"requestStart":150,"responseEnd":664.6000001430511,"responseStart":664.6000001430511,"secureConnectionStart":150},{"duration":866.6999998092651,"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":150.10000014305115,"connectEnd":150.10000014305115,"connectStart":150.10000014305115,"domainLookupEnd":150.10000014305115,"domainLookupStart":150.10000014305115,"fetchStart":150.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":150.10000014305115,"responseEnd":1016.7999999523163,"responseStart":1016.7999999523163,"secureConnectionStart":150.10000014305115},{"duration":187.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":468.7000000476837,"connectEnd":468.7000000476837,"connectStart":468.7000000476837,"domainLookupEnd":468.7000000476837,"domainLookupStart":468.7000000476837,"fetchStart":468.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":468.7000000476837,"responseEnd":656.1000001430511,"responseStart":656.1000001430511,"secureConnectionStart":468.7000000476837},{"duration":191.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":826.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":826.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1018,"responseStart":0,"secureConnectionStart":0},{"duration":192,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2bu7/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":827.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":827.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1019.2000000476837,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":142,"responseEnd":146,"domLoading":145,"domInteractive":1070,"domContentLoadedEventStart":1070,"domContentLoadedEventEnd":1117,"domComplete":1814,"loadEventStart":1814,"loadEventEnd":1816,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1051.7000000476837},{"name":"bigPipe.sidebar-id.end","time":1052.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1052.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1054.9000000953674},{"name":"activityTabFullyLoaded","time":1123.7000000476837}],"measures":[],"correlationId":"dc5059ff14d8c5","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":82,"dbReadsTimeInMs":21,"dbConnsTimeInMs":28,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
MDEV-20472 Document MDEV-18156 - sql_mode dependency in vcol expressions
