Description:
Found by running the full tests locally, on the current 6.0 tree.
Same effect in all "*__datadict" tests:
funcs_1.innodb__datadict
funcs_1.memory__datadict
funcs_1.myisam__datadict
funcs_1.ndb__datadict
funcs_1.innodb__datadict [ fail ]
mysqltest: In included file "./suite/funcs_1/datadict/datadict_tables.inc": At line 59: query '$dd_part1 parameters $dd_part2' succeeded - should have failed with errno 1109...
The result from queries just before the failure was:
< snip >
NULL db_datadict v1 SELECT * FROM information_schema.tables NONE NO root@localhost DEFINER latin1 latin1_swedish_ci
SELECT * FROM user_privileges LIMIT 1;
GRANTEE TABLE_CATALOG PRIVILEGE_TYPE IS_GRANTABLE
'root'@'localhost' NULL SELECT YES
SELECT * FROM schema_privileges LIMIT 1;
GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE
''@'%' NULL test SELECT NO
SELECT * FROM table_privileges LIMIT 1;
GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PRIVILEGE_TYPE IS_GRANTABLE
SELECT * FROM column_privileges LIMIT 1;
GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
SELECT * FROM table_constraints LIMIT 1;
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
NULL mysql PRIMARY mysql columns_priv PRIMARY KEY
SELECT * FROM key_column_usage LIMIT 1;
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
NULL mysql PRIMARY NULL mysql columns_priv Host 1 NULL NULL NULL NULL
SELECT * FROM triggers LIMIT 1;
TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
SELECT * FROM parameters LIMIT 1;
More results from queries before failure can be found in /MySQL/M60/work-6.0/mysql-test/var/log/innodb__datadict.log
How to repeat:
Run the "funcs_1" suite.
