PL/SQL parser - Phase 2
(MDEV-10764)
|
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Prepared Statements, Stored routines |
| Affects Version/s: | 10.3 |
| Fix Version/s: | None |
| Type: | Technical task | Priority: | Major |
| Reporter: | Alexander Barkov | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 10 |
| Labels: | Compatibility | ||
| Description |
|
Currently dynamic SQL (prepared statements and EXECUTE IMMEDIATE) can be used within stored procedures, but not in stored functions or triggers. Oracle supports dynamic SQL in stored functions. We'll allow dynamic SQL in stored functions at least for sql_mode=ORACLE. |
| Comments |
| Comment by Federico Razzoli [ 2017-04-04 ] |
|
Please allow it for all sql_mode's. |
| Comment by Markus Peter [ 2019-03-18 ] |
|
It should be allowed for all modes, and it should be allowed in triggers, not only functions (it's actually even more useful in triggers than in normal functions) |
| Comment by Robert Dyas [ 2019-03-18 ] |
|
I agree with Markus "It should be allowed for all modes, and it should be allowed in triggers, not only functions (it's actually even more useful in triggers than in normal functions)" |
[MDEV-12034]