1** Setup **
2
3SET @default_sql_notes = @@sql_notes;
4'#--------------------FN_DYNVARS_162_01-------------------------#'
5SET SESSION sql_notes = ON;
6creating a temporary table
7CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
8conditionally dropping the table twice so that a note generates
9DROP TABLE IF EXISTS t1;
10SELECT @@warning_count;
11@@warning_count
120
130 Expected
14DROP TABLE IF EXISTS t1;
15Warnings:
16Note	1051	Unknown table 'test.t1'
17SELECT @@warning_count;
18@@warning_count
191
201 Expected
21'#--------------------FN_DYNVARS_162_02-------------------------#'
22SET SESSION sql_notes = OFF;
23creating a temporary table
24CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
25conditionally dropping the table twice so that a note generates
26DROP TABLE IF EXISTS t1;
27SELECT @@warning_count;
28@@warning_count
290
300 Expected
31DROP TABLE IF EXISTS t1;
32SELECT @@warning_count;
33@@warning_count
340
350 Expected
36'#------------------FN_DYNVARS_162_03---------------------------#'
37connect  con_int1,localhost,root,,;
38connection con_int1;
39SELECT @@SESSION.sql_notes;
40@@SESSION.sql_notes
411
421 / TRUE Expected
43SET SESSION sql_notes = FALSE;
44connect  con_int2,localhost,root,,;
45connection con_int2;
46SELECT @@SESSION.sql_notes;
47@@SESSION.sql_notes
481
491 / TRUE Expected
50SET SESSION sql_notes = TRUE;
51connection con_int2;
52SELECT @@SESSION.sql_notes;
53@@SESSION.sql_notes
541
551 / TRUE Expected
56connection con_int1;
57SELECT @@SESSION.sql_notes;
58@@SESSION.sql_notes
590
600 / FALSE Expected
61connection default;
62disconnect con_int1;
63disconnect con_int2;
64SET SESSION sql_notes = @default_sql_notes;
65DROP TABLE IF EXISTS t1;
66