Debian Codegraph @

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

raw
1 ############# mysql-test\t\sql_notes_func.test ############################
2 # #
3 # Variable Name: sql_notes #
4 # Scope: SESSION #
5 # Access Type: Dynamic #
6 # Data Type: BOOLEAN #
7 # Default Value: 1 TRUE #
8 # Values: 1 TRUE, 0 FALSE #
9 # #
10 # #
11 # Creation Date: 2008-02-25 #
12 # Author: Sharique Abdullah #
13 # #
14 # Description: Test Cases of Dynamic System Variable "sql_notes" #
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 # Due to suppressed warnings the pc-protocol is disabled
23 --disable_ps_protocol
24
25 --echo ** Setup **
26 --echo
27 #
28 # Setup
29 #
30
31 SET @default_sql_notes = @@sql_notes;
32
33 --echo '#--------------------FN_DYNVARS_162_01-------------------------#'
34 #
35 # Value ON
36 #
37
38 SET SESSION sql_notes = ON;
39
40 --echo creating a temporary table
41 CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
42 --echo conditionally dropping the table twice so that a note generates
43
44 DROP TABLE IF EXISTS t1;
45
46 SELECT @@warning_count;
47 --echo 0 Expected
48
49 #
50 #This line generates A Note warning
51 #
52 DROP TABLE IF EXISTS t1;
53
54 SELECT @@warning_count;
55 --echo 1 Expected
56
57 --echo '#--------------------FN_DYNVARS_162_02-------------------------#'
58 #
59 # Value OFF
60 #
61
62 SET SESSION sql_notes = OFF;
63
64 --echo creating a temporary table
65 CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
66 --echo conditionally dropping the table twice so that a note generates
67
68 DROP TABLE IF EXISTS t1;
69
70 SELECT @@warning_count;
71 --echo 0 Expected
72
73 #
74 #This line generates A Note warning
75 #
76 DROP TABLE IF EXISTS t1;
77
78 SELECT @@warning_count;
79 --echo 0 Expected
80
81 --echo '#------------------FN_DYNVARS_162_03---------------------------#'
82 #
83 # Session data integrity check & GLOBAL Value check
84 #
85
86 connect (con_int1,localhost,root,,);
87
88 connection con_int1;
89 SELECT @@SESSION.sql_notes;
90 --echo 1 / TRUE Expected
91
92 SET SESSION sql_notes = FALSE;
93
94 connect (con_int2,localhost,root,,);
95
96 connection con_int2;
97 SELECT @@SESSION.sql_notes;
98 --echo 1 / TRUE Expected
99
100 SET SESSION sql_notes = TRUE;
101
102 connection con_int2;
103 SELECT @@SESSION.sql_notes;
104 --echo 1 / TRUE Expected
105
106 connection con_int1;
107 SELECT @@SESSION.sql_notes;
108 --echo 0 / FALSE Expected
109
110 connection default;
111 disconnect con_int1;
112 disconnect con_int2;
113
114
115 #
116 # Cleanup
117 #
118
119 SET SESSION sql_notes = @default_sql_notes;
120
121 --disable_warnings
122 DROP TABLE IF EXISTS t1;
123 --enable_warnings
124
125 --enable_ps_protocol