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