1 #### suite/funcs_1/datadict/basics_mixed2.inc
3 # Auxiliary script to be sourced by suite/funcs_1/datadict/is_basics_mixed1.inc
5 # contains all tables from INFORMATION_SCHEMA
7 # Usage example(snip of script):
8 # let $dd_part1= CREATE TABLE information_schema.;
9 # let $dd_part2= ( c1 INT );
10 # --source suite/funcs_1/datadict/basics_mixed2.inc
13 # ERROR 42000: Access denied for user 'root'@'localhost'
14 # to database 'information_schema'
15 # for every statement.
18 # 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of
20 # Create this script based on older scripts and new code.
23 --error ER_DBACCESS_DENIED_ERROR
24 eval $dd_part1 schemata $dd_part2;
25 --error ER_DBACCESS_DENIED_ERROR
26 eval $dd_part1 tables $dd_part2;
27 --error ER_DBACCESS_DENIED_ERROR
28 eval $dd_part1 columns $dd_part2;
29 --error ER_DBACCESS_DENIED_ERROR
30 eval $dd_part1 character_sets $dd_part2;
31 --error ER_DBACCESS_DENIED_ERROR
32 eval $dd_part1 collations $dd_part2;
33 --error ER_DBACCESS_DENIED_ERROR
34 eval $dd_part1 collation_character_set_applicability $dd_part2;
35 --error ER_DBACCESS_DENIED_ERROR
36 eval $dd_part1 routines $dd_part2;
37 --error ER_DBACCESS_DENIED_ERROR
38 eval $dd_part1 statistics $dd_part2;
39 --error ER_DBACCESS_DENIED_ERROR
40 eval $dd_part1 views $dd_part2;
41 --error ER_DBACCESS_DENIED_ERROR
42 eval $dd_part1 user_privileges $dd_part2;
43 --error ER_DBACCESS_DENIED_ERROR
44 eval $dd_part1 schema_privileges $dd_part2;
45 --error ER_DBACCESS_DENIED_ERROR
46 eval $dd_part1 table_privileges $dd_part2;
47 --error ER_DBACCESS_DENIED_ERROR
48 eval $dd_part1 column_privileges $dd_part2;
49 --error ER_DBACCESS_DENIED_ERROR
50 eval $dd_part1 table_constraints $dd_part2;
51 --error ER_DBACCESS_DENIED_ERROR
52 eval $dd_part1 key_column_usage $dd_part2;
53 --error ER_DBACCESS_DENIED_ERROR
54 eval $dd_part1 triggers $dd_part2;