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

[8 Dec 2004 18:31] Michael Houlberg
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.
[12 Feb 2006 13:05] Valeriy Kravchuk
Thank you for a useful feature request.
[18 Nov 2008 10:45] James Hadley
Has action been taken on this suggestion?  Prepared statements with GRANT would be very useful.