--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