MDEV-13720

[midenok]

https://jira.mariadb.org/browse/MDEV-13720

CREATE TEMPORARY TABLE tmp (i INT);
SELECT NEXT VALUE FOR tmp;

Assertion for temporary table

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#1  0x00007ffff644cf5d in __GI_abort () at abort.c:90
#2  0x00007ffff6442f17 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5555567f0b20 "table && table->s->sequence", file=file@entry=0x5555567f0020 "/home/midenok/src/mariadb/midenok/src/sql/item_func.cc", line=line@entry=6960, function=function@entry=0x5555567f31e0 <Item_func_nextval::val_int()::__PRETTY_FUNCTION__> "virtual longlong Item_func_nextval::val_int()") at assert.c:92
#3  0x00007ffff6442fc2 in __GI___assert_fail (assertion=0x5555567f0b20 "table && table->s->sequence", file=0x5555567f0020 "/home/midenok/src/mariadb/midenok/src/sql/item_func.cc", line=6960, function=0x5555567f31e0 <Item_func_nextval::val_int()::__PRETTY_FUNCTION__> "virtual longlong Item_func_nextval::val_int()") at assert.c:101
#4  0x0000555555e95a79 in Item_func_nextval::val_int (this=0x7fff78013b58) at /home/midenok/src/mariadb/midenok/src/sql/item_func.cc:6960
#5  0x0000555555e2f697 in Item::send (this=0x7fff78013b58, protocol=0x7fff780012f0, buffer=0x7fffe54b0af0) at /home/midenok/src/mariadb/midenok/src/sql/item.cc:7163
#6  0x0000555555a8c40d in Protocol::send_result_set_row (this=0x7fff780012f0, row_items=0x7fff780051c8) at /home/midenok/src/mariadb/midenok/src/sql/protocol.cc:979
#7  0x0000555555b0fbdf in select_send::send_data (this=0x7fff78013d00, items=...) at /home/midenok/src/mariadb/midenok/src/sql/sql_class.cc:2803
#8  0x0000555555bab9ff in JOIN::exec_inner (this=0x7fff78013d20) at /home/midenok/src/mariadb/midenok/src/sql/sql_select.cc:3755
#9  0x0000555555bab3da in JOIN::exec (this=0x7fff78013d20) at /home/midenok/src/mariadb/midenok/src/sql/sql_select.cc:3675
#10 0x0000555555bac881 in mysql_select (thd=0x7fff78000d50, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fff78013d00, unit=0x7fff78004938, select_lex=0x7fff78005098) at /home/midenok/src/mariadb/midenok/src/sql/sql_select.cc:4077
#11 0x0000555555b9ec82 in handle_select (thd=0x7fff78000d50, lex=0x7fff78004870, result=0x7fff78013d00, setup_tables_done_option=0) at /home/midenok/src/mariadb/midenok/src/sql/sql_select.cc:363
#12 0x0000555555b69dde in execute_sqlcom_select (thd=0x7fff78000d50, all_tables=0x7fff78013520) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:6476
#13 0x0000555555b6195e in mysql_execute_command (thd=0x7fff78000d50) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:3575
#14 0x0000555555b6d100 in mysql_parse (thd=0x7fff78000d50, rawbuf=0x7fff78013438 "SELECT NEXT VALUE FOR tmp2", length=26, parser_state=0x7fffe54b26a0, is_com_multi=false, is_next_command=false) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7923

[midenok]

not a SEQUENCE error

#0  my_error (nr=4064, MyFlags=0) at /home/midenok/src/mariadb/midenok/src/mysys/my_error.c:109
#1  0x0000555555ae36b6 in open_table (thd=0x7fff78000d50, table_list=0x7fff78013518, ot_ctx=0x7fffe54b1020) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:1939
#2  0x0000555555ae6065 in open_and_process_table (thd=0x7fff78000d50, lex=0x7fff78004870, tables=0x7fff78013518, counter=0x7fffe54b10b4, flags=0, prelocking_strategy=0x7fffe54b1140, has_prelocking_list=false, ot_ctx=0x7fffe54b1020) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:3414
#3  0x0000555555ae725e in open_tables (thd=0x7fff78000d50, options=..., start=0x7fffe54b1098, counter=0x7fffe54b10b4, flags=0, prelocking_strategy=0x7fffe54b1140) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:3932
#4  0x0000555555ae88e5 in open_and_lock_tables (thd=0x7fff78000d50, options=..., tables=0x7fff78013518, derived=true, flags=0, prelocking_strategy=0x7fffe54b1140) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:4687
#5  0x0000555555adba44 in open_and_lock_tables (thd=0x7fff78000d50, tables=0x7fff78013518, derived=true, flags=0) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.h:495
#6  0x0000555555b69938 in execute_sqlcom_select (thd=0x7fff78000d50, all_tables=0x7fff78013518) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:6397
#7  0x0000555555b6195e in mysql_execute_command (thd=0x7fff78000d50) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:3575
#8  0x0000555555b6d100 in mysql_parse (thd=0x7fff78000d50, rawbuf=0x7fff78013438 "SELECT NEXT VALUE FOR tmp", length=25, parser_state=0x7fffe54b26a0, is_com_multi=false, is_next_command=false) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7923

[midenok]

Fixed in 13720-sequence