« back to all changes in this revision
Viewing changes to plugin/query_log/tests/r/file.result
- browse files at revision 2422
- compare with another revision
- compare with revision 1147
- download diff
- download tarball
- view history from revision 2422
- Committer: Mark Atwood
- Date: 2011-09-20 06:47:25 UTC
- mfrom: (2420.1.1 query-log-1.0)
- Revision ID: me@mark.atwood.name-20110920064725-wfa8n7up69l4ulod
merge lp:~daniel-nichter/drizzle/query-log-ts
- files modified:
- plugin/query_log/docs/index.rst
added
removed
plugin/query_log/tests/r/file.result
21
21
SELECT @@query_log_enabled, @@query_log_file_enabled;
22
22
@@query_log_enabled @@query_log_file_enabled
23
23
1 1
24
# 0000-00-00T00:00:00.000000
24
# start_ts=0-00-00T00:00:00.000000
25
25
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
26
26
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
27
27
# error=false
28
28
# schema="test"
29
29
SET GLOBAL query_log_file_enabled=TRUE;
30
30
#
31
# 0000-00-00T00:00:00.000000
31
# start_ts=0-00-00T00:00:00.000000
32
32
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
33
33
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
34
34
# error=false
42
42
SELECT 2;
43
43
2
44
44
2
45
# 0000-00-00T00:00:00.000000
45
# start_ts=0-00-00T00:00:00.000000
46
46
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
47
47
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
48
48
# error=false
49
49
# schema="test"
50
50
SET GLOBAL query_log_file_enabled=TRUE;
51
51
#
52
# 0000-00-00T00:00:00.000000
52
# start_ts=0-00-00T00:00:00.000000
53
53
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
54
54
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
55
55
# error=false
71
71
this is the second log file
72
72
this is the second log file
73
73
Log file exists
74
# 0000-00-00T00:00:00.000000
74
# start_ts=0-00-00T00:00:00.000000
75
75
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
76
76
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
77
77
# error=false
78
78
# schema="test"
79
79
SET GLOBAL query_log_file_enabled=TRUE;
80
80
#
81
# 0000-00-00T00:00:00.000000
81
# start_ts=0-00-00T00:00:00.000000
82
82
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
83
83
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
84
84
# error=false
93
93
SELECT 'this is the third log file';
94
94
this is the third log file
95
95
this is the third log file
96
# 0000-00-00T00:00:00.000000
96
# start_ts=0-00-00T00:00:00.000000
97
97
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
98
98
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
99
99
# error=false
100
100
# schema="third-log-file"
101
101
SET GLOBAL query_log_file="third-log-file";
102
102
#
103
# 0000-00-00T00:00:00.000000
103
# start_ts=0-00-00T00:00:00.000000
104
104
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
105
105
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
106
106
# error=false
107
107
# schema="third-log-file"
108
108
SELECT @@query_log_enabled, @@query_log_file_enabled, @@query_log_file;
109
109
#
110
# 0000-00-00T00:00:00.000000
110
# start_ts=0-00-00T00:00:00.000000
111
111
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
112
112
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
113
113
# error=false
114
114
# schema="third-log-file"
115
115
SELECT 'this is the third log file';
116
116
#
117
# 0000-00-00T00:00:00.000000
117
# start_ts=0-00-00T00:00:00.000000
118
118
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
119
119
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
120
120
# error=false
121
121
# schema="test"
122
122
SET GLOBAL query_log_file_enabled=TRUE;
123
123
#
124
# 0000-00-00T00:00:00.000000
124
# start_ts=0-00-00T00:00:00.000000
125
125
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
126
126
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
127
127
# error=false
128
128
# schema="test"
129
129
SELECT @@query_log_enabled, @@query_log_file_enabled;
130
130
#
131
# 0000-00-00T00:00:00.000000
131
# start_ts=0-00-00T00:00:00.000000
132
132
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
133
133
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
134
134
# error=false
135
135
# schema="test"
136
136
SET GLOBAL query_log_file_enabled=TRUE;
137
137
#
138
# 0000-00-00T00:00:00.000000
138
# start_ts=0-00-00T00:00:00.000000
139
139
# session_id=0 query_id=0 rows_examined=0 rows_sent=0 tmp_tables=0 warnings=0
140
140
# execution_time=0.000000 lock_time=0.000000 session_time=0.000000
141
141
# error=false
144
144
#
145
145
SET GLOBAL query_log_file="DRIZZLETEST_VARDIR/query.log";
146
146
Checking attributes and values of query SELECT DATE(NOW());
147
ts value matches OK
147
start_ts value matches OK
148
148
Checking attributes and values of query SELECT DATE(NOW());
149
149
execution_time value matches OK
150
150
lock_time value matches OK
Loggerhead is a web-based interface for Breezy
Version: 2.0.1