[Django] #29209: Cast with TextField crashes on MySQL

[Django]

#29209: Cast with TextField crashes on MySQL
-------------------------------------+-------------------------------------
Reporter: Sergey | Owner: nobody
Fedoseev |
Type: Bug | Status: new
Component: Database | Version: 2.0
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 |
-------------------------------------+-------------------------------------
{{{
City.objects.values_list(Cast('id', models.TextField())).first()
}}}

{{{
ProgrammingError: (1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax
to use near 'longtext) AS `cast1` FROM `test_app_city` ORDER BY
`test_app_city`.`id` ASC LIM' at line 1"
}}}

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

[Django]

#29209: Cast with TextField crashes on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0

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

Changes (by Sergey Fedoseev):

* owner: nobody => Sergey Fedoseev
* status: new => assigned

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

[Django]

#29209: Cast with TextField crashes on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed

Has patch: 1 | Needs documentation: 0

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

Changes (by Sergey Fedoseev):

* has_patch: 0 => 1

Comment:

[https://github.com/django/django/pull/9772 PR]

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

[Django]

#29209: Cast with TextField crashes on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:

Keywords: | 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 Claude Paroz):

* stage: Unreviewed => Ready for checkin

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

[Django]

#29209: Cast with TextField crashes on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:

Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

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

Changes (by Tim Graham):

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

Comment:

The new test fails on Oracle.

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

[Django]

#29209: Cast with TextField crashes on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

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

Changes (by Sergey Fedoseev):

* needs_better_patch: 1 => 0

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

[Django]

#29209: Cast with TextField crashes on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev

Type: Bug | Status: closed

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

Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

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

Changes (by Tim Graham <timograham@…>):

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

Comment:

In [changeset:"d696fccae6ea0868855aa28f8d2bc2f7f77ac208" d696fcca]:
{{{
#!CommitTicketReference repository=""
revision="d696fccae6ea0868855aa28f8d2bc2f7f77ac208"
Fixed #29209 -- Fixed Cast() with TextField on MySQL and Oracle.
}}}

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