Debian Codegraph @

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

raw
1 ################# mysql-test\t\log_output_func.test ##########################
2 # #
3 # Variable Name: log_output #
4 # Scope: GLOBAL #
5 # Access Type: Dynamic #
6 # Data Type: enumeration #
7 # Default Value: TABLE #
8 # Range: TABLE, FILE, NONE #
9 # #
10 # #
11 # Creation Date: 2008-03-08 #
12 # Author: Rizwan #
13 # Modified: HHunger 2008-08-29
14 # #
15 # Description: Test Cases of Dynamic System Variable log_output #
16 # that checks the behavior of this variable #
17 # #
18 # Reference: #
19 # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html #
20 # #
21 ###############################################################################
22
23 # The access to mysql.general_log delivers different result depending on
24 # ps-protocol. So, it is switched off.
25 --disable_ps_protocol
26
27 SET @start_value= @@global.log_output;
28 SET @start_general_log= @@global.general_log;
29 SET @start_general_log_file= @@global.general_log_file;
30
31 --echo '#--------------------FN_DYNVARS_065_01-------------------------#'
32 ##################################################################
33 # Check if setting log_output is changed in every new connection #
34 ##################################################################
35
36 SET @@global.log_output = 'NONE';
37 # con1 will be default connection from now on
38 --echo 'connect (con1,localhost,root,,,,)'
39 connect (con1,localhost,root,,,,);
40 SET @@global.log_output = 'TABLE,FILE';
41
42 # Test that the effect is global
43 --echo 'connect (con2,localhost,root,,,,)'
44 connect (con2,localhost,root,,,,);
45 SELECT @@global.log_output;
46
47 --echo '#--------------------FN_DYNVARS_065_02-------------------------#'
48 ####################################################
49 # Begin the functionality Testing of log_output #
50 ####################################################
51
52 --echo 'connection con1'
53 connection con1;
54
55 #===============================================================
56 --echo '---Checking general_log when log_output is NONE---'
57 #===============================================================
58
59 SET @@global.log_output = 'NONE';
60 TRUNCATE TABLE mysql.general_log;
61
62 --disable_warnings
63 DROP TABLE IF EXISTS t1;
64 --enable_warnings
65 CREATE TABLE t1(a INT);
66 INSERT INTO t1 VALUE(1);
67 SELECT 'abc';
68 SELECT count(*) FROM mysql.general_log;
69
70 #===============================================================
71 --echo '---Checking general_log when log_output is TABLE---'
72 #===============================================================
73
74 SET @@global.log_output = 'TABLE';
75 TRUNCATE TABLE mysql.general_log;
76
77 --disable_warnings
78 DROP TABLE IF EXISTS t1;
79 --enable_warnings
80 CREATE TABLE t1(a int);
81 INSERT INTO t1 VALUE(1);
82 SELECT 'abc';
83 # At least the last 4 statement should be logged.
84 SELECT count(*)>4 FROM mysql.general_log;
85
86 #===============================================================
87 # Checking general_log when log_output is FILE
88 #===============================================================
89
90 SET @@global.general_log = 'OFF';
91 FLUSH LOGS;
92 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
93 eval SET @@global.general_log_file = '$MYSQLTEST_VARDIR/run/mytest.log';
94 SET @@global.general_log = 'ON';
95 SET @@global.log_output = 'FILE';
96 TRUNCATE TABLE mysql.general_log;
97 --disable_warnings
98 DROP TABLE IF EXISTS t1;
99 --enable_warnings
100 CREATE TABLE t1(a INT);
101 INSERT INTO t1 VALUE(1);
102 SELECT 'abc';
103 SELECT count(*) FROM mysql.general_log;
104
105 DROP TABLE t1;
106
107 file_exists $MYSQLTEST_VARDIR/run/mytest.log ;
108
109 #==============================================================
110 # Clean up
111 #==============================================================
112
113 --echo connection default;
114 connection default;
115 SET @@global.general_log= 'OFF';
116 SET @@global.general_log_file= @start_general_log_file;
117 SET @@global.log_output= @start_value;
118 SET @@global.general_log= @start_general_log;
119 SET @@global.general_log= 'ON';
120 --remove_file $MYSQLTEST_VARDIR/run/mytest.log
121
122 --enable_ps_protocol
123 ####################################################
124 # End of functionality Testing for log_output #
125 ####################################################
126