Initially reported by Ramesh Sivaraman as http://bugs.mysql.com/bug.php?id=74603, refiling to make it searchable in Jira and to preserve the test case.
DROP DATABASE test;CREATE DATABASE test;USE test;
|
SET character_set_filesystem=filename;
|
SET @session_start_value=@@character_set_filesystem;
|
SET @@session.collation_server=@session_start_value;
|
create table t0(a ENUM('',''));
|
DROP DATABASE test;CREATE DATABASE test;USE test;
|
create table t0(a ENUM('',''));
|
sql/sql_table.cc:3343: int mysql_prepare_create_table(THD*, HA_CREATE_INFO*, Alter_info*, uint*, handler*, KEY**, uint*, int): Assertion `comma_length > 0' failed.
|
141108 20:06:32 [ERROR] mysqld got signal 6 ;
|
#6 0x00007fa6e95cb6f1 in *__GI___assert_fail (assertion=0xf35b8b "comma_length > 0", file=<optimized out>, line=3343, function=0xf377c0 "int mysql_prepare_create_table(THD*, HA_CREATE_INFO*, Alter_info*, uint*, handler*, KEY**, uint*, int)") at assert.c:81
|
#7 0x00000000007233aa in mysql_prepare_create_table (thd=0x7fa6e330b070, create_info=0x7fa6eb54ecb0, alter_info=0x7fa6eb54ec20, db_options=0x7fa6eb54d54c, file=0x7fa6d605b088, key_info_buffer=0x7fa6eb54eaa8, key_count=0x7fa6eb54eaa4, create_table_mode=0) at 10.0/sql/sql_table.cc:3343
|
#8 0x0000000000727031 in mysql_create_frm_image (thd=0x7fa6e330b070, db=0x7fa6d621d748 "test", table_name=0x7fa6d621d138 "t0", create_info=0x7fa6eb54ecb0, alter_info=0x7fa6eb54ec20, create_table_mode=0, key_info=0x7fa6eb54eaa8, key_count=0x7fa6eb54eaa4, frm=0x7fa6eb54ea90) at 10.0/sql/sql_table.cc:4594
|
#9 0x0000000000727943 in create_table_impl (thd=0x7fa6e330b070, orig_db=0x7fa6d621d748 "test", orig_table_name=0x7fa6d621d138 "t0", db=0x7fa6d621d748 "test", table_name=0x7fa6d621d138 "t0", path=0x7fa6eb54e880 "./test/t0", create_info=0x7fa6eb54ecb0, alter_info=0x7fa6eb54ec20, create_table_mode=0, is_trans=0x7fa6eb54eb27, key_info=0x7fa6eb54eaa8, key_count=0x7fa6eb54eaa4, frm=0x7fa6eb54ea90) at 10.0/sql/sql_table.cc:4831
|
#10 0x0000000000727eb5 in mysql_create_table_no_lock (thd=0x7fa6e330b070, db=0x7fa6d621d748 "test", table_name=0x7fa6d621d138 "t0", create_info=0x7fa6eb54ecb0, alter_info=0x7fa6eb54ec20, is_trans=0x7fa6eb54eb27, create_table_mode=0) at 10.0/sql/sql_table.cc:4949
|
#11 0x00000000007280f4 in mysql_create_table (thd=0x7fa6e330b070, create_table=0x7fa6d621d170, create_info=0x7fa6eb54ecb0, alter_info=0x7fa6eb54ec20) at 10.0/sql/sql_table.cc:5010
|
#12 0x000000000067c55f in mysql_execute_command (thd=0x7fa6e330b070) at 10.0/sql/sql_parse.cc:3020
|
#13 0x000000000068586f in mysql_parse (thd=0x7fa6e330b070, rawbuf=0x7fa6d621d088 "create table t0(a ENUM('',''))", length=30, parser_state=0x7fa6eb54f630) at 10.0/sql/sql_parse.cc:6407
|
#14 0x0000000000678652 in dispatch_command (command=COM_QUERY, thd=0x7fa6e330b070, packet=0x7fa6d83f2071 "create table t0(a ENUM('',''))", packet_length=30) at 10.0/sql/sql_parse.cc:1299
|
#15 0x00000000006779f7 in do_command (thd=0x7fa6e330b070) at 10.0/sql/sql_parse.cc:996
|
#16 0x00000000007944aa in do_handle_one_connection (thd_arg=0x7fa6e330b070) at 10.0/sql/sql_connect.cc:1379
|
#17 0x00000000007941fd in handle_one_connection (arg=0x7fa6e330b070) at 10.0/sql/sql_connect.cc:1293
|
#18 0x0000000000ccb4a6 in pfs_spawn_thread (arg=0x7fa6e33d9df0) at 10.0/storage/perfschema/pfs.cc:1860
|
#19 0x00007fa6eb184b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#20 0x00007fa6e967c20d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
revision-id: sergii@pisem.net-20141103164737-457hfby1eg82zol9
|
date: 2014-11-03 17:47:37 +0100
|
build-date: 2014-11-08 20:10:54 +0400
|
revno: 4471
|
branch-nick: 10.0
|
- relates to
-
MDEV-7057
Track most important upstream bugs which also affect MariaDB
-
-
Closed
- links to
-
{"report":{"fcp":3361.5,"ttfb":1085.8000001907349,"pageVisibility":"visible","entityId":48720,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"18eb0895-d2a5-4af7-b81a-c5f048f2830d","navigationType":0,"readyForUser":3492.5999999046326,"redirectCount":0,"resourceLoadedEnd":5259.599999904633,"resourceLoadedStart":1156.9000000953674,"resourceTiming":[{"duration":1453.9000000953674,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":1156.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1156.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2610.800000190735,"responseStart":0,"secureConnectionStart":0},{"duration":1457.1999998092651,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1157.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1157.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2614.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":1517.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":1157.4000000953674,"connectEnd":1157.4000000953674,"connectStart":1157.4000000953674,"domainLookupEnd":1157.4000000953674,"domainLookupStart":1157.4000000953674,"fetchStart":1157.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1157.4000000953674,"responseEnd":2674.9000000953674,"responseStart":2674.9000000953674,"secureConnectionStart":1157.4000000953674},{"duration":1591.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1157.5999999046326,"connectEnd":1157.5999999046326,"connectStart":1157.5999999046326,"domainLookupEnd":1157.5999999046326,"domainLookupStart":1157.5999999046326,"fetchStart":1157.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1157.5999999046326,"responseEnd":2749.0999999046326,"responseStart":2749.0999999046326,"secureConnectionStart":1157.5999999046326},{"duration":1595.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":1157.8000001907349,"connectEnd":1157.8000001907349,"connectStart":1157.8000001907349,"domainLookupEnd":1157.8000001907349,"domainLookupStart":1157.8000001907349,"fetchStart":1157.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1157.8000001907349,"responseEnd":2753.2000002861023,"responseStart":2753.0999999046326,"secureConnectionStart":1157.8000001907349},{"duration":1595.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":1158,"connectEnd":1158,"connectStart":1158,"domainLookupEnd":1158,"domainLookupStart":1158,"fetchStart":1158,"redirectEnd":0,"redirectStart":0,"requestStart":1158,"responseEnd":2753.7000002861023,"responseStart":2753.7000002861023,"secureConnectionStart":1158},{"duration":1596,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":1158.0999999046326,"connectEnd":1158.0999999046326,"connectStart":1158.0999999046326,"domainLookupEnd":1158.0999999046326,"domainLookupStart":1158.0999999046326,"fetchStart":1158.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1158.0999999046326,"responseEnd":2754.0999999046326,"responseStart":2754.0999999046326,"secureConnectionStart":1158.0999999046326},{"duration":1803.0999999046326,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":1158.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1158.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2961.300000190735,"responseStart":0,"secureConnectionStart":0},{"duration":1596.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1158.5,"connectEnd":1158.5,"connectStart":1158.5,"domainLookupEnd":1158.5,"domainLookupStart":1158.5,"fetchStart":1158.5,"redirectEnd":0,"redirectStart":0,"requestStart":1158.5,"responseEnd":2754.7000002861023,"responseStart":2754.7000002861023,"secureConnectionStart":1158.5},{"duration":1803,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":1158.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1158.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2961.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":1596.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":1158.7000002861023,"connectEnd":1158.7000002861023,"connectStart":1158.7000002861023,"domainLookupEnd":1158.7000002861023,"domainLookupStart":1158.7000002861023,"fetchStart":1158.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1158.7000002861023,"responseEnd":2755.4000000953674,"responseStart":2755.4000000953674,"secureConnectionStart":1158.7000002861023},{"duration":3304.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":1160,"connectEnd":1160,"connectStart":1160,"domainLookupEnd":1160,"domainLookupStart":1160,"fetchStart":1160,"redirectEnd":0,"redirectStart":0,"requestStart":1160,"responseEnd":4464.400000095367,"responseStart":4464.400000095367,"secureConnectionStart":1160},{"duration":4099.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":1160.0999999046326,"connectEnd":1160.0999999046326,"connectStart":1160.0999999046326,"domainLookupEnd":1160.0999999046326,"domainLookupStart":1160.0999999046326,"fetchStart":1160.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1160.0999999046326,"responseEnd":5259.599999904633,"responseStart":5259.599999904633,"secureConnectionStart":1160.0999999046326},{"duration":1546.4000000953674,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":2995.5,"connectEnd":2995.5,"connectStart":2995.5,"domainLookupEnd":2995.5,"domainLookupStart":2995.5,"fetchStart":2995.5,"redirectEnd":0,"redirectStart":0,"requestStart":2995.5,"responseEnd":4541.900000095367,"responseStart":4541.900000095367,"secureConnectionStart":2995.5},{"duration":1959.6999998092651,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":3403.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":3403.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":5362.900000095367,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":913,"responseStart":1085,"responseEnd":1090,"domLoading":1154,"domInteractive":5312,"domContentLoadedEventStart":5312,"domContentLoadedEventEnd":5362,"domComplete":6497,"loadEventStart":6497,"loadEventEnd":6498,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":5265.800000190735},{"name":"bigPipe.sidebar-id.end","time":5266.700000286102},{"name":"bigPipe.activity-panel-pipe-id.start","time":5266.800000190735},{"name":"bigPipe.activity-panel-pipe-id.end","time":5267.800000190735},{"name":"activityTabFullyLoaded","time":5385.599999904633}],"measures":[],"correlationId":"560d83e004092a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":13,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
http://lists.askmonty.org/pipermail/commits/2015-December/008695.html