Debian Codegraph @

mysql-test/suite/sys_vars/r/sql_warnings_func.result

raw
1 ** Setup **
2
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;
7 affected rows: 0
8 INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
9 affected rows: 1
10 '#-----------------------------FN_DYNVARS_167_02------------------#'
11 SET @@sql_warnings = 0;
12 affected rows: 0
13 INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
14 affected rows: 1
15 '#-----------------------------FN_DYNVARS_167_03---------------#'
16 SET @@sql_warnings = 1;
17 affected rows: 0
18 INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
19 affected rows: 1
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
26 0
27 0 / FALSE Expected
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
33 0
34 0 / FALSE Expected
35 SET SESSION sql_warnings = TRUE;
36 ** Connection con_int2 **
37 SELECT @@SESSION.sql_warnings;
38 @@SESSION.sql_warnings
39 1
40 1 / TRUE Expected
41 ** Connection con_int1 **
42 SELECT @@SESSION.sql_warnings;
43 @@SESSION.sql_warnings
44 0
45 0 / FALSE Expected
46 ** Connection default **
47 Disconnecting Connections con_int1, con_int2
48 DROP TABLE t1;
49 SET @@sql_warnings = @default_sql_warnings;