[Django] #30712: MySQL 8 supports defaults for BLOB and TEXT columns

[Django]

#30712: MySQL 8 supports defaults for BLOB and TEXT columns
-------------------------------------+-------------------------------------
Reporter: Adam | Owner: nobody
(Chainz) Johnson |
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
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

--
Ticket URL: <https://code.djangoproject.com/ticket/30712>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#30712: Add MySQL 8 support for defaults on BLOB and TEXT columns.
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: nobody
Johnson |
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: MySQL, default | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* keywords: => MySQL, default
* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:1>

[Django]

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

-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: nobody
Johnson |
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: MySQL, default | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:2>

[Django]

#30712: Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+
-------------------------------------+-------------------------------------

Reporter: Adam (Chainz) | Owner: Nasir
Johnson | Hussain
Type: New feature | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: MySQL, default | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Nasir Hussain):

* status: new => assigned
* owner: nobody => Nasir Hussain

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:3>

[Django]

#30712: Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Nasir
Johnson | Hussain
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: MySQL, default | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Nasir Hussain):

Created a PR [https://github.com/django/django/pull/11679
django/django/pull/11679]

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:4>

[Django]

#30712: Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Nasir
Johnson | Hussain
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: MySQL, default | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Nasir Hussain):

* has_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:5>

[Django]

#30712: Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Nasir
Johnson | Hussain
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: MySQL, default | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* needs_better_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:6>

[Django]

#30712: Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Nasir
Johnson | Hussain
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:

Keywords: MySQL, default | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* needs_better_patch: 1 => 0
* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:7>

[Django]

#30712: Add support for defaults on BLOB and TEXT columns on MySQL 8.0.13+
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Nasir
Johnson | Hussain

Type: New feature | Status: closed

Component: Database layer | Version: master
(models, ORM) |

Severity: Normal | Resolution: fixed

Keywords: MySQL, default | Triage Stage: Ready for
| checkin

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* status: assigned => closed
* resolution: => fixed

Comment:

Fixed in 6b16c91157512587017e9178d066ed1a683e7795.

--
Ticket URL: <https://code.djangoproject.com/ticket/30712#comment:8>