--  source include/have_sequence.inc

CREATE or replace TABLE t (f bit(1), UNIQUE KEY (f) USING hash, KEY f1 (f)) engine=myisam;

INSERT INTO t SELECT 1;

INSERT INTO t SELECT seq from seq_1_to_100;

mysqld: /10.4/src/storage/myisam/ha_myisam.cc:981: void ha_myisam::setup_vcols_for_repair(HA_CHECK*): Assertion `file->s->base.reclength < file->s->vreclength || !table->s->stored_fields' failed.

211020 17:18:53 [ERROR] mysqld got signal 6 ;

Server version: 10.4.22-MariaDB-debug-log

stdlib/abort.c:81(__GI_abort)[0x7f44b5635859]

intl/loadmsgcat.c:509(get_sysdep_segment_value)[0x7f44b5635729]

:0(__GI___assert_fail)[0x7f44b5646f36]

myisam/ha_myisam.cc:983(ha_myisam::setup_vcols_for_repair(st_handler_check_param*))[0x55cb201c1349]

myisam/ha_myisam.cc:1653(ha_myisam::enable_indexes(unsigned int))[0x55cb201c7aaa]

myisam/ha_myisam.cc:1848(ha_myisam::end_bulk_insert())[0x55cb201c9168]

sql/handler.cc:4441(handler::ha_end_bulk_insert())[0x55cb1f0f31d9]

sql/sql_insert.cc:4038(select_insert::prepare_eof())[0x55cb1e825352]

sql/sql_insert.cc:4138(select_insert::send_eof())[0x55cb1e826de0]

sql/sql_select.cc:4413(JOIN::exec_inner())[0x55cb1e9955f6]

sql/sql_select.cc:4317(JOIN::exec())[0x55cb1e993f5e]

sql/sql_select.cc:4757(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55cb1e99815e]

sql/sql_select.cc:436(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55cb1e969292]

sql/sql_parse.cc:4712(mysql_execute_command(THD*))[0x55cb1e8ca5d7]

sql/sql_parse.cc:7995(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55cb1e8e1415]

sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55cb1e8b7b90]

sql/sql_parse.cc:1373(do_command(THD*))[0x55cb1e8b460d]

sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55cb1ecae0d9]

sql/sql_connect.cc:1317(handle_one_connection)[0x55cb1ecad832]

perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55cb20385679]

nptl/pthread_create.c:478(start_thread)[0x7f44b5b5d609]

x86_64/clone.S:97(__GI___clone)[0x7f44b5732293]

Query (0x62b0000a1290): INSERT INTO t SELECT 1

211020 17:10:41 [ERROR] mysqld got signal 11 ;

Server version: 10.6.4-MariaDB

mysys/stacktrace.c:213(my_print_stacktrace)[0x556db8a8499e]

sql/signal_handler.cc:225(handle_fatal_signal)[0x556db84561d7]

sigaction.c:0(__restore_rt)[0x7f8f06b103c0]

sql/sql_plist.h:126(I_P_List<MDL_ticket, I_P_List_adapter<MDL_ticket, &MDL_ticket::next_in_context, &MDL_ticket::prev_in_context>, I_P_List_null_counter, I_P_List_no_push_back<MDL_ticket> >::remove(MDL_ticket*))[0x556db833fdc1]

sql/sql_plist.h:196(I_P_List_iterator<MDL_ticket, I_P_List<MDL_ticket, I_P_List_adapter<MDL_ticket, &MDL_ticket::next_in_context, &MDL_ticket::prev_in_context>, I_P_List_null_counter, I_P_List_no_push_back<MDL_ticket> > >::operator++(int))[0x556db833fe35]

sql/sql_class.h:5000(THD::release_transactional_locks())[0x556db8238be6]

sql/sql_parse.cc:8031(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556db823da6b]

sql/sql_parse.cc:1955(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556db823fcd7]

sql/sql_parse.cc:1406(do_command(THD*, bool))[0x556db8241373]

sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x556db8335f97]

sql/sql_connect.cc:1318(handle_one_connection)[0x556db8336234]

perfschema/pfs.cc:2204(pfs_spawn_thread)[0x556db86bd8d2]

nptl/pthread_create.c:478(start_thread)[0x7f8f06b04609]

x86_64/clone.S:97(__GI___clone)[0x7f8f066f2293]

Query (0x7f8ea8012d50): INSERT INTO t SELECT seq from seq_1_to_100

CREATE TABLE t (c BIT KEY,c2 BIT) ENGINE=MyISAM;

CREATE UNIQUE INDEX i1 USING HASH ON t (c);

mysqld: /test/10.10_dbg/storage/myisam/ha_myisam.cc:982: void ha_myisam::setup_vcols_for_repair(HA_CHECK*): Assertion `file->s->base.reclength < file->s->vreclength || !table->s->stored_fields' failed.

