Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
In addition to expressions, we'll allow DEFAULT as a dynamic SQL parameter:
EXECUTE IMMEDIATE examples
EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES(?)' USING DEFAULT; |
EXECUTE IMMEDIATE 'UPDATE t1 SET a=?' USING DEFAULT; |
PREPARE..EXECUTE examples
PREPARE stmt FROM 'INSERT INTO t1 VALUES(?)'; |
EXECUTE stmt USING DEFAULT; |
PREPARE stmt FROM 'UPDATE t1 SET a=?'; |
EXECUTE stmt USING DEFAULT; |
This is for symmetry with the STMT_INDICATOR_DEFAULT indicator in the client-server bind protocol.
MDEV-11359 will also use this MDEV to add INGORE as another possible bind parameter, equal to STMT_INDICATOR_INGORE.
Attachments
Issue Links
- blocks
-
MDEV-11359 Implement IGNORE for bulk operation
- Closed
- relates to
-
MDEV-10709 Expressions as parameters to Dynamic SQL
- Closed