42 lines
1.6 KiB
Plaintext
42 lines
1.6 KiB
Plaintext
--source include/xplugin_preamble.inc
|
|
--source include/xplugin_create_user.inc
|
|
## Test starts here
|
|
--write_file $MYSQL_TMP_DIR/random_variable_test.tmp
|
|
-->sql
|
|
SET @@GLOBAL.generated_random_password_length = 15;
|
|
SELECT @@GLOBAL.generated_random_password_length;
|
|
|
|
-->endsql
|
|
EOF
|
|
--write_file $MYSQL_TMP_DIR/random_ddl_test.tmp
|
|
-->sql
|
|
SET @@SESSION.generated_random_password_length = 30;
|
|
SELECT @@SESSION.generated_random_password_length;
|
|
CREATE USER usr1 IDENTIFIED BY RANDOM PASSWORD;
|
|
CREATE USER usr2 IDENTIFIED BY RANDOM PASSWORD, usr3 IDENTIFIED BY RANDOM PASSWORD;
|
|
ALTER USER usr1 IDENTIFIED BY RANDOM PASSWORD;
|
|
ALTER USER usr2 IDENTIFIED BY RANDOM PASSWORD, usr3 IDENTIFIED BY RANDOM PASSWORD;
|
|
SET PASSWORD FOR usr1 TO RANDOM;
|
|
SET PASSWORD FOR usr2 TO RANDOM;
|
|
SET PASSWORD FOR usr3 TO RANDOM;
|
|
-->endsql
|
|
EOF
|
|
--write_file $MYSQL_TMP_DIR/select_drop_users_test.tmp
|
|
-->sql
|
|
SELECT user FROM mysql.user WHERE user LIKE '%usr%';
|
|
DROP USER usr1, usr2, usr3;
|
|
SET @@GLOBAL.generated_random_password_length = DEFAULT;
|
|
SELECT @@GLOBAL.generated_random_password_length;
|
|
-->endsql
|
|
EOF
|
|
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/random_variable_test.tmp 2>&1
|
|
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/random_ddl_test.tmp >$MYSQL_TMP_DIR/random_ddl_test_out.tmp
|
|
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/select_drop_users_test.tmp 2>&1
|
|
## Cleanup
|
|
## Cleanup
|
|
--remove_file $MYSQL_TMP_DIR/random_variable_test.tmp
|
|
--remove_file $MYSQL_TMP_DIR/random_ddl_test.tmp
|
|
--remove_file $MYSQL_TMP_DIR/random_ddl_test_out.tmp
|
|
--remove_file $MYSQL_TMP_DIR/select_drop_users_test.tmp
|
|
--source include/xplugin_drop_user.inc
|