1# suite/funcs_1/datadict/tables1.inc 2# 3# Auxiliary script to be sourced by 4# is_tables_mysql.test 5# is_tables_mysql_embedded.test 6# is_tables_is.test 7# 8# Author: 9# 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of 10# testsuite funcs_1 11# Create this script based on older scripts and new code. 12# 13 14--disable_warnings 15DROP DATABASE IF EXISTS test1; 16--enable_warnings 17CREATE DATABASE test1; 18 19--source suite/funcs_1/datadict/tables2.inc 20 21# Create a low privileged user. 22# Note: The database test1 is just a "home" for the low privileged user 23# and not in the focus of testing. 24--error 0,ER_CANNOT_USER 25DROP USER testuser1@localhost; 26CREATE USER testuser1@localhost; 27GRANT SELECT ON test1.* TO testuser1@localhost; 28 29--echo # Establish connection testuser1 (user=testuser1) 30--replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK 31connect (testuser1,localhost,testuser1,,test1); 32--source suite/funcs_1/datadict/tables2.inc 33 34--echo # Switch to connection default and close connection testuser1 35connection default; 36disconnect testuser1; 37DROP USER testuser1@localhost; 38DROP DATABASE test1; 39