summaryrefslogtreecommitdiff
path: root/mysql-test/r/log_state.result
diff options
context:
space:
mode:
authorunknown <gluh@eagle.intranet.mysql.r18.ru>2006-06-22 19:20:29 +0500
committerunknown <gluh@eagle.intranet.mysql.r18.ru>2006-06-22 19:20:29 +0500
commitdcd384ba83bc120337d11c9baae6deb5f391e076 (patch)
tree05e4ebeb1746fe7c9296c5375f78db5ddffd9525 /mysql-test/r/log_state.result
parent54b38dd6b514a4a683dfd5376be3cb70b45b9a20 (diff)
downloadmariadb-git-dcd384ba83bc120337d11c9baae6deb5f391e076.tar.gz
test fix(to satisfy Win)
mysql-test/r/log_state.result: result fix(to satisfy Win)
Diffstat (limited to 'mysql-test/r/log_state.result')
-rw-r--r--mysql-test/r/log_state.result22
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/r/log_state.result b/mysql-test/r/log_state.result
index df81f05fea5..43735243787 100644
--- a/mysql-test/r/log_state.result
+++ b/mysql-test/r/log_state.result
@@ -14,15 +14,15 @@ set global general_log= ON;
create table t1(f1 int);
select * from mysql.general_log;
event_time user_host thread_id server_id command_type argument
-TIMESTAMP root[root] @ localhost [] # 1 Query create table t1(f1 int)
-TIMESTAMP root[root] @ localhost [] # 1 Query select * from mysql.general_log
+TIMESTAMP USER_HOST # 1 Query create table t1(f1 int)
+TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log
set global general_log= OFF;
drop table t1;
select * from mysql.general_log;
event_time user_host thread_id server_id command_type argument
-TIMESTAMP root[root] @ localhost [] # 1 Query create table t1(f1 int)
-TIMESTAMP root[root] @ localhost [] # 1 Query select * from mysql.general_log
-TIMESTAMP root[root] @ localhost [] # 1 Query set global general_log= OFF
+TIMESTAMP USER_HOST # 1 Query create table t1(f1 int)
+TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log
+TIMESTAMP USER_HOST # 1 Query set global general_log= OFF
set global general_log= ON;
flush logs;
show global variables
@@ -46,7 +46,7 @@ sleep(2)
0
select * from mysql.slow_log;
start_time user_host query_time lock_time rows_sent rows_examined db last_insert_id insert_id server_id sql_text
-TIMESTAMP, root[root] @ localhost [] USER_HOST, QUERY_TIME 1 0 test 0 0 1 select sleep(2)
+TIMESTAMP USER_HOST QUERY_TIME 00:00:00 1 0 test 0 0 1 select sleep(2)
show global variables
where Variable_name = 'log' or Variable_name = 'log_slow_queries' or
Variable_name = 'general_log' or Variable_name = 'slow_query_log';
@@ -67,9 +67,9 @@ create table t1(f1 int);
drop table t1;
select * from mysql.general_log;
event_time user_host thread_id server_id command_type argument
-TIMESTAMP root[root] @ localhost [] # 1 Query create table t1(f1 int)
-TIMESTAMP root[root] @ localhost [] # 1 Query drop table t1
-TIMESTAMP root[root] @ localhost [] # 1 Query select * from mysql.general_log
+TIMESTAMP USER_HOST # 1 Query create table t1(f1 int)
+TIMESTAMP USER_HOST # 1 Query drop table t1
+TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log
set global general_log= OFF;
truncate table mysql.general_log;
select * from mysql.general_log;
@@ -151,5 +151,5 @@ set global general_log=ON;
drop table t1;
select * from mysql.general_log;
event_time user_host thread_id server_id command_type argument
-TIMESTAMP root[root] @ localhost [] # 1 Query drop table t1
-TIMESTAMP root[root] @ localhost [] # 1 Query select * from mysql.general_log
+TIMESTAMP USER_HOST # 1 Query drop table t1
+TIMESTAMP USER_HOST # 1 Query select * from mysql.general_log