Details
-
Task
-
Status: In Testing (View Workflow)
-
Critical
-
Resolution: Unresolved
-
Q2/2026 Server Maintenance, Q2/2026 Server Development
Description
Under terms of this task we'll implement a number of extensions into prepared statements and SYS_REFCURSORS:
New functionality for prepared statement
PREPARE LOCAL
PREPARE LOCAL spvar_with_ps_name FROM 'dynamic sql';
|
Prepare a PS using an SP variable value as the PS name
EXECUTE LOCAL
EXECUTE LOCAL spvar_with_ps_name;
|
Execute a PS using an SP variable value as the PS name
DEALLOCATE PREPARE LOCAL
DEALLOCATE PREPARE LOCAL spvar_with_ps_name;
|
Deallocate a PS using an SP variable value as the PS name
New functionality for SYS_REFCURSORS
OPEN FOR LOCAL
OPEN c0 FOR LOCAL spvar_with_ps_name;
|
Open a SYS_REFCURSOR from an already prepared statement whose name is in an SP variable
OPEN FOR PREPARE
OPEN c0 FOR PREPARE stmt;
|
Open a SYS_REFCURSOR from an already prepared statement
Attachments
Issue Links
- blocks
-
MDEV-39518 Allow prepared statements in stored functions in assignment right hand
-
- In Review
-
- causes
-
MDEV-40060 Assertion `Well_formed_prefix(system_charset_info, name->str, name->length).length() == name->length' failed in void Lex_ident_sys_st::set_valid_utf8(const LEX_CSTRING *)
-
- Closed
-
- relates to
-
-
- Stalled
-
-
-
- Closed
-
-
-
- Closed
-
- has action item
-
DOCS-6223 Loading...