diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2020-08-28 16:05:38 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-10-03 14:38:01 +0200 |
| commit | acb0c9e8fd3916cd37e895ef0a1f52f856ad047b (patch) | |
| tree | 5f5bd8017a0b15d3c54e1049b9c48fa5d58c505e /mysql-test/main/sp-destruct.test | |
| parent | bd64c2e8cc610dc774411c5f0a8ab163fc685934 (diff) | |
| download | mariadb-git-acb0c9e8fd3916cd37e895ef0a1f52f856ad047b.tar.gz | |
MDEV-23518 Syntax error in ond SP results in misleading message on SHOW CREATE PROCEDURE
Add info to the error message how to get details about error which happened.
Diffstat (limited to 'mysql-test/main/sp-destruct.test')
| -rw-r--r-- | mysql-test/main/sp-destruct.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/sp-destruct.test b/mysql-test/main/sp-destruct.test index 12299fa230b..4bdfed70545 100644 --- a/mysql-test/main/sp-destruct.test +++ b/mysql-test/main/sp-destruct.test @@ -128,20 +128,26 @@ values --error ER_SP_PROC_TABLE_CORRUPT select bug14233_1(); +show warnings; --error ER_SP_PROC_TABLE_CORRUPT create view v1 as select bug14233_1(); +show warnings; --error ER_SP_PROC_TABLE_CORRUPT select bug14233_2(); +show warnings; --error ER_SP_PROC_TABLE_CORRUPT create view v1 as select bug14233_2(); +show warnings; --error ER_SP_PROC_TABLE_CORRUPT call bug14233_3(); +show warnings; drop trigger t1_ai; create trigger t1_ai after insert on t1 for each row call bug14233_3(); --error ER_SP_PROC_TABLE_CORRUPT insert into t1 values (0); +show warnings; # Clean-up drop trigger t1_ai; |