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 --echo ** Connecting con_int1 using root **
74 connect (con_int1,localhost,root,,);
75
76 --echo ** Connection con_int1 **
77 connection con_int1;
78 SELECT @@SESSION.sql_warnings;
79 --echo 0 / FALSE Expected
80
81 SET SESSION sql_warnings = FALSE;
82
83 --echo ** Connecting con_int2 using root **
84 connect (con_int2,localhost,root,,);
85
86 --echo ** Connection con_int2 **
87 connection con_int2;
88 SELECT @@SESSION.sql_warnings;
89 --echo 0 / FALSE Expected
90
91 SET SESSION sql_warnings = TRUE;
92
93 --echo ** Connection con_int2 **
94 connection con_int2;
95 SELECT @@SESSION.sql_warnings;
96 --echo 1 / TRUE Expected
97
98 --echo ** Connection con_int1 **
99 connection con_int1;
100 SELECT @@SESSION.sql_warnings;
101 --echo 0 / FALSE Expected
102
103 --echo ** Connection default **
104 connection default;
105
106 --echo Disconnecting Connections con_int1, con_int2
107 disconnect con_int1;
108 disconnect con_int2;
109
110
111 #
112 # Cleanup
113 #
114
115 DROP TABLE t1;
116
117 SET @@sql_warnings = @default_sql_warnings;
118
119 --disable_info
120 --enable_warnings