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

OLD_VALUE crashes on a view with an expression

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Q3/2026 Server Maintenance

    Description

      CREATE TABLE t ( id INT PRIMARY KEY, a INT );
      		 
      CREATE VIEW v AS SELECT id, a, a*2 AS a2 FROM t;
      		 
      UPDATE v SET a = a+1 WHERE id = 1 RETURNING id, a, OLD_VALUE( a2 );

      Reported by Ben Bidner (Automattic.com Security Team).

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-5092 Implement UPDATE with result set (UPDATE ... RETURNING) for single table

          • Major - Major loss of function.
          • Closed

          Activity

            People

              rucha174 Rucha Deodhar
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 2.6d Original Estimate - 2.6d
                  2.6d
                  Remaining:
                  Time Spent - 4.25d Remaining Estimate - 0.55d
                  0.55d
                  Logged:
                  Time Spent - 4.25d Remaining Estimate - 0.55d
                  4.25d

                  Git Integration

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