PL/SQL parser (MDEV-10142)

[MDEV-10585] EXECUTE IMMEDIATE statement Created: 2016-08-17  Updated: 2018-08-31  Resolved: 2016-09-22

Status: Closed
Project: MariaDB Server
Component/s: Parser, Prepared Statements
Affects Version/s: None
Fix Version/s: 10.2.3, 10.3.0

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: Compatibility

Issue Links:
Blocks
is blocked by MDEV-10709 Expressions as parameters to Dynamic SQL Closed
Relates
relates to MDEV-10866 Extend PREPARE and EXECUTE IMMEDIATE ... Closed
relates to MDEV-10801 sql_mode=ORACLE: Dynamic SQL placehol... Closed
relates to MDEV-11781 sql_mode=ORACLE: IN, OUT, IN OUT mode... Open
Sprint: 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

 Description   

Add support for Oracle-style EXECUTE IMMEDIATE statement.

This is used to execute a sql-statement stored in a string or variable, with possible arguments.

Examples:

EXECUTE IMMEDIATE 'SELECT 1'

This is a shorthand for:

prepare stmt from "select 1";
 
execute stmt;
 
deallocate prepare stmt;



 Comments   
Comment by Michael Widenius [ 2016-09-22 ]

Review done. Code looks good, asked to add one comment to one place before pushing

Comment by Elena Stepanova [ 2016-10-23 ]

Why does it have fix version 10.3.0 if it's been already pushed?

Comment by Alexander Barkov [ 2016-10-24 ]

Originally this was planned for 10.3.0, but then we decided to backport it to 10.2. I forgot to update "Fix version" after backporting.

Added 10.2.3 to the "Fix version" list. Thanks for noticing this!

Generated at Thu Feb 08 07:43:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.