summaryrefslogtreecommitdiff
path: root/mysql-test/t/log_tables.test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2006-05-23 09:49:04 -0700
committerunknown <jimw@mysql.com>2006-05-23 09:49:04 -0700
commit041171fd818b52ea0e1fbc8d396ba91b740a35fa (patch)
tree43491d8187e35431cd257348e83950226455d451 /mysql-test/t/log_tables.test
parent2b8527e94507acd10ff48fee4fe1b8814d246dea (diff)
parentc8fd8a82589d159a63978faab814fbe78ea556d6 (diff)
downloadmariadb-git-041171fd818b52ea0e1fbc8d396ba91b740a35fa.tar.gz
Merge bk-internal:/home/bk/mysql-5.1-new
into mysql.com:/home/jimw/my/mysql-5.1-clean mysql-test/r/log_tables.result: Merge conflict mysql-test/t/log_tables.test: Merge conflict
Diffstat (limited to 'mysql-test/t/log_tables.test')
-rw-r--r--mysql-test/t/log_tables.test11
1 files changed, 6 insertions, 5 deletions
diff --git a/mysql-test/t/log_tables.test b/mysql-test/t/log_tables.test
index ef172f6b138..5b79e5e4625 100644
--- a/mysql-test/t/log_tables.test
+++ b/mysql-test/t/log_tables.test
@@ -16,10 +16,10 @@ use mysql;
#
truncate table general_log;
---replace_column 1 TIMESTAMP 3 THREAD_ID
+--replace_column 1 TIMESTAMP 2 USER_HOST 3 THREAD_ID
select * from general_log;
truncate table slow_log;
---replace_column 1 TIMESTAMP
+--replace_column 1 TIMESTAMP 2 USER_HOST
select * from slow_log;
#
@@ -31,7 +31,7 @@ select * from slow_log;
#
truncate table general_log;
---replace_column 1 TIMESTAMP 3 THREAD_ID
+--replace_column 1 TIMESTAMP 2 USER_HOST 3 THREAD_ID
select * from general_log where argument like '%general_log%';
@@ -47,6 +47,7 @@ insert into join_test values ("User performed a usual SQL query", "Query");
insert into join_test values ("New DB connection was registered", "Connect");
insert into join_test values ("Get the table info", "Field List");
+--replace_column 2 USER_HOST
select verbose_comment, user_host, argument
from mysql.general_log join join_test
on (mysql.general_log.command_type = join_test.command_type);
@@ -156,7 +157,7 @@ truncate table mysql.general_log;
set names utf8;
create table bug16905 (s char(15) character set utf8 default 'пусто');
insert into bug16905 values ('новое');
---replace_column 1 TIMESTAMP 3 THREAD_ID
+--replace_column 1 TIMESTAMP 2 USER_HOST 3 THREAD_ID
select * from mysql.general_log;
drop table bug16905;
@@ -167,7 +168,7 @@ drop table bug16905;
truncate table mysql.slow_log;
set session long_query_time=1;
select sleep(2);
---replace_column 1 TIMESTAMP, 3 USER_HOST, 4 QUERY_TIME
+--replace_column 1 TIMESTAMP 2 USER_HOST 3 QUERY_TIME
select * from mysql.slow_log;
# kill all connections