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

Early not null column error despite before trigger

    XMLWordPrintable

Details

    Description

      Noticed before ttrigger behavior different from Oracle. In Oracle I can fill not null column value during before trigger by setting :new record field. In MariaDB (11.1.2-MariaDB, Win64) I get "Field ... doesn't have a default value" error. To bring back desired behavior I have to modify column to NULL, then I can go into before trigger and the column gets filled.
      Wouldn't it be proper to check nulls after "before trigger" has been executed, like Oracle does?

      Attachments

        Activity

          People

            Unassigned Unassigned
            balta Tadas Balaišis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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