diff options
author | unknown <andrey@lmy004.> | 2006-05-23 15:01:23 +0200 |
---|---|---|
committer | unknown <andrey@lmy004.> | 2006-05-23 15:01:23 +0200 |
commit | 749f1832658ca68812431cac5a810a08ce3f47e6 (patch) | |
tree | 0181336f75220f1d5013c890f8113ae2686788ce /mysql-test/r/log_tables.result | |
parent | 91552f962f2e37831738dd6ba2bf36339559c8af (diff) | |
download | mariadb-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.result | 12 |
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; |