1 files changed, 64 insertions, 0 deletions
diff --git a/mysql-test/r/sql_notes_func.result b/mysql-test/r/sql_notes_func.result
new file mode 100644
index 00000000000..87c4ecb8431
--- /dev/null
+++ b/mysql-test/r/sql_notes_func.result
@@ -0,0 +1,64 @@
+** Setup **
+
+SET @default_sql_notes = @@sql_notes;
+'#--------------------FN_DYNVARS_162_01-------------------------#'
+SET SESSION sql_notes = ON;
+creating a temporary table
+CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
+conditionally dropping the table twice so that a note generates
+DROP TABLE IF EXISTS t1;
+SELECT @@warning_count;
+@@warning_count
+0
+0 Expected
+DROP TABLE IF EXISTS t1;
+Warnings:
+Note	1051	Unknown table 't1'
+SELECT @@warning_count;
+@@warning_count
+1
+1 Expected
+'#--------------------FN_DYNVARS_162_02-------------------------#'
+SET SESSION sql_notes = OFF;
+creating a temporary table
+CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
+conditionally dropping the table twice so that a note generates
+DROP TABLE IF EXISTS t1;
+SELECT @@warning_count;
+@@warning_count
+0
+0 Expected
+DROP TABLE IF EXISTS t1;
+SELECT @@warning_count;
+@@warning_count
+0
+0 Expected
+'#------------------FN_DYNVARS_162_03---------------------------#'
+** Connecting con_int1 using root **
+** Connection con_int1 **
+SELECT @@SESSION.sql_notes;
+@@SESSION.sql_notes
+1
+1 / TRUE Expected
+SET SESSION sql_notes = FALSE;
+** Connecting con_int2 using root **
+** Connection con_int2 **
+SELECT @@SESSION.sql_notes;
+@@SESSION.sql_notes
+1
+1 / TRUE Expected
+SET SESSION sql_notes = TRUE;
+** Connection con_int2 **
+SELECT @@SESSION.sql_notes;
+@@SESSION.sql_notes
+1
+1 / TRUE Expected
+** Connection con_int1 **
+SELECT @@SESSION.sql_notes;
+@@SESSION.sql_notes
+0
+0 / FALSE Expected
+** Connection default **
+Disconnecting Connections con_int1, con_int2
+SET SESSION sql_notes = @default_sql_notes;
+DROP TABLE IF EXISTS t1;