~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/datadict/basics_mixed2.inc

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
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
 
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;
 
55