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

MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.1.67, 5.2.14, 5.3.12, 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 10.1.10
    • Triggers
    • Linux
    • 10.1.9-3, 10.1.10

    Description

      MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column.

      Expected similar behavior as for AUTOINCREMENT and would be usefull for generation right value in trigger.
      http://stackoverflow.com/questions/15473654/mariadb-before-insert-trigger-for-uuid

      Of course in described example much better if MariaDB would support UUID data type and generate automaticaly UUID for AUTOINCREMENT fields.

      But I think it would be good idea if MariaDB would allow use any function for default value it would be good replacement of generators.

      For example:

      CREATE TABLE `c` (
      		 
        `id` VARBINARY(36) NOT NULL DEFAULT UUID(),
      		 
        PRIMARY KEY (`id`)
      		 
      ) ENGINE=INNODB DEFAULT CHARSET=utf8

      And it would here appropriate analogy with the behavior of AUTOINCREMENT

      And if make possible to work with property table autoincrement into functions would be generally be a bomb. It would be possible create complicated ID with concatenation static identifier if schema and autoincrement.

      For example:
      A-1
      A-2
      A-3
      A-5

      and on another schema for same table
      B-1
      B-2
      B-3
      B-4

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9500 Bug after upgrade to 10.1.10 (and 10.1.11)

          • Major - Major loss of function.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10002 Before Insert trigger does not work with NOT NULL columns

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

          Task - A task that needs to be done. MDEV-4958 Adding datatype UUID

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9428 NO_AUTO_VALUE_ON_ZERO is ignored when a trigger before insert is defined

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9535 Trigger doing "SET NEW.auctionStart = NOW();" on a timestamp kills MariaDB server.

          • 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
          links to

          Web Link Bug #6295 - Triggers are not processed for NOT NULL columns

          Web Link WL#6030: The BEFORE triggers are not processed for NOT NULL columns

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            		8d 1h 24m 1
            Sergei Golubchik made transition -
            Confirmed In Progress
            		63d 58m 1
            Sergei Golubchik made transition -
            In Progress Stalled
            		5d 19h 14m 2
            Sergei Golubchik made transition -
            Stalled In Progress
            		49d 3m 2
            Sergei Golubchik made transition -
            In Progress In Review
            		6h 26m 1
            Sergei Golubchik made transition -
            In Review Closed
            		5d 21h 50m 1

            People

              serg Sergei Golubchik
              mikhail Mikhail Gavrilov
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.