[MDEV-25053] ALTER TABLE .. SET DEFAULT produces invalid table structure Created: 2021-03-04 Updated: 2022-08-04 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table |
| Affects Version/s: | 10.2, 10.3 |
| Fix Version/s: | 10.3 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Elena Stepanova | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | not-10.4, not-10.5, not-10.6 | ||
| Description |
|
Set to Minor because only 10.2 and 10.3 are affected.
The ALTER is obviously wrong, as it attempts to set the default value to NULL while the column is not null. But it works, and the resulting table is this:
Reproducible on 10.2-10.3. An attempt to execute this CREATE statement on any version, including the affected ones, expectedly ends with an error:
|