Opened 5 weeks ago

Closed 4 weeks ago

#30712 closed New feature (fixed)

Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+

Reported by: Adam (Chainz) Johnson Owned by: Nasir Hussain
Component: Database layer (models, ORM) Version: master
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 Changed 5 weeks ago by felixxm

Keywords: MySQL default added
Summary: MySQL 8 supports defaults for BLOB and TEXT columnsAdd MySQL 8 support for defaults on BLOB and TEXT columns.
Triage Stage: UnreviewedAccepted

comment:2 Changed 5 weeks ago by felixxm

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 Changed 5 weeks ago by Nasir Hussain

Owner: changed from nobody to Nasir Hussain
Status: newassigned

comment:4 Changed 5 weeks ago by Nasir Hussain

comment:5 Changed 5 weeks ago by Nasir Hussain

Has patch: set

comment:6 Changed 5 weeks ago by felixxm

Patch needs improvement: set

comment:7 Changed 4 weeks ago by felixxm

Patch needs improvement: unset
Triage Stage: AcceptedReady for checkin

comment:8 Changed 4 weeks ago by felixxm

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.
Back to Top