Core was generated by `/test/MD310522-mariadb-10.10.0-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 0x148b340ae700 (LWP 2837868))]

(gdb) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x0000148b4b61b859 in __GI_abort () at abort.c:79

#2  0x0000148b4b61b729 in __assert_fail_base (fmt=0x148b4b7b1588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55bb758a05b0 "file->s->base.reclength < file->s->vreclength || !table->s->stored_fields", file=0x55bb758a0268 "/test/10.10_dbg/storage/myisam/ha_myisam.cc", line=982, function=<optimized out>) at assert.c:92

#3  0x0000148b4b62cfd6 in __GI___assert_fail (assertion=assertion@entry=0x55bb758a05b0 "file->s->base.reclength < file->s->vreclength || !table->s->stored_fields", file=file@entry=0x55bb758a0268 "/test/10.10_dbg/storage/myisam/ha_myisam.cc", line=line@entry=982, function=function@entry=0x55bb758a0578 "void ha_myisam::setup_vcols_for_repair(HA_CHECK*)") at assert.c:101

#4  0x000055bb753efa10 in ha_myisam::setup_vcols_for_repair (this=this@entry=0x148afc02a630, param=param@entry=0x148afc032080) at /test/10.10_dbg/storage/myisam/ha_myisam.cc:982

#5  0x000055bb753f152d in ha_myisam::enable_indexes (this=this@entry=0x148afc02a630, mode=mode@entry=2) at /test/10.10_dbg/storage/myisam/ha_myisam.cc:1652

#6  0x000055bb753f16d6 in ha_myisam::end_bulk_insert (this=0x148afc02a630) at /test/10.10_dbg/storage/myisam/ha_myisam.cc:1849

#7  0x000055bb74d0307b in handler::ha_end_bulk_insert (this=0x148afc02a630) at /test/10.10_dbg/sql/handler.cc:5019

#8  0x000055bb74af9206 in copy_data_between_tables (alter_ctx=0x148b340ac210, keys_onoff=<optimized out>, deleted=<synthetic pointer>, copied=<synthetic pointer>, order=<optimized out>, order_num=<optimized out>, ignore=<optimized out>, create=@0x148b340acaf0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x0, last = 0x0, elements = 4294967280}, <No data fields>}, to=0x148afc0295d8, from=0x148afc01b808, thd=0x148afc000db8) at /test/10.10_dbg/sql/sql_table.cc:11707

#9  mysql_alter_table (thd=thd@entry=0x148afc000db8, new_db=new_db@entry=0x148afc013d50, new_name=new_name@entry=0x148afc013d60, create_info=create_info@entry=0x148b340ad030, table_list=<optimized out>, table_list@entry=0x148afc013d38, alter_info=alter_info@entry=0x148b340acf40, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.10_dbg/sql/sql_table.cc:10877

#10 0x000055bb74a18aa9 in mysql_execute_command (thd=thd@entry=0x148afc000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.10_dbg/sql/structs.h:569

#11 0x000055bb74a05e3a in mysql_parse (thd=thd@entry=0x148afc000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x148b340ad470) at /test/10.10_dbg/sql/sql_parse.cc:8036

#12 0x000055bb74a13422 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148afc000db8, packet=packet@entry=0x148afc00b6d9 "", packet_length=packet_length@entry=42, blocking=blocking@entry=true) at /test/10.10_dbg/sql/sql_class.h:1364

#13 0x000055bb74a15b2c in do_command (thd=0x148afc000db8, blocking=blocking@entry=true) at /test/10.10_dbg/sql/sql_parse.cc:1407

#14 0x000055bb74b753c0 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55bb76dafa28, put_in_cache=put_in_cache@entry=true) at /test/10.10_dbg/sql/sql_connect.cc:1418

#15 0x000055bb74b758c9 in handle_one_connection (arg=0x55bb76dafa28) at /test/10.10_dbg/sql/sql_connect.cc:1312

#16 0x0000148b4bb2c609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#17 0x0000148b4b718133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

CREATE TABLE t (f BIT,UNIQUE KEY(f) USING HASH) ENGINE=MyISAM;

OPTIMIZE TABLE t;

mysqld: /test/10.11_dbg/storage/myisam/ha_myisam.cc:982: void ha_myisam::setup_vcols_for_repair(HA_CHECK*): Assertion `file->s->base.reclength < file->s->vreclength || !table->s->stored_fields' failed.

