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.
          • Approved

          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.
          • Stalled

          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

          • Major - Major loss of function.
          • In Review

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41760 SIGSEGV in Field_iterator_table::set_table on re-prepare of trigger SET NEW = (subquery) after DDL on referenced table

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41761 SIGSEGV in sp_head::bind_input_param when trigger passes NEW/OLD row as OUT parameter to CALL

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41765 Assertion m_sp == m_thd->spcont->m_sp failed in Item_splocal::this_item / SIGSEGV in Item_splocal::get_rcontext on SIGNAL ... SET MESSAGE_TEXT = NEW in trigger

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41766 Assertion marked_for_read() failed in Field_long::val_int on row comparison of NEW/OLD in AFTER trigger

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41767 Wrong result for row comparison of trigger NEW/OLD: NEW = OLD returns 1 after a column change, OLD = (1,2,3) returns 0

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41812 Columns named old/new of other tables are resolved as the OLD/NEW row inside trigger bodies, giving ER_TRG_NO_SUCH_ROW_IN_TRG and ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41814 Assertion `argp[arg_no]->fixed()' failed in sp_head::execute_function

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41815 SIGSEGV in Item_trigger_row::cleanup on FLUSH TABLES after a trigger runs DECLARE ROW TYPE OF cursor DEFAULT NEW

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41825 SIGSEGV in THD::sp_fix_func_item when a ROW variable's DEFAULT is an EXISTS subquery

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41826 Crash in Table_triggers_list::mark_fields_used on INSERT after trigger re-parse fails with unknown column

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41827 SIGSEGV in Item_trigger_row::cleanup on condition pushdown of row = NEW into derived table in trigger

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41831 SET NEW = (SELECT ...) in a BEFORE INSERT trigger fails with ER_OPERAND_COLUMNS (1241) on a single-column table

          • Major - Major loss of function.
          • In Review

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41982 Assertion failure in Type_handler_composite::Item_val_bool on NEW AND 1 in trigger on single-column table

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41983 SIGSEGV in Item_cache_row::store on CASE NEW WHEN in trigger on single-column table

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-41087 prepare 13.2 preview

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          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:
              12 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 25d Original Estimate - 25d
                  25d
                  Remaining:
                  Time Spent - 61d 1h 50m Remaining Estimate - 1d
                  1d
                  Logged:
                  Time Spent - 61d 1h 50m Remaining Estimate - 1d
                  61d 1h 50m

                  Git Integration

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