summaryrefslogtreecommitdiff
path: root/mysql-test/t/multi_statement.test
diff options
context:
space:
mode:
authorunknown <jani@rhols221.adsl.netsonic.fi>2003-12-16 06:09:44 +0200
committerunknown <jani@rhols221.adsl.netsonic.fi>2003-12-16 06:09:44 +0200
commit3467862b329628952320146f589fc97ddd021182 (patch)
tree4c5e390cf6c8ffe67f23747a8cea58491acc274c /mysql-test/t/multi_statement.test
parentcaf4fd96f26a25f57e10d578d518f0a63109df2b (diff)
downloadmariadb-git-3467862b329628952320146f589fc97ddd021182.tar.gz
Added support for multi statement tests. Use mysqltest internal
command delimiter to change the default delimiter (;) to something else, a string upto 16 characters is allowed. Separate the sub queries with ';' and end the whole statement with your own delimiter.
Diffstat (limited to 'mysql-test/t/multi_statement.test')
-rw-r--r--mysql-test/t/multi_statement.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/multi_statement.test b/mysql-test/t/multi_statement.test
new file mode 100644
index 00000000000..bd90275c9f5
--- /dev/null
+++ b/mysql-test/t/multi_statement.test
@@ -0,0 +1,13 @@
+select 1;
+delimiter ||||;
+select 2;
+select 3;
+select 4||||
+delimiter 'abcd'||||
+select 5;
+select 6;
+select 50, 'abc';'abcd'
+select "abcd'";'abcd'select "'abcd";'abcd'
+select 5'abcd'
+delimiter ;'abcd'
+select 'finish';