3
SET @default_sql_warnings = @@sql_warnings;
4
CREATE TEMPORARY TABLE t1(a varchar(5), b varchar(20));
5
'#-----------------------------FN_DYNVARS_167_01------------#'
6
SET @@sql_warnings = DEFAULT;
8
INSERT INTO t1 VALUES('abcdef', 'val1');
10
'#-----------------------------FN_DYNVARS_167_02------------------#'
11
SET @@sql_warnings = 0;
13
INSERT INTO t1 VALUES('abcdef', 'val1');
15
'#-----------------------------FN_DYNVARS_167_03---------------#'
16
SET @@sql_warnings = 1;
18
INSERT INTO t1 VALUES('abcdef', 'val1');
20
info: Records: 1 Duplicates: 0 Warnings: 1
21
'#----------------------------FN_DYNVARS_167_04---------------#'
22
** Connecting con_int1 using root **
23
** Connection con_int1 **
24
SELECT @@SESSION.sql_warnings;
25
@@SESSION.sql_warnings
28
SET SESSION sql_warnings = FALSE;
29
** Connecting con_int2 using root **
30
** Connection con_int2 **
31
SELECT @@SESSION.sql_warnings;
32
@@SESSION.sql_warnings
35
SET SESSION sql_warnings = TRUE;
36
** Connection con_int2 **
37
SELECT @@SESSION.sql_warnings;
38
@@SESSION.sql_warnings
41
** Connection con_int1 **
42
SELECT @@SESSION.sql_warnings;
43
@@SESSION.sql_warnings
46
** Connection default **
47
Disconnecting Connections con_int1, con_int2
49
SET @@sql_warnings = @default_sql_warnings;