Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.5
--source include/have_innodb.inc
--source include/have_partition.inc
CREATE TABLE t1 (f INT , s DATE , e DATE , PERIOD FOR p(s,e), UNIQUE (f, p WITHOUT OVERLAPS)) ENGINE=InnoDB WITH SYSTEM VERSIONING PARTITION BY system_time LIMIT 1000 (PARTITION p1 HISTORY, PARTITION pn CURRENT );
ALTER TABLE t1 ADD PARTITION (PARTITION p2 HISTORY);
INSERT INTO t1 VALUES (1, '2013-01-12' , '2015-11-04' ), (2, '2016-03-15' , '2024-11-09' );
# Cleanup
DROP TABLE t1;
10.5 c2a92918
#3 <signal handler called>
#4 __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:299
#5 0x0000556ba7a691a5 in handler::ha_check_overlaps (this=0x7f15941b4290, old_data=0x0, new_data=0x7f1594220ad8 "\375\001") at /data/src/10.5/sql/handler.cc:6834
#6 0x0000556ba7a698ef in handler::ha_write_row (this=0x7f15941b4290, buf=0x7f1594220ad8 "\375\001") at /data/src/10.5/sql/handler.cc:6973
#7 0x0000556ba76b4d83 in write_record (thd=0x7f1594000b18, table=0x7f15941b3418, info=0x7f15c4d54bf0, sink=0x0) at /data/src/10.5/sql/sql_insert.cc:2091
#8 0x0000556ba76b1c2c in mysql_insert (thd=0x7f1594000b18, table_list=0x7f1594013aa8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/src/10.5/sql/sql_insert.cc:1088
#9 0x0000556ba7703568 in mysql_execute_command (thd=0x7f1594000b18) at /data/src/10.5/sql/sql_parse.cc:4553
#10 0x0000556ba770efb9 in mysql_parse (thd=0x7f1594000b18, rawbuf=0x7f1594013950 "INSERT INTO t1 VALUES (1,'2013-01-12','2015-11-04'), (2,'2016-03-15','2024-11-09')", length=82, parser_state=0x7f15c4d55520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7991
#11 0x0000556ba76fb365 in dispatch_command (command=COM_QUERY, thd=0x7f1594000b18, packet=0x7f15940086a9 "INSERT INTO t1 VALUES (1,'2013-01-12','2015-11-04'), (2,'2016-03-15','2024-11-09')", packet_length=82, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1875
#12 0x0000556ba76f9a9d in do_command (thd=0x7f1594000b18) at /data/src/10.5/sql/sql_parse.cc:1356
#13 0x0000556ba789d561 in do_handle_one_connection (connect=0x556babef4388, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1411
#14 0x0000556ba789d2c9 in handle_one_connection (arg=0x556babec09f8) at /data/src/10.5/sql/sql_connect.cc:1313
#15 0x0000556ba7dd3fd8 in pfs_spawn_thread (arg=0x556babed0b88) at /data/src/10.5/storage/perfschema/pfs.cc:2201
#16 0x00007f15cd7574a4 in start_thread (arg=0x7f15c4d56700) at pthread_create.c:456
#17 0x00007f15cb88bd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
Fails the same way on release-, debug-, and ASAN builds, with InnoDB and Aria.
With MyISAM, it instead produces the corruption-like error:
mysqltest: At line 6: query 'INSERT INTO t1 VALUES (1,'2013-01-12','2015-11-04'), (2,'2016-03-15','2024-11-09')' failed: 1030: Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You may have retry " from storage engine MyISAM
{"report":{"fcp":1092.1000001430511,"ttfb":130.40000009536743,"pageVisibility":"visible","entityId":87609,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a1595b20-1580-4d3f-8747-b3e69a2dbd17","navigationType":0,"readyForUser":1195.5,"redirectCount":0,"resourceLoadedEnd":1525.7000000476837,"resourceLoadedStart":136.90000009536743,"resourceTiming":[{"duration":488.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":136.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":136.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":625.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":488.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":137.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":137.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":625.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":497.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":137.30000019073486,"connectEnd":137.30000019073486,"connectStart":137.30000019073486,"domainLookupEnd":137.30000019073486,"domainLookupStart":137.30000019073486,"fetchStart":137.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":137.30000019073486,"responseEnd":635.1000001430511,"responseStart":635.1000001430511,"secureConnectionStart":137.30000019073486},{"duration":571.7999999523163,"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":137.30000019073486,"connectEnd":137.30000019073486,"connectStart":137.30000019073486,"domainLookupEnd":137.30000019073486,"domainLookupStart":137.30000019073486,"fetchStart":137.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":137.30000019073486,"responseEnd":709.1000001430511,"responseStart":709.1000001430511,"secureConnectionStart":137.30000019073486},{"duration":575.5,"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":137.5,"connectEnd":137.5,"connectStart":137.5,"domainLookupEnd":137.5,"domainLookupStart":137.5,"fetchStart":137.5,"redirectEnd":0,"redirectStart":0,"requestStart":137.5,"responseEnd":713,"responseStart":713,"secureConnectionStart":137.5},{"duration":576,"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":137.5,"connectEnd":137.5,"connectStart":137.5,"domainLookupEnd":137.5,"domainLookupStart":137.5,"fetchStart":137.5,"redirectEnd":0,"redirectStart":0,"requestStart":137.5,"responseEnd":713.5,"responseStart":713.4000000953674,"secureConnectionStart":137.5},{"duration":576.2000000476837,"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":137.70000004768372,"connectEnd":137.70000004768372,"connectStart":137.70000004768372,"domainLookupEnd":137.70000004768372,"domainLookupStart":137.70000004768372,"fetchStart":137.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":137.70000004768372,"responseEnd":713.9000000953674,"responseStart":713.9000000953674,"secureConnectionStart":137.70000004768372},{"duration":576.5999999046326,"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":137.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":137.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":576.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":137.80000019073486,"connectEnd":137.80000019073486,"connectStart":137.80000019073486,"domainLookupEnd":137.80000019073486,"domainLookupStart":137.80000019073486,"fetchStart":137.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":137.80000019073486,"responseEnd":714.3000001907349,"responseStart":714.3000001907349,"secureConnectionStart":137.80000019073486},{"duration":576.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":138,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":576.6000001430511,"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":138.20000004768372,"connectEnd":138.20000004768372,"connectStart":138.20000004768372,"domainLookupEnd":138.20000004768372,"domainLookupStart":138.20000004768372,"fetchStart":138.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":138.20000004768372,"responseEnd":714.8000001907349,"responseStart":714.8000001907349,"secureConnectionStart":138.20000004768372},{"duration":739.9000000953674,"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":138.70000004768372,"connectEnd":138.70000004768372,"connectStart":138.70000004768372,"domainLookupEnd":138.70000004768372,"domainLookupStart":138.70000004768372,"fetchStart":138.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":138.70000004768372,"responseEnd":878.6000001430511,"responseStart":878.6000001430511,"secureConnectionStart":138.70000004768372},{"duration":1386.8999998569489,"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":138.80000019073486,"connectEnd":138.80000019073486,"connectStart":138.80000019073486,"domainLookupEnd":138.80000019073486,"domainLookupStart":138.80000019073486,"fetchStart":138.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":138.80000019073486,"responseEnd":1525.7000000476837,"responseStart":1525.7000000476837,"secureConnectionStart":138.80000019073486},{"duration":527.3999998569489,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":884.3000001907349,"connectEnd":884.3000001907349,"connectStart":884.3000001907349,"domainLookupEnd":884.3000001907349,"domainLookupStart":884.3000001907349,"fetchStart":884.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":884.3000001907349,"responseEnd":1411.7000000476837,"responseStart":1411.7000000476837,"secureConnectionStart":884.3000001907349},{"duration":458.2999999523163,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1068.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1068.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1527,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":11,"responseStart":130,"responseEnd":134,"domLoading":134,"domInteractive":1546,"domContentLoadedEventStart":1546,"domContentLoadedEventEnd":1581,"domComplete":2255,"loadEventStart":2255,"loadEventEnd":2257,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1529.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1530},{"name":"bigPipe.activity-panel-pipe-id.start","time":1530.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1532.6000001430511},{"name":"activityTabFullyLoaded","time":1588.4000000953674}],"measures":[],"correlationId":"5562393edc63fd","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":64,"dbReadsTimeInMs":9,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}