MDEV-22485: add the test casebb-10.3-anel-MDEV-22485-mysqlslap

Closes PR #1649

1 files changed, 51 insertions, 0 deletions

diff --git a/mysql-test/main/mysqlslap.test b/mysql-test/main/mysqlslap.test
index 81115d59d09..4e99b8f2cd2 100644
--- a/mysql-test/main/mysqlslap.test
+++ b/mysql-test/main/mysqlslap.test
@@ -88,3 +88,54 @@ DROP TABLE t1;
 --exec $MYSQL_SLAP --concurrency=1 --silent --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-guid-primary --create-schema=slap
 
 --exec $MYSQL_SLAP --concurrency=1 --silent --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-secondary-indexes=1 --create-schema=slap
+
+--echo #
+--echo # MDEV-22485: mysqlslap does not use current user as default for connecting to server
+--echo #
+--disable_ps_protocol
+set @old_general_log=@@global.general_log;
+set @old_general_log_file=@@global.general_log_file;
+select @old_general_log;
+
+show global variables
+where Variable_name = 'general_log' or Variable_name = 'slow_query_log';
+truncate table mysql.general_log;
+# empty log at the beginning
+select * from mysql.general_log;
+
+set global general_log=ON;
+--replace_regex /[\/\w:](?!.log).*/current_user.log/
+select @@general_log_file;
+--replace_regex /=.+"/=general_log.log/
+--let $gen_log_file=$MYSQLTEST_VARDIR/tmp/general_log.log
+--replace_regex /".+"/general_log.log/
+--eval SET GLOBAL general_log_file="$gen_log_file"
+show global variables
+where Variable_name = 'general_log' or Variable_name = 'slow_query_log';
+flush logs;
+create user anel@localhost;
+grant all on *.* to anel@localhost;
+connect con1,localhost,anel,,;
+connection con1;
+create table t(t int);
+--echo # Run mysqlslap user anel
+--replace_regex /\d[.]\d+/X/
+--exec $MYSQL_SLAP --create-schema=test --query="SELECT current_user()" --concurrency=1 --iterations=1
+flush tables;
+--replace_regex /".+/current_user.log/ /[::1]//
+select user_host, command_type, argument from mysql.general_log;
+disconnect con1;
+
+connection default;
+--echo # Run mysqlslap user root
+--replace_regex /\d[.]\d+/X/
+--exec $MYSQL_SLAP --create-schema=test --query="SELECT current_user()" --concurrency=1 --iterations=1
+flush tables;
+#--exec $MYSQL_SLAP --concurrency=1 --silent --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-guid-primary --create-schema=slap
+--replace_regex /".+/current_user.log/ /[::1]//
+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;
+--enable_ps_protocol