MySQL Bugs: #7113: Include GRANT, USE and CREATE INDEX in Prepared Statement api.

Bug #7113	Include GRANT, USE and CREATE INDEX in Prepared Statement api.
Submitted:	8 Dec 2004 18:31	Modified:	12 Feb 2006 13:05
Reporter:	Michael Houlberg	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Prepared statements	Severity:	S4 (Feature request)
Version:	4.1.7 Pro	OS:	Any (All)
Assigned to:		CPU Architecture:	Any

Description:
The MySQL Docs at this location

http://dev.mysql.com/doc/mysql/en/C_API_Prepared_statements.html

state that the Prepared Statement api only includes certain SQL commands.  It seems especially 
strange that you can issue a CREATE TABLE but not a CREATE INDEX.  I'm developing 
applications using Omnis Studio from Raining Data which has a direct connection to MySQL Pro.  
It seems all their connections use prepared statements.  Our customers choose either SQL 
Server, Oracle, or now we are trying to implement MySQL as their backend databases.  We only 
ask that they Create the Database and our application creates users, tables and indexes when it 
starts up the first time.  It also maintains those tables as versions change.

How to repeat:
Not a bug, enhancement request

Suggested fix:
Please offer support for GRANT, USE, CREATE INDEX, DROP INDEX and ALTER TABLE in the 
prepared statement api.  Without these we cannot offer MySQL as a supported backend to our 
customers.

Thank you for a useful feature request.

Has action been taken on this suggestion?  Prepared statements with GRANT would be very useful.