Debian Codegraph @

mysql-test/suite/funcs_1/datadict/tables1.inc

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