1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/main/multi_statement.test b/mysql-test/main/multi_statement.test
new file mode 100644
index 00000000..40be1193
--- /dev/null
+++ b/mysql-test/main/multi_statement.test
@@ -0,0 +1,40 @@
+# view-protocol doesn't support multi-statements
+-- source include/no_view_protocol.inc
+
+# PS doesn't support multi-statements
+--disable_ps_protocol
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+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';
+
+# Bug #8475: Make sure every statement that is a slow query in
+# a multi-statement query gets logged as a slow query.
+flush status;
+delimiter ||||;
+create table t1 (i int);
+insert into t1 values (1);
+select * from t1 where i = 1;
+insert into t1 values (2),(3),(4);
+select * from t1 where i = 2;
+select * from t1 where i = 3||||
+show status like 'Slow_queries'||||
+drop table t1||||
+
+delimiter ;||||
+
+# End of 4.1 tests