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)
-
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
-
-
- Closed
-
- duplicates
-
-
- Closed
-
- relates to
-
MDEV-4958 Adding datatype UUID
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- links to
Activity
| Field | Original Value | New Value |
|---|---|---|
| Labels | need_feedback |
| Labels | need_feedback |
| Labels | need_feedback |
| Labels | need_feedback |
| Remote Link | This issue links to "Bug #6295 - Triggers are not processed for NOT NULL columns (Web Link)" [ 24502 ] |
| Component/s | Triggers [ 10109 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 5.3.12 [ 12000 ] | |
| Affects Version/s | 5.2.14 [ 12101 ] | |
| Affects Version/s | 5.1.67 [ 12100 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 10.0.21 [ 19406 ] | |
| Assignee | Sergei Golubchik [ serg ] | |
| Labels | upstream-fixed |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Sprint | 10.0.22 [ 17 ] |
| Rank | Ranked higher |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Fix Version/s | 10.0 [ 16000 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Sprint | 10.0.22 [ 17 ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.1 [ 16100 ] |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] |
| Sprint | 10.1.9-3 [ 20 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Remote Link | This issue links to "WL#6030: The BEFORE triggers are not processed for NOT NULL columns (Web Link)" [ 25716 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Rank | Ranked higher |
| Sprint | 10.1.9-3 [ 20 ] | 10.1.9-3, 10.1.10 [ 20, 24 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Sergei Golubchik [ serg ] | Elena Stepanova [ elenst ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Fix Version/s | 10.1.10 [ 20402 ] | |
| Fix Version/s | 10.1 [ 16100 ] |
| Assignee | Elena Stepanova [ elenst ] | Sergei Golubchik [ serg ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Review [ 10002 ] | Closed [ 6 ] |
| Link |
This issue duplicates |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 71017 ] | MariaDB v4 [ 149465 ] |