Bug #38732 Global Prepared Statement
Submitted: 11 Aug 2008 22:12 Modified: 19 Aug 2008 16:09
Reporter: Lee Wood Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S4 (Feature request)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any

[11 Aug 2008 22:12] Lee Wood 
Description:
As a DBA, I'd like to be able to write an optimized query, and then allow our company's developers to access it via a Global Prepared Statement.

How to repeat:
This is a feature request.
[19 Aug 2008 13:23] Susanne Ebrecht 
Which kind of prepared statement do you mean here?

SQL Standard only includes a prepared statement for use in embedded SQL.

I think you want a PREPARE [GLOBAL|LOCAL] stmt_name FROM preparable_stmt

All RDBMS that I know just have these session depending. I think there is a good reason why they all didn't implement it for global use.

I will give this feature request to development for discussion.

Also I will set version to 6.0 because that is the version where new features will be placed.
[19 Aug 2008 16:09] Lee Wood 
Yes,

   PREPARE [GLOBAL|LOCAL] stmt_name FROM preparable_stmt ;

is what I had in mind.