3
SET @default_sql_notes = @@sql_notes;
4
'#--------------------FN_DYNVARS_162_01-------------------------#'
5
SET SESSION sql_notes = ON;
6
creating a temporary table
7
CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
8
conditionally dropping the table twice so that a note generates
9
DROP TABLE IF EXISTS t1;
10
SELECT @@warning_count;
14
DROP TABLE IF EXISTS t1;
16
Note 1051 Unknown table 't1'
17
SELECT @@warning_count;
21
'#--------------------FN_DYNVARS_162_02-------------------------#'
22
SET SESSION sql_notes = OFF;
23
creating a temporary table
24
CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
25
conditionally dropping the table twice so that a note generates
26
DROP TABLE IF EXISTS t1;
27
SELECT @@warning_count;
31
DROP TABLE IF EXISTS t1;
32
SELECT @@warning_count;
36
'#------------------FN_DYNVARS_162_03---------------------------#'
37
** Connecting con_int1 using root **
38
** Connection con_int1 **
39
SELECT @@SESSION.sql_notes;
43
SET SESSION sql_notes = FALSE;
44
** Connecting con_int2 using root **
45
** Connection con_int2 **
46
SELECT @@SESSION.sql_notes;
50
SET SESSION sql_notes = TRUE;
51
** Connection con_int2 **
52
SELECT @@SESSION.sql_notes;
56
** Connection con_int1 **
57
SELECT @@SESSION.sql_notes;
61
** Connection default **
62
Disconnecting Connections con_int1, con_int2
63
SET SESSION sql_notes = @default_sql_notes;
64
DROP TABLE IF EXISTS t1;