summaryrefslogtreecommitdiff
path: root/mysql-test/t/sp.test
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2018-01-29 12:44:20 +0400
committerAlexander Barkov <bar@mariadb.org>2018-01-29 12:44:20 +0400
commitc7a2f23a7b751cd54dbdcff46a3e7bc1eabe4c02 (patch)
tree5f884e1fdf15a1a7d3738b1dff17a91d2c26623f /mysql-test/t/sp.test
parentb4a2baffa82e5c07b96a1c752228560dcac1359b (diff)
parentb12430adc716be51810953920448563c87fe0521 (diff)
downloadmariadb-git-c7a2f23a7b751cd54dbdcff46a3e7bc1eabe4c02.tar.gz
Merge remote-tracking branch 'origin/bb-10.2-ext' into 10.3
Diffstat (limited to 'mysql-test/t/sp.test')
-rw-r--r--mysql-test/t/sp.test34
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test
index 733e38351c3..cfcc7859af8 100644
--- a/mysql-test/t/sp.test
+++ b/mysql-test/t/sp.test
@@ -9661,6 +9661,40 @@ CALL p1();
DROP PROCEDURE p1;
--echo #
+--echo # MDEV-15057 Crash when using an unknown identifier as an SP parameter
+--echo #
+
+CREATE OR REPLACE PROCEDURE p1 (a VARCHAR(10)) SELECT 1;
+--error ER_BAD_FIELD_ERROR
+CALL p1(a);
+drop procedure p1;
+
+DELIMITER |;
+
+CREATE OR REPLACE PROCEDURE p1 (a VARCHAR(10)) SELECT a|
+CREATE OR REPLACE PROCEDURE p2 ()
+BEGIN
+ DECLARE name VARCHAR(10);
+ SET name="hello";
+ call p1(name);
+END|
+CREATE OR REPLACE PROCEDURE p3 ()
+BEGIN
+ DECLARE name VARCHAR(10);
+ SET name="hello";
+ call p1(name2);
+END|
+
+DELIMITER ;|
+
+call p2();
+--error ER_BAD_FIELD_ERROR
+call p3();
+drop procedure p1;
+drop procedure p2;
+drop procedure p3;
+
+--echo #
--echo # Start of 10.3 tests
--echo #