summaryrefslogtreecommitdiff
path: root/mysql-test/r/nested_profiling.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2020-07-01 11:32:21 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2020-07-01 12:03:55 +0300
commitea2bc974dce2ac509011807c80b36192cd18f686 (patch)
treeafbed3c29a2af90c44af2f086c6eb0d83c909840 /mysql-test/r/nested_profiling.result
parentfbfb5b5f68a428ec819bc09d14b30cebf660b37b (diff)
parent1ea266f3ef36e779d23697b18cb94e1b0f8e65ef (diff)
downloadmariadb-git-bb-10.2-merge.tar.gz
Merge 10.1 into 10.2bb-10.2-merge
Diffstat (limited to 'mysql-test/r/nested_profiling.result')
-rw-r--r--mysql-test/r/nested_profiling.result20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/nested_profiling.result b/mysql-test/r/nested_profiling.result
new file mode 100644
index 00000000000..b8bceba480a
--- /dev/null
+++ b/mysql-test/r/nested_profiling.result
@@ -0,0 +1,20 @@
+SET @saved_profiling=@@GLOBAL.profiling;
+SET @saved_init_connect=@@GLOBAL.init_connect;
+SET GLOBAL init_connect="set @a=2;set @b=3";
+SET GLOBAL profiling=on;
+create user mysqltest1@localhost;
+connect con1,localhost,mysqltest1,,;
+connection con1;
+SELECT @a, @b;
+@a @b
+2 3
+SHOW PROFILES;
+Query_ID Duration Query
+1 # set @a=2;set @b=3
+2 # set @b=3
+3 # SELECT @a, @b
+connection default;
+disconnect con1;
+DROP USER mysqltest1@localhost;
+SET GLOBAL profiling=@saved_profiling;
+SET GLOBAL init_connect=@saved_init_connect;