summaryrefslogtreecommitdiff
path: root/mysql-test/r/log_tables.result
diff options
context:
space:
mode:
authorunknown <andrey@lmy004.>2006-05-23 15:01:23 +0200
committerunknown <andrey@lmy004.>2006-05-23 15:01:23 +0200
commit749f1832658ca68812431cac5a810a08ce3f47e6 (patch)
tree0181336f75220f1d5013c890f8113ae2686788ce /mysql-test/r/log_tables.result
parent91552f962f2e37831738dd6ba2bf36339559c8af (diff)
downloadmariadb-git-749f1832658ca68812431cac5a810a08ce3f47e6.tar.gz
update log_tables.test so it is less fragile
mysql-test/r/log_tables.result: update result so test is less fragile mysql-test/t/log_tables.test: update test so it is less fragile
Diffstat (limited to 'mysql-test/r/log_tables.result')
-rw-r--r--mysql-test/r/log_tables.result12
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/log_tables.result b/mysql-test/r/log_tables.result
index 2164c18823f..0b43024cb0f 100644
--- a/mysql-test/r/log_tables.result
+++ b/mysql-test/r/log_tables.result
@@ -2,14 +2,14 @@ use mysql;
truncate table general_log;
select * from general_log;
event_time user_host thread_id server_id command_type argument
-TIMESTAMP root[root] @ localhost [] 1 1 Query select * from general_log
+TIMESTAMP root[root] @ localhost [] THREAD_ID 1 Query select * from general_log
truncate table slow_log;
select * from slow_log;
start_time user_host query_time lock_time rows_sent rows_examined db last_insert_id insert_id server_id sql_text
truncate table general_log;
select * from general_log where argument like '%general_log%';
event_time user_host thread_id server_id command_type argument
-TIMESTAMP root[root] @ localhost [] 1 1 Query select * from general_log where argument like '%general_log%'
+TIMESTAMP root[root] @ localhost [] THREAD_ID 1 Query select * from general_log where argument like '%general_log%'
create table join_test (verbose_comment varchar (80), command_type varchar(64));
insert into join_test values ("User performed a usual SQL query", "Query");
insert into join_test values ("New DB connection was registered", "Connect");
@@ -59,10 +59,10 @@ create table bug16905 (s char(15) character set utf8 default 'пусто');
insert into bug16905 values ('новое');
select * from mysql.general_log;
event_time user_host thread_id server_id command_type argument
-TIMESTAMP root[root] @ localhost [] 2 1 Query set names utf8
-TIMESTAMP root[root] @ localhost [] 2 1 Query create table bug16905 (s char(15) character set utf8 default 'пусто')
-TIMESTAMP root[root] @ localhost [] 2 1 Query insert into bug16905 values ('новое')
-TIMESTAMP root[root] @ localhost [] 2 1 Query select * from mysql.general_log
+TIMESTAMP root[root] @ localhost [] THREAD_ID 1 Query set names utf8
+TIMESTAMP root[root] @ localhost [] THREAD_ID 1 Query create table bug16905 (s char(15) character set utf8 default 'пусто')
+TIMESTAMP root[root] @ localhost [] THREAD_ID 1 Query insert into bug16905 values ('новое')
+TIMESTAMP root[root] @ localhost [] THREAD_ID 1 Query select * from mysql.general_log
drop table bug16905;
truncate table mysql.slow_log;
set session long_query_time=1;