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 connect con_int1,localhost,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 connect con_int2,localhost,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 disconnect con_int1;
48 disconnect con_int2;
49 DROP TABLE t1;
50 SET @@sql_warnings = @default_sql_warnings;