summaryrefslogtreecommitdiff
path: root/mysql-test/t/multi_statement.test
diff options
context:
space:
mode:
authorjani@rhols221.adsl.netsonic.fi <>2003-12-16 06:09:44 +0200
committerjani@rhols221.adsl.netsonic.fi <>2003-12-16 06:09:44 +0200
commit96555b5f90bcd753a39ce89d197cbcef102fa6c2 (patch)
tree4c5e390cf6c8ffe67f23747a8cea58491acc274c /mysql-test/t/multi_statement.test
parentcde713023ad4e6d6dd85b336d0ea8e4ee26b1415 (diff)
downloadmariadb-git-96555b5f90bcd753a39ce89d197cbcef102fa6c2.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';