From 2999492c3278528ceb9f37bd6cfca5ca5295ef9a Mon Sep 17 00:00:00 2001
From: Oleksandr Byelkin <sanja@mariadb.com>
Date: Thu, 20 Dec 2018 11:22:13 +0100
Subject: MDEV-16036: Debug assertion failed in resignal on create temporary
 table

Reising condition on NOTW controlled by OPTION_SQL_NOTES.
---
 mysql-test/main/sp.result | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)

(limited to 'mysql-test/main/sp.result')

diff --git a/mysql-test/main/sp.result b/mysql-test/main/sp.result
index 64668e0c8ec..b7a2f865c1d 100644
--- a/mysql-test/main/sp.result
+++ b/mysql-test/main/sp.result
@@ -8731,3 +8731,38 @@ t1	CREATE TABLE `t1` (
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
 DROP TABLE t1;
 DROP FUNCTION f1;
+#
+# MDEV-16036: Debug assertion failed in resignal on create
+# temporary table 
+#
+set @save_sql_mode= @@sql_mode;
+set sql_mode='ORACLE';
+CREATE or replace procedure p4()
+AS
+CONTINUE HANDLER FOR SQLWARNING
+BEGIN
+NULL;
+END;
+EXIT HANDLER FOR OTHERS -- SQLEXCEPTION
+BEGIN
+GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE, @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
+SELECT @sqlstate, @errno, @text;
+SHOW WARNINGS;
+RESIGNAL;  -- cause DBG_ASSERT failed
+END;
+BEGIN
+CREATE TEMPORARY TABLE IF NOT EXISTS t1(origine VARCHAR2(10) NOT NULL);
+END
+/
+call p4();
+call p4();
+@sqlstate	@errno	@text
+42S01	1050	Table 't1' already exists
+Level	Code	Message
+Note	1050	Table 't1' already exists
+Warnings:
+Note	1050	Table 't1' already exists
+drop procedure p4;
+drop table t1;
+set @@sql_mode=@save_sql_mode;
+# End of 10.3 tests
-- 
cgit v1.2.1