summaryrefslogtreecommitdiff
path: root/mysql-test/r/events_logs_tests.result
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2006-05-23 17:51:17 -0700
committerunknown <jimw@mysql.com>2006-05-23 17:51:17 -0700
commit8bd23f0725d90652c13c967723e0cce67fd97a64 (patch)
treedb47262795c7cfd1dd13f24e66868f46448ae476 /mysql-test/r/events_logs_tests.result
parent3100a6ca6e9c99ed57effbd05fea78920440188a (diff)
downloadmariadb-git-8bd23f0725d90652c13c967723e0cce67fd97a64.tar.gz
Fix events_logs_tests so it won't fail on Windows due to appearance
of hostname in query results. mysql-test/r/events_logs_tests.result: Update results mysql-test/t/events_logs_tests.test: Replace user_host in results, since it is system dependent.
Diffstat (limited to 'mysql-test/r/events_logs_tests.result')
-rw-r--r--mysql-test/r/events_logs_tests.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/events_logs_tests.result b/mysql-test/r/events_logs_tests.result
index 911bc8b2d60..ce58e0ec059 100644
--- a/mysql-test/r/events_logs_tests.result
+++ b/mysql-test/r/events_logs_tests.result
@@ -19,7 +19,7 @@ SET GLOBAL event_scheduler=1;
"Should see 3 rows - the 'SELect' is in the middle. The other two are selects from general_log"
call select_general_log();
user_host argument
-root[root] @ localhost [localhost] SELect 'alabala', sleep(3) from dual
+USER_HOST SELect 'alabala', sleep(3) from dual
DROP PROCEDURE select_general_log;
DROP EVENT log_general;
SET GLOBAL event_scheduler=2;
@@ -43,7 +43,7 @@ SLEEP(2)
0
SELECT user_host, query_time, db, sql_text FROM mysql.slow_log;
user_host query_time db sql_text
-root[root] @ localhost [] SLEEPVAL events_test SELECT SLEEP(2)
+USER_HOST SLEEPVAL events_test SELECT SLEEP(2)
TRUNCATE mysql.slow_log;
CREATE TABLE slow_event_test (slo_val tinyint, val tinyint);
"This won't go to the slow log"
@@ -76,7 +76,7 @@ slo_val val
"Check slow log. Should see 1 row because 4 is over the threshold of 3 for GLOBAL, though under SESSION which is 10"
SELECT user_host, query_time, db, sql_text FROM mysql.slow_log;
user_host query_time db sql_text
-root[root] @ localhost [localhost] SLEEPVAL events_test INSERT INTO slow_event_test SELECT @@long_query_time, SLEEP(2)
+USER_HOST SLEEPVAL events_test INSERT INTO slow_event_test SELECT @@long_query_time, SLEEP(2)
DROP EVENT long_event2;
SET GLOBAL long_query_time =@old_global_long_query_time;
SET SESSION long_query_time =@old_session_long_query_time;