diff options
Diffstat (limited to 'mysql-test/main/mysqlslap.result')
-rw-r--r-- | mysql-test/main/mysqlslap.result | 100 |
1 files changed, 0 insertions, 100 deletions
diff --git a/mysql-test/main/mysqlslap.result b/mysql-test/main/mysqlslap.result index a83d4d38a16..791cb5ac6b3 100644 --- a/mysql-test/main/mysqlslap.result +++ b/mysql-test/main/mysqlslap.result @@ -258,103 +258,3 @@ DROP TABLE t1; # # Bug MDEV-15789 (Upstream: #80329): MYSQLSLAP OPTIONS --AUTO-GENERATE-SQL-GUID-PRIMARY and --AUTO-GENERATE-SQL-SECONDARY-INDEXES DONT WORK # -# -# MDEV-22485: mysqlslap does not use current user as default for connecting to server -# -set @old_general_log=@@global.general_log; -set @old_general_log_file=@@global.general_log_file; -select @old_general_log; -@old_general_log -0 -show global variables -where Variable_name = 'general_log' or Variable_name = 'slow_query_log'; -Variable_name Value -general_log OFF -slow_query_log OFF -truncate table mysql.general_log; -select * from mysql.general_log; -event_time user_host thread_id server_id command_type argument -set global general_log=ON; -current_user.log; -@@current_user.log -current_user.log -SET GLOBAL general_log_file=general_log.log; -show global variables -where Variable_name = 'general_log' or Variable_name = 'slow_query_log'; -Variable_name Value -general_log ON -slow_query_log OFF -flush logs; -create user anel@localhost; -grant all on *.* to anel@localhost; -connect con1,localhost,anel,,; -connection con1; -create table t(t int); -# Run mysqlslap user anel -Benchmark - Average number of seconds to run all queries: X seconds - Minimum number of seconds to run all queries: X seconds - Maximum number of seconds to run all queries: X seconds - Number of clients running queries: 1 - Average number of queries per client: 1 - -flush tables; -select user_host, command_type, argument from mysql.general_log; -user_host command_type argument -root[root] @ localhost [] Query select @@general_log_file -root[root] @ localhost [] Query SET GLOBAL general_log_file=current_user.log -root[root] @ localhost [] Query show global variables -where Variable_name = 'general_log' or Variable_name = 'slow_query_log' -root[root] @ localhost [] Query flush logs -root[root] @ localhost [] Query create user anel@localhost -root[root] @ localhost [] Query grant all on *.* to anel@localhost -[anel] @ localhost [] Connect anel@localhost as anonymous on test -anel[anel] @ localhost [] Query create table t(t int) -[root] @ localhost [] Connect root@localhost as anonymous on -[root] @ localhost [] Connect root@localhost as anonymous on test -root[root] @ localhost [] Query SELECT current_user() -root[root] @ localhost [] Quit -root[root] @ localhost [] Quit -anel[anel] @ localhost [] Query flush tables -anel[anel] @ localhost [] Query select user_host, command_type, argument from mysql.general_log -disconnect con1; -connection default; -# Run mysqlslap user root -Benchmark - Average number of seconds to run all queries: X seconds - Minimum number of seconds to run all queries: X seconds - Maximum number of seconds to run all queries: X seconds - Number of clients running queries: 1 - Average number of queries per client: 1 - -flush tables; -select user_host, command_type, argument from mysql.general_log; -user_host command_type argument -root[root] @ localhost [] Query select @@general_log_file -root[root] @ localhost [] Query SET GLOBAL general_log_file=current_user.log -root[root] @ localhost [] Query show global variables -where Variable_name = 'general_log' or Variable_name = 'slow_query_log' -root[root] @ localhost [] Query flush logs -root[root] @ localhost [] Query create user anel@localhost -root[root] @ localhost [] Query grant all on *.* to anel@localhost -[anel] @ localhost [] Connect anel@localhost as anonymous on test -anel[anel] @ localhost [] Query create table t(t int) -[root] @ localhost [] Connect root@localhost as anonymous on -[root] @ localhost [] Connect root@localhost as anonymous on test -root[root] @ localhost [] Query SELECT current_user() -root[root] @ localhost [] Quit -root[root] @ localhost [] Quit -anel[anel] @ localhost [] Query flush tables -anel[anel] @ localhost [] Query select user_host, command_type, argument from mysql.general_log -anel[anel] @ localhost [] Quit -[root] @ localhost [] Connect root@localhost as anonymous on -[root] @ localhost [] Connect root@localhost as anonymous on test -root[root] @ localhost [] Query SELECT current_user() -root[root] @ localhost [] Quit -root[root] @ localhost [] Quit -root[root] @ localhost [] Query flush tables -root[root] @ localhost [] Query select user_host, command_type, argument from mysql.general_log -drop user anel@localhost; -drop table t; -set global general_log= @old_general_log; -set global general_log_file= @old_general_log_file; |