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

Unexpected behavior with triggers.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.5.28
    • N/A
    • Triggers
    • None
    • 10.5.28-MariaDB-0+deb11u1

    Description

      2 queries, the only difference is that the second query (q2.sql) has an empty trigger.
      In version 10.5.26 the behavior is the same (q1.sql and q2.sql), the result is as expected (7 rows affected).
      In version 10.5.28 q2.sql gives an unexpected result (2 rows affected, 10 warnings).

      Attachments

        1. q1.sql
          1 kB
          Roman Salis
        2. q2.sql
          1 kB
          Roman Salis

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36026 Problem with INSERT SELECT on NOT NULL columns while having BEFORE UPDATE trigger

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              Unassigned Unassigned
              Roman Salis Roman Salis
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.