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

NEW and OLD in a trigger as row variables

    XMLWordPrintable

Details

    Description

      If we will treat NEW and OLD not as a purely syntactic keywords but as actual row variables of the row type, then one would be able to do

      SET NEW=OLD;

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40124 Assertion `m_sp == m_thd->spcont->m_sp' failed virtual Item *Item_splocal::this_item(), UBSAN : member call on null pointer of type 'Sp_rcontext_handler' in sql/item.cc

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40127 Server hangs when setting NEW=OLD on a multi-row table

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40130 SIGSEGV in Field_iterator_table::set_table at sql/table.h:3350

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40490 SET NEW = (row subquery) in a trigger silently assigns NULL to all columns and skips the single-row check

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-30896 Converting NEW and OLD rows in triggers to JSON

          • Major - Major loss of function.
          • Open
          has action item

          DOCS-6246 Loading...

          Activity

            People

              ramesh Ramesh Sivaraman
              serg Sergei Golubchik
              Rucha Deodhar Rucha Deodhar
              Dmitry Shulga Dmitry Shulga
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 25d Original Estimate - 25d
                  25d
                  Remaining:
                  Time Spent - 59d 4h 50m Remaining Estimate - 1.25d
                  1.25d
                  Logged:
                  Time Spent - 59d 4h 50m Remaining Estimate - 1.25d
                  59d 4h 50m

                  Git Integration

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