summaryrefslogtreecommitdiff
path: root/tests/files/mysql_handler.sql
diff options
context:
space:
mode:
authorAndi Albrecht <albrecht.andi@gmail.com>2020-09-30 09:31:40 +0200
committerAndi Albrecht <albrecht.andi@gmail.com>2020-09-30 09:31:40 +0200
commit990500a149920b02b2b6e5ffe6e747dea7c6739e (patch)
treeac08759cd29dc2fa388766c0fbdbb92d9528da59 /tests/files/mysql_handler.sql
parentcd4a723ee509437166b0f3e0fd62322ecc7bbd99 (diff)
downloadsqlparse-990500a149920b02b2b6e5ffe6e747dea7c6739e.tar.gz
Fix splitting when using DECLARE ... HANDLER (fixes #581).
Diffstat (limited to 'tests/files/mysql_handler.sql')
-rw-r--r--tests/files/mysql_handler.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/tests/files/mysql_handler.sql b/tests/files/mysql_handler.sql
new file mode 100644
index 0000000..702374e
--- /dev/null
+++ b/tests/files/mysql_handler.sql
@@ -0,0 +1,10 @@
+create procedure proc1()
+begin
+ declare handler for foo begin end;
+ select 1;
+end;
+
+create procedure proc2()
+begin
+ select 1;
+end;