Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL)
Further to MDEV-24511 :
SET SESSION sql_mode= 'ORACLE' ;
CREATE TABLE t (a CHAR ,b GEOMETRY) ENGINE InnoDB;
INSERT INTO t (a) VALUES (uuid_short());
UPDATE t SET a=a+12,b=3 LIMIT 3;
CREATE FULLTEXT INDEX i ON t (s2);
Leads to:
10.8.1 0c5d1342ae6b5ab3256848be7a83e5c3b1f21566 (Debug)
mysqld: /test/10.8_dbg/sql/field.h:1159: const uchar* Field::ptr_in_record(const uchar*) const: Assertion `l_offset >= 0 && table->s->rec_buff_length - l_offset > 0' failed.
10.8.1 0c5d1342ae6b5ab3256848be7a83e5c3b1f21566 (Debug)
Core was generated by `/test/MD290122-mariadb-10.8.1-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
[Current thread is 1 (Thread 0x154b801ea700 (LWP 3094038))]
(gdb) bt
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1 0x0000154ba087d859 in __GI_abort () at abort.c:79
#2 0x0000154ba087d729 in __assert_fail_base (fmt=0x154ba0a13588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x562c1958b1d8 "l_offset >= 0 && table->s->rec_buff_length - l_offset > 0", file=0x562c19541190 "/test/10.8_dbg/sql/field.h", line=1159, function=<optimized out>) at assert.c:92
#3 0x0000154ba088ef36 in __GI___assert_fail (assertion=assertion@entry=0x562c1958b1d8 "l_offset >= 0 && table->s->rec_buff_length - l_offset > 0", file=file@entry=0x562c19541190 "/test/10.8_dbg/sql/field.h", line=line@entry=1159, function=function@entry=0x562c1958b1a0 "const uchar* Field::ptr_in_record(const uchar*) const") at assert.c:101
#4 0x0000562c18b76b93 in Field::ptr_in_record (record=<optimized out>, this=0x154b280285d0) at /test/10.8_dbg/sql/field.h:1159
#5 Column_definition::Column_definition (this=0x154b28014930, thd=0x154b28000db8, old_field=<optimized out>, orig_field=0x154b280285d0) at /test/10.8_dbg/sql/field.cc:10872
#6 0x0000562c189754d1 in Create_field::Create_field (orig_field=0x154b280285d0, old_field=0x154b280285d0, thd=0x154b28000db8, this=0x154b28014930) at /test/10.8_dbg/sql/field.h:5686
#7 mysql_prepare_alter_table (thd=thd@entry=0x154b28000db8, table=table@entry=0x154b28028148, create_info=create_info@entry=0x154b801e8fc0, alter_info=alter_info@entry=0x154b801e8ed0, alter_ctx=alter_ctx@entry=0x154b801e8190) at /test/10.8_dbg/sql/sql_table.cc:8166
#8 0x0000562c189855ad in mysql_alter_table (thd=thd@entry=0x154b28000db8, new_db=new_db@entry=0x154b28013ee8, new_name=new_name@entry=0x154b28013ef8, create_info=create_info@entry=0x154b801e8fc0, table_list=<optimized out>, table_list@entry=0x154b28013ed0, alter_info=alter_info@entry=0x154b801e8ed0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.8_dbg/sql/sql_table.cc:10308
#9 0x0000562c18895631 in mysql_execute_command (thd=thd@entry=0x154b28000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.8_dbg/sql/structs.h:568
#10 0x0000562c18880db7 in mysql_parse (thd=thd@entry=0x154b28000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x154b801e9400) at /test/10.8_dbg/sql/sql_parse.cc:8027
#11 0x0000562c1888fa53 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x154b28000db8, packet=packet@entry=0x154b2800b889 "CREATE FULLTEXT INDEX i ON t (s2)", packet_length=packet_length@entry=33, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_class.h:1362
#12 0x0000562c18892e9a in do_command (thd=0x154b28000db8, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_parse.cc:1402
#13 0x0000562c18a0e110 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x562c1ca0d208, put_in_cache=put_in_cache@entry=true) at /test/10.8_dbg/sql/sql_connect.cc:1418
#14 0x0000562c18a0e715 in handle_one_connection (arg=arg@entry=0x562c1ca0d208) at /test/10.8_dbg/sql/sql_connect.cc:1312
#15 0x0000562c18e97c8e in pfs_spawn_thread (arg=0x562c1c920348) at /test/10.8_dbg/storage/perfschema/pfs.cc:2201
#16 0x0000154ba0d8c609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#17 0x0000154ba097a293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Bug confirmed present in:
MariaDB: 10.3.33 (dbg), 10.4.23 (dbg), 10.5.14 (dbg), 10.6.6 (dbg), 10.7.2 (dbg), 10.8.1 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.42 (dbg), 10.2.42 (opt), 10.3.33 (opt), 10.4.23 (opt), 10.5.14 (opt), 10.6.6 (opt), 10.7.2 (opt), 10.8.1 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.36 (dbg), 5.7.36 (opt), 8.0.27 (dbg), 8.0.27 (opt)
{"report":{"fcp":921.8999996185303,"ttfb":192.10000038146973,"pageVisibility":"visible","entityId":107702,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"fe68eafa-6165-46df-91ac-d737b1c19097","navigationType":0,"readyForUser":991.6000003814697,"redirectCount":0,"resourceLoadedEnd":670.8999996185303,"resourceLoadedStart":197.30000019073486,"resourceTiming":[{"duration":235.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":197.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":433.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":235.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":197.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":433.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":245,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":197.69999980926514,"connectEnd":197.69999980926514,"connectStart":197.69999980926514,"domainLookupEnd":197.69999980926514,"domainLookupStart":197.69999980926514,"fetchStart":197.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":197.69999980926514,"responseEnd":442.69999980926514,"responseStart":442.69999980926514,"secureConnectionStart":197.69999980926514},{"duration":270.30000019073486,"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":197.80000019073486,"connectEnd":197.80000019073486,"connectStart":197.80000019073486,"domainLookupEnd":197.80000019073486,"domainLookupStart":197.80000019073486,"fetchStart":197.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":197.80000019073486,"responseEnd":468.1000003814697,"responseStart":468.1000003814697,"secureConnectionStart":197.80000019073486},{"duration":274,"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":197.89999961853027,"connectEnd":197.89999961853027,"connectStart":197.89999961853027,"domainLookupEnd":197.89999961853027,"domainLookupStart":197.89999961853027,"fetchStart":197.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":197.89999961853027,"responseEnd":471.8999996185303,"responseStart":471.8999996185303,"secureConnectionStart":197.89999961853027},{"duration":274.6000003814697,"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":198,"connectEnd":198,"connectStart":198,"domainLookupEnd":198,"domainLookupStart":198,"fetchStart":198,"redirectEnd":0,"redirectStart":0,"requestStart":198,"responseEnd":472.6000003814697,"responseStart":472.6000003814697,"secureConnectionStart":198},{"duration":274.8999996185303,"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":198.10000038146973,"connectEnd":198.10000038146973,"connectStart":198.10000038146973,"domainLookupEnd":198.10000038146973,"domainLookupStart":198.10000038146973,"fetchStart":198.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":198.10000038146973,"responseEnd":473,"responseStart":473,"secureConnectionStart":198.10000038146973},{"duration":275.30000019073486,"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":198.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":473.5,"responseStart":0,"secureConnectionStart":0},{"duration":275.6000003814697,"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":198.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":474,"responseStart":0,"secureConnectionStart":0},{"duration":275.20000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":198.39999961853027,"connectEnd":198.39999961853027,"connectStart":198.39999961853027,"domainLookupEnd":198.39999961853027,"domainLookupStart":198.39999961853027,"fetchStart":198.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":198.39999961853027,"responseEnd":473.6000003814697,"responseStart":473.6000003814697,"secureConnectionStart":198.39999961853027},{"duration":275.5999994277954,"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":198.60000038146973,"connectEnd":198.60000038146973,"connectStart":198.60000038146973,"domainLookupEnd":198.60000038146973,"domainLookupStart":198.60000038146973,"fetchStart":198.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":198.60000038146973,"responseEnd":474.19999980926514,"responseStart":474.19999980926514,"secureConnectionStart":198.60000038146973},{"duration":392.8999996185303,"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":205.80000019073486,"connectEnd":205.80000019073486,"connectStart":205.80000019073486,"domainLookupEnd":205.80000019073486,"domainLookupStart":205.80000019073486,"fetchStart":205.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":205.80000019073486,"responseEnd":598.6999998092651,"responseStart":598.6999998092651,"secureConnectionStart":205.80000019073486},{"duration":464.5999994277954,"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":206.30000019073486,"connectEnd":206.30000019073486,"connectStart":206.30000019073486,"domainLookupEnd":206.30000019073486,"domainLookupStart":206.30000019073486,"fetchStart":206.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":206.30000019073486,"responseEnd":670.8999996185303,"responseStart":670.8999996185303,"secureConnectionStart":206.30000019073486},{"duration":364.79999923706055,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":677.6000003814697,"connectEnd":677.6000003814697,"connectStart":677.6000003814697,"domainLookupEnd":677.6000003814697,"domainLookupStart":677.6000003814697,"fetchStart":677.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":677.6000003814697,"responseEnd":1042.3999996185303,"responseStart":1042.3999996185303,"secureConnectionStart":677.6000003814697},{"duration":178.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":897.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":897.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1076.1000003814697,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":37,"responseStart":192,"responseEnd":206,"domLoading":195,"domInteractive":1060,"domContentLoadedEventStart":1060,"domContentLoadedEventEnd":1103,"domComplete":1778,"loadEventStart":1778,"loadEventEnd":1780,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1030.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1031.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1031.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1034.1000003814697},{"name":"activityTabFullyLoaded","time":1114.1999998092651}],"measures":[],"correlationId":"ec6c8769c763a1","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":97,"dbReadsTimeInMs":36,"dbConnsTimeInMs":43,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}