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

Before Insert trigger does not work with NOT NULL columns

Details

    Description

      Basically this bug was present for a long time in MySQL: http://bugs.mysql.com/bug.php?id=6295
      Even if there is before insert trigger defined that replaces NOT NULL value, new value can not be inserted into the table.

      Tested on OpenSuse 13.1, MariaDB 10.1.6.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8605 MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column.

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11698 Old Bug possibly not fixed; BEFORE INSERT Trigger on NOT NULL

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19761 Before Trigger not processed for Not Null Columns if no explicit value and no DEFAULT

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

          Activity

            People

              serg Sergei Golubchik
              viking Marek
              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.