Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10764 PL/SQL parser - Phase 2
  3. MDEV-12034

Dynamic SQL in stored functions

    XMLWordPrintable

Details

    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.

      Attachments

        Issue Links

          is duplicated by

          Task - A task that needs to be done. MDEV-8618 DYNAMIC SQL in stored functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-39518 Allow prepared statements in stored functions in assignment right hand

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              Votes:
              9 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 15d
                  15d
                  Remaining:
                  Remaining Estimate - 15d
                  15d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.