Opened 6 years ago
Closed 6 years ago
#30712 closed New feature (fixed)
Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+
| Reported by: | Adam Johnson | Owned by: | Nasir Hussain |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | dev |
| Severity: | Normal | Keywords: | MySQL, default |
| Cc: | Triage Stage: | Ready for checkin | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Whilst implementing #27676 for MariaDB, I learned that MySQL 8.0.13+ allows defaults for BLOB and TEXT columns as well.
It has a caveat though - static defaults must always be wrapped in parentheses for such columns.
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Change History (8)
comment:1 by , 6 years ago
| Keywords: | MySQL default added |
|---|---|
| Summary: | MySQL 8 supports defaults for BLOB and TEXT columns → Add MySQL 8 support for defaults on BLOB and TEXT columns. |
| Triage Stage: | Unreviewed → Accepted |
comment:2 by , 6 years ago
| Summary: | Add MySQL 8 support for defaults on BLOB and TEXT columns. → Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+ |
|---|
comment:3 by , 6 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:4 by , 6 years ago
comment:5 by , 6 years ago
| Has patch: | set |
|---|
comment:6 by , 6 years ago
| Patch needs improvement: | set |
|---|
comment:7 by , 6 years ago
| Patch needs improvement: | unset |
|---|---|
| Triage Stage: | Accepted → Ready for checkin |
comment:8 by , 6 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Fixed in 6b16c91157512587017e9178d066ed1a683e7795.
Note:
See TracTickets
for help on using tickets.
Created a PR django/django/pull/11679