--source include/have_sequence.inc

CREATE TABLE t1 SELECT 'x' AS f1 FROM seq_1_to_100;

CREATE TABLE t2 SELECT NULL AS f2;

--connect (con1,localhost,root,,)

DELETE FROM t1 WHERE f1 = 1;

--connection default

SET sql_mode= 'ORACLE';

--delimiter $

CREATE PACKAGE pkg IS PROCEDURE p; END $

CREATE PACKAGE BODY pkg IS PROCEDURE p AS BEGIN ALTER TABLE t2 ENGINE=HEAP; END; END $

--delimiter ;

--send

  CALL pkg.p;

--connection con1

SHOW WARNINGS;

INSERT INTO t2 VALUES (NULL);

--connection default

--reap

CALL pkg.p;

# Cleanup

DROP TABLE t1, t2;

DROP PACKAGE pkg;

(rr) bt

#0  LEX::first_lists_tables_same (this=0x7f8358310b90) at /data/src/bb-11.0-oalter-debug/sql/sql_lex.cc:4497

#1  0x000055dd0c750bcf in mysql_execute_command (thd=0x7f8358000dc8, is_called_from_prepared_stmt=false) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:3503

#2  0x000055dd0c649e2b in sp_instr_stmt::exec_core (this=0x7f8358310478, thd=0x7f8358000dc8, nextp=0x7f83693a1f4c) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:3857

#3  0x000055dd0c649149 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f83583104c0, thd=0x7f8358000dc8, nextp=0x7f83693a1f4c, open_tables=false, instr=0x7f8358310478)

    at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:3582

#4  0x000055dd0c6499db in sp_instr_stmt::execute (this=0x7f8358310478, thd=0x7f8358000dc8, nextp=0x7f83693a1f4c) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:3763

#5  0x000055dd0c642977 in sp_head::execute (this=0x7f835830eb00, thd=0x7f8358000dc8, merge_da_on_success=true) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:1459

#6  0x000055dd0c64569c in sp_head::execute_procedure (this=0x7f835830eb00, thd=0x7f8358000dc8, args=0x7f8358006148) at /data/src/bb-11.0-oalter-debug/sql/sp_head.cc:2446

#7  0x000055dd0c74ebaa in do_execute_sp (thd=0x7f8358000dc8, sp=0x7f835830eb00) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:3026

#8  0x000055dd0c74f82c in Sql_cmd_call::execute (this=0x7f8358015598, thd=0x7f8358000dc8) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:3271

#9  0x000055dd0c759a9d in mysql_execute_command (thd=0x7f8358000dc8, is_called_from_prepared_stmt=false) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:6001

#10 0x000055dd0c75fc14 in mysql_parse (thd=0x7f8358000dc8, rawbuf=0x7f83580154d0 "CALL pkg.p", length=10, parser_state=0x7f83693a3370) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:8000

#11 0x000055dd0c74b87f in dispatch_command (command=COM_QUERY, thd=0x7f8358000dc8, packet=0x7f835800ba59 "CALL pkg.p", packet_length=10, blocking=true)

    at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:1894

#12 0x000055dd0c74a1e6 in do_command (thd=0x7f8358000dc8, blocking=true) at /data/src/bb-11.0-oalter-debug/sql/sql_parse.cc:1407

#13 0x000055dd0c93ca52 in do_handle_one_connection (connect=0x55dd1115d1d8, put_in_cache=true) at /data/src/bb-11.0-oalter-debug/sql/sql_connect.cc:1416

#14 0x000055dd0c93c7c7 in handle_one_connection (arg=0x55dd111aa068) at /data/src/bb-11.0-oalter-debug/sql/sql_connect.cc:1318

#15 0x000055dd0ce5c240 in pfs_spawn_thread (arg=0x55dd1115cc68) at /data/src/bb-11.0-oalter-debug/storage/perfschema/pfs.cc:2201

#16 0x00007f836f8a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

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