CREATE SEQUENCE s;

LOCK TABLE s READ;

SELECT NEXTVAL(s);

# Cleanup

DROP SEQUENCE s;

mysqld: /data/src/bb-10.2-compatibility/sql/handler.cc:6135: int handler::ha_write_row(uchar*): Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type == 1' failed.

180331  1:24:47 [ERROR] mysqld got signal 6 ;

#7  0x00007ffa43a83ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x000055d037dee244 in handler::ha_write_row (this=0x7ffa2c0779a8, buf=0x7ffa2c006878 "\377\351\003") at /data/src/bb-10.2-compatibility/sql/handler.cc:6134

#9  0x000055d037d0a729 in sequence_definition::write (this=0x7ffa2c08fd58, table=0x7ffa2c076d70, all_fields=false) at /data/src/bb-10.2-compatibility/sql/sql_sequence.cc:603

#10 0x000055d037d0aa8f in SEQUENCE::next_value (this=0x7ffa2c08fd58, table=0x7ffa2c076d70, second_round=false, error=0x7ffa3dc28250) at /data/src/bb-10.2-compatibility/sql/sql_sequence.cc:710

#11 0x000055d037e6c9ac in Item_func_nextval::val_int (this=0x7ffa2c012f10) at /data/src/bb-10.2-compatibility/sql/item_func.cc:6939

#12 0x000055d037cf4605 in Type_handler::Item_send_longlong (this=0x55d0391f4930 <type_handler_longlong>, item=0x7ffa2c012f10, protocol=0x7ffa2c0010c0, buf=0x7ffa3dc28440) at /data/src/bb-10.2-compatibility/sql/sql_type.cc:5289

#13 0x000055d037cf85de in Type_handler_longlong::Item_send (this=0x55d0391f4930 <type_handler_longlong>, item=0x7ffa2c012f10, protocol=0x7ffa2c0010c0, buf=0x7ffa3dc28440) at /data/src/bb-10.2-compatibility/sql/sql_type.h:2232

#14 0x000055d037a38d40 in Item::send (this=0x7ffa2c012f10, protocol=0x7ffa2c0010c0, buffer=0x7ffa3dc28440) at /data/src/bb-10.2-compatibility/sql/item.h:807

#15 0x000055d037a347ba in Protocol::send_result_set_row (this=0x7ffa2c0010c0, row_items=0x7ffa2c005088) at /data/src/bb-10.2-compatibility/sql/protocol.cc:985

#16 0x000055d037ad3d86 in select_send::send_data (this=0x7ffa2c013098, items=...) at /data/src/bb-10.2-compatibility/sql/sql_class.cc:2921

#17 0x000055d037b6f90f in JOIN::exec_inner (this=0x7ffa2c0130b8) at /data/src/bb-10.2-compatibility/sql/sql_select.cc:3505

#18 0x000055d037b6f382 in JOIN::exec (this=0x7ffa2c0130b8) at /data/src/bb-10.2-compatibility/sql/sql_select.cc:3424

#19 0x000055d037b7054d in mysql_select (thd=0x7ffa2c000b00, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2149845760, result=0x7ffa2c013098, unit=0x7ffa2c004820, select_lex=0x7ffa2c004f60) at /data/src/bb-10.2-compatibility/sql/sql_select.cc:3824

#20 0x000055d037b64950 in handle_select (thd=0x7ffa2c000b00, lex=0x7ffa2c004758, result=0x7ffa2c013098, setup_tables_done_option=0) at /data/src/bb-10.2-compatibility/sql/sql_select.cc:379

#21 0x000055d037b30f93 in execute_sqlcom_select (thd=0x7ffa2c000b00, all_tables=0x7ffa2c0128f8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6511

#22 0x000055d037b2792e in mysql_execute_command (thd=0x7ffa2c000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3736

#23 0x000055d037b34a64 in mysql_parse (thd=0x7ffa2c000b00, rawbuf=0x7ffa2c012828 "SELECT NEXTVAL(s)", length=17, parser_state=0x7ffa3dc2a200, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7978

#24 0x000055d037b226d5 in dispatch_command (command=COM_QUERY, thd=0x7ffa2c000b00, packet=0x7ffa2c08bca1 "", packet_length=17, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835

#25 0x000055d037b21019 in do_command (thd=0x7ffa2c000b00) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383

#26 0x000055d037c736a6 in do_handle_one_connection (connect=0x55d03b5c9b90) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335

#27 0x000055d037c73433 in handle_one_connection (arg=0x55d03b5c9b90) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241

#28 0x000055d0380ca66c in pfs_spawn_thread (arg=0x55d03b513560) at /data/src/bb-10.2-compatibility/storage/perfschema/pfs.cc:1862

#29 0x00007ffa4575a494 in start_thread (arg=0x7ffa3dc2b700) at pthread_create.c:333

#30 0x00007ffa43b4093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

mysqltest: At line 3: query 'SELECT NEXTVAL(s)' failed: 1036: Table './test/s.MYI' is read only