Re: [Django] #33905: Validation of check constraints against ranges involving PostgreSQL's lower()/upper() functions produces invalid SQL.

Django

unread,

Aug 9, 2022, 2:15:30 PM8/9/22

to django-...@googlegroups.com

#33905: Validation of check constraints against ranges involving PostgreSQL's
lower()/upper() functions produces invalid SQL.
-------------------------------------+-------------------------------------
Reporter: David Sanders | Owner: David
| Sanders
Type: Bug | Status: assigned
Component: contrib.postgres | Version: 4.1
Severity: Release blocker | 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 Mariusz Felisiak):

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

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

Django

unread,

Aug 9, 2022, 3:45:59 PM8/9/22

to django-...@googlegroups.com

#33905: Validation of check constraints against ranges involving PostgreSQL's
lower()/upper() functions produces invalid SQL.
-------------------------------------+-------------------------------------
Reporter: David Sanders | Owner: David
| Sanders

Type: Bug | Status: closed
Component: contrib.postgres | Version: 4.1
Severity: Release blocker | Resolution: fixed

Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

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

Comment:

In [changeset:"e0ae1363ec2aa71945be26f869cafd4181ccbc95" e0ae1363]:
{{{
#!CommitTicketReference repository=""
revision="e0ae1363ec2aa71945be26f869cafd4181ccbc95"
Fixed #33905 -- Fixed CheckConstraint() validation on range fields.

Bug in 667105877e6723c6985399803a364848891513cc.
}}}

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

Django

unread,

Aug 9, 2022, 3:45:59 PM8/9/22

to django-...@googlegroups.com

#33905: Validation of check constraints against ranges involving PostgreSQL's
lower()/upper() functions produces invalid SQL.
-------------------------------------+-------------------------------------
Reporter: David Sanders | Owner: David
| Sanders

Type: Bug | Status: assigned

Component: contrib.postgres | Version: 4.1
Severity: Release blocker | Resolution:

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"e0ac72fe80a806421dcbbbac22e483b27d2ede7b" e0ac72fe]:
{{{
#!CommitTicketReference repository=""
revision="e0ac72fe80a806421dcbbbac22e483b27d2ede7b"
Refs #33905 -- Added test for CheckConstraint() validation with ArrayField
and __contains.
}}}

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

Django

unread,

Aug 9, 2022, 3:46:33 PM8/9/22

to django-...@googlegroups.com

#33905: Validation of check constraints against ranges involving PostgreSQL's
lower()/upper() functions produces invalid SQL.
-------------------------------------+-------------------------------------
Reporter: David Sanders | Owner: David
| Sanders

Type: Bug | Status: closed
Component: contrib.postgres | Version: 4.1
Severity: Release blocker | Resolution: fixed

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"e215948f0d75f69b11b8daff7628fb1212c00c27" e215948f]:
{{{
#!CommitTicketReference repository=""
revision="e215948f0d75f69b11b8daff7628fb1212c00c27"
[4.1.x] Fixed #33905 -- Fixed CheckConstraint() validation on range
fields.

Bug in 667105877e6723c6985399803a364848891513cc.

Backport of e0ae1363ec2aa71945be26f869cafd4181ccbc95 from main
}}}

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

Reply all

Reply to author

Forward