Debian Codegraph @

mysql-test/suite/sys_vars/t/sql_warnings_func.test

raw
1 ############# mysql-test\t\sql_warnings_func.test #########################
2 # #
3 # Variable Name: sql_warnings #
4 # Scope: SESSION #
5 # Access Type: Dynamic #
6 # Data Type: BOOLEAN #
7 # Default Value: FALSE 0 #
8 # Values: TRUE 1, FALSE 0 #
9 # #
10 # #
11 # Creation Date: 2008-03-02 #
12 # Author: Sharique Abdullah #
13 # #
14 # Description: Test Cases of Dynamic System Variable "sql_warnings" #
15 # that checks behavior of this variable in the following ways#
16 # * Functionality based on different values #
17 # #
18 # Reference: http://dev.mysql.com/doc/refman/5.1/en/set-option.html #
19 # #
20 ###########################################################################
21
22 --echo ** Setup **
23 --echo
24 #
25 # Setup
26 #
27
28 SET @default_sql_warnings = @@sql_warnings;
29
30 #
31 # Creating tables
32 #
33
34 CREATE TEMPORARY TABLE t1(a varchar(5), b varchar(20));
35
36 --enable_info
37 --disable_warnings
38
39 --echo '#-----------------------------FN_DYNVARS_167_01------------#'
40 #
41 # Value DEFAULT
42 #
43 SET @@sql_warnings = DEFAULT;
44
45 INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
46
47 --echo '#-----------------------------FN_DYNVARS_167_02------------------#'
48 #
49 # OFF value
50 #
51
52 SET @@sql_warnings = 0;
53
54 INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
55
56 --echo '#-----------------------------FN_DYNVARS_167_03---------------#'
57 #
58 # ON value
59 #
60
61 SET @@sql_warnings = 1;
62
63 INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
64
65
66 --echo '#----------------------------FN_DYNVARS_167_04---------------#'
67 #
68 # Session data integrity check Value check
69 #
70
71 --disable_info
72
73 connect (con_int1,localhost,root,,);
74
75 connection con_int1;
76 SELECT @@SESSION.sql_warnings;
77 --echo 0 / FALSE Expected
78
79 SET SESSION sql_warnings = FALSE;
80
81 connect (con_int2,localhost,root,,);
82
83 connection con_int2;
84 SELECT @@SESSION.sql_warnings;
85 --echo 0 / FALSE Expected
86
87 SET SESSION sql_warnings = TRUE;
88
89 connection con_int2;
90 SELECT @@SESSION.sql_warnings;
91 --echo 1 / TRUE Expected
92
93 connection con_int1;
94 SELECT @@SESSION.sql_warnings;
95 --echo 0 / FALSE Expected
96
97 connection default;
98
99 disconnect con_int1;
100 disconnect con_int2;
101
102
103 #
104 # Cleanup
105 #
106
107 DROP TABLE t1;
108
109 SET @@sql_warnings = @default_sql_warnings;
110
111 --disable_info
112 --enable_warnings