Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32271

stored procedure invocation not checking underlying table structure alterations

    XMLWordPrintable

Details

    Description

      create table t1 (a int, b int);
      create procedure sp() with cte as (select * from t1) select * from cte;
      call sp();
      alter table t1 add column c int;
      call sp();
      

      The second sp() call should probably fail with ER_WITH_COL_WRONG_LIST

      Attachments

        Activity

          People

            Unassigned Unassigned
            Johnston Rex Johnston
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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