1#### suite/funcs_1/datadict/basics_mixed2.inc
2#
3# Auxiliary script to be sourced by suite/funcs_1/datadict/is_basics_mixed1.inc
4#
5# contains all tables from INFORMATION_SCHEMA
6#
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
11#
12# We expect to get
13# ERROR 42000: Access denied for user 'root'@'localhost'
14#              to database 'information_schema'
15# for every statement.
16#
17# Author:
18# 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of
19#                           testsuite funcs_1
20#                   Create this script based on older scripts and new code.
21#
22
23--error ER_DBACCESS_DENIED_ERROR
24eval $dd_part1 schemata                              $dd_part2;
25--error ER_DBACCESS_DENIED_ERROR
26eval $dd_part1 tables                                $dd_part2;
27--error ER_DBACCESS_DENIED_ERROR
28eval $dd_part1 columns                               $dd_part2;
29--error ER_DBACCESS_DENIED_ERROR
30eval $dd_part1 character_sets                        $dd_part2;
31--error ER_DBACCESS_DENIED_ERROR
32eval $dd_part1 collations                            $dd_part2;
33--error ER_DBACCESS_DENIED_ERROR
34eval $dd_part1 collation_character_set_applicability $dd_part2;
35--error ER_DBACCESS_DENIED_ERROR
36eval $dd_part1 routines                              $dd_part2;
37--error ER_DBACCESS_DENIED_ERROR
38eval $dd_part1 statistics                            $dd_part2;
39--error ER_DBACCESS_DENIED_ERROR
40eval $dd_part1 views                                 $dd_part2;
41--error ER_DBACCESS_DENIED_ERROR
42eval $dd_part1 user_privileges                       $dd_part2;
43--error ER_DBACCESS_DENIED_ERROR
44eval $dd_part1 schema_privileges                     $dd_part2;
45--error ER_DBACCESS_DENIED_ERROR
46eval $dd_part1 table_privileges                      $dd_part2;
47--error ER_DBACCESS_DENIED_ERROR
48eval $dd_part1 column_privileges                     $dd_part2;
49--error ER_DBACCESS_DENIED_ERROR
50eval $dd_part1 table_constraints                     $dd_part2;
51--error ER_DBACCESS_DENIED_ERROR
52eval $dd_part1 key_column_usage                      $dd_part2;
53--error ER_DBACCESS_DENIED_ERROR
54eval $dd_part1 triggers                              $dd_part2;
55
56