MySQL Bugs: #16113: No fully qualified indexname in CREATE INDEX

Bug #16113	No fully qualified indexname in CREATE INDEX
Submitted:	1 Jan 2006 6:00	Modified:	1 Jan 2006 22:05
Reporter:	Ken Resander	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	MySQL 5.0.16	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
These are OK:
  
  CREATE INDEX idx ON sometable (colname);
  CREATE INDEX idx ON somedb.sometable (colname);

but not these

  CREATE INDEX somedb.idx ON sometable (colname);
  CREATE INDEX somedb.idx ON somedb.sometable (colname);

Tables, routines, triggers and views allow qualified names. 
For consistency, indexes should be treated the same way.

Best regards
Ken Resander

How to repeat:
Not applicable

Suggested fix:
Not applicable

indexes are always bound to the table specified in the ON clause so fully quallified index names do not make any sense here, they are already quallified by the ON part ...