Core was generated by `/test/MD190822-mariadb-10.11.0-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 0x14c42e40c700 (LWP 3766859))]

(gdb) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x000014c457991859 in __GI_abort () at abort.c:79

#2  0x000014c457991729 in __assert_fail_base (fmt=0x14c457b27588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x556e8b6776d0 "file->s->base.reclength < file->s->vreclength || !table->s->stored_fields", file=0x556e8b677388 "/test/10.11_dbg/storage/myisam/ha_myisam.cc", line=982, function=<optimized out>) at assert.c:92

#3  0x000014c4579a2fd6 in __GI___assert_fail (assertion=assertion@entry=0x556e8b6776d0 "file->s->base.reclength < file->s->vreclength || !table->s->stored_fields", file=file@entry=0x556e8b677388 "/test/10.11_dbg/storage/myisam/ha_myisam.cc", line=line@entry=982, function=function@entry=0x556e8b677698 "void ha_myisam::setup_vcols_for_repair(HA_CHECK*)") at assert.c:101

#4  0x0000556e8b1b6b2a in ha_myisam::setup_vcols_for_repair (this=this@entry=0x14c3dc021a50, param=param@entry=0x14c3dc0316c0) at /test/10.11_dbg/storage/myisam/ha_myisam.cc:982

#5  0x0000556e8b1b836b in ha_myisam::optimize (this=0x14c3dc021a50, thd=0x14c3dc000db8, check_opt=0x14c3dc006298) at /test/10.11_dbg/storage/myisam/ha_myisam.cc:1221

#6  0x0000556e8aadf1b4 in handler::ha_optimize (this=0x14c3dc021a50, thd=0x14c3dc000db8, check_opt=0x14c3dc006298) at /test/10.11_dbg/sql/handler.cc:5119

#7  0x0000556e8a95ff3a in mysql_admin_table (thd=thd@entry=0x14c3dc000db8, tables=tables@entry=0x14c3dc013cf8, check_opt=check_opt@entry=0x14c3dc006298, operator_name=operator_name@entry=0x556e8bb43d60 <msg_optimize>, lock_type=lock_type@entry=TL_WRITE, org_open_for_modify=org_open_for_modify@entry=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x556e8aadf118 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0, is_cmd_replicated=true) at /test/10.11_dbg/sql/sql_admin.cc:874

#8  0x0000556e8a962cc4 in Sql_cmd_optimize_table::execute (this=<optimized out>, thd=0x14c3dc000db8) at /test/10.11_dbg/sql/sql_admin.cc:1523

#9  0x0000556e8a7f51fa in mysql_execute_command (thd=thd@entry=0x14c3dc000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.11_dbg/sql/sql_parse.cc:5997

#10 0x0000556e8a7dd882 in mysql_parse (thd=thd@entry=0x14c3dc000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14c42e40b330) at /test/10.11_dbg/sql/sql_parse.cc:8035

#11 0x0000556e8a7eae6a in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14c3dc000db8, packet=packet@entry=0x14c3dc00b6e9 "", packet_length=packet_length@entry=16, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_class.h:1339

#12 0x0000556e8a7ed574 in do_command (thd=0x14c3dc000db8, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_parse.cc:1407

#13 0x0000556e8a94f1da in do_handle_one_connection (connect=<optimized out>, connect@entry=0x556e8cdec328, put_in_cache=put_in_cache@entry=true) at /test/10.11_dbg/sql/sql_connect.cc:1418

#14 0x0000556e8a94f6e3 in handle_one_connection (arg=0x556e8cdec328) at /test/10.11_dbg/sql/sql_connect.cc:1312

#15 0x000014c457ea2609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#16 0x000014c457a8e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

CREATE TABLE t (b INT,c INT,d BIT,v BIT AS (d) VIRTUAL,KEY(b,v)) ENGINE=MyISAM PARTITION BY HASH (b);

REPAIR TABLE t USE_FRM;