Re: [Django] #34059: Validation of check constraints on JSONField key transforms with None produces invalid SQL on PostgreSQL.

2024-03-18 Thread Django
#34059: Validation of check constraints on JSONField key transforms with None
produces invalid SQL on PostgreSQL.
-+-
 Reporter:  Dan LaManna  |Owner:  David
 |  Sanders
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  4.1
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  0
-+-
Comment (by GitHub ):

 In [changeset:"9c17010358891c73417ec569df4f568c0671c099" 9c17010]:
 {{{#!CommitTicketReference repository=""
 revision="9c17010358891c73417ec569df4f568c0671c099"
 Refs #34059, Refs #34060 -- Removed outdated warning about validation of
 JSONField constraints.

 Known issues have been fixed in:
 - 0d8fbe2ade29f1b7bd9e6ba7a0281f5478603a43,
 - c991602ce5798385261381025c06698d7fd30dc5, and
 - 26aae5614487f58ddb1df5726224393887373ecd.
 }}}
-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107018e521e6158-b55f4255-abfa-44d7-b5bd-9bdd7c792959-00%40eu-central-1.amazonses.com.


Re: [Django] #34059: Validation of check constraints on JSONField key transforms with None produces invalid SQL on PostgreSQL.

2024-03-18 Thread Django
#34059: Validation of check constraints on JSONField key transforms with None
produces invalid SQL on PostgreSQL.
-+-
 Reporter:  Dan LaManna  |Owner:  David
 |  Sanders
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  4.1
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 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 Mariusz Felisiak):

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

Comment:

 Fixed in 09ffc5c1212d4ced58b708cbbf3dfbfb77b782ca.
-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107018e51a16b8c-d7762054-9ea5-4c18-9f91-524058a6f527-00%40eu-central-1.amazonses.com.


Re: [Django] #34059: Validation of check constraints on JSONField key transforms with None produces invalid SQL on PostgreSQL.

2022-10-12 Thread Django
#34059: Validation of check constraints on JSONField key transforms with None
produces invalid SQL on PostgreSQL.
-+-
 Reporter:  Dan LaManna  |Owner:  David
 |  Sanders
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  4.1
  (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
-+-

Comment (by GitHub ):

 In [changeset:"004f985b918d5ea36fbed9b050459dd22edaf396" 004f985b]:
 {{{
 #!CommitTicketReference repository=""
 revision="004f985b918d5ea36fbed9b050459dd22edaf396"
 Refs #34059 -- Doc'd lack of support for validation of constraints with
 JSONFields.

 Thanks Dan LaManna for the report.
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/01070183cb9ab3ce-53f07cda-02ca-4bb1-ae48-e77f99f8c06c-00%40eu-central-1.amazonses.com.


Re: [Django] #34059: Validation of check constraints on JSONField key transforms with None produces invalid SQL on PostgreSQL.

2022-10-11 Thread Django
#34059: Validation of check constraints on JSONField key transforms with None
produces invalid SQL on PostgreSQL.
-+-
 Reporter:  Dan LaManna  |Owner:  David
 |  Sanders
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  4.1
  (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 Mariusz Felisiak):

 * type:  Bug => New feature
 * severity:  Release blocker => Normal


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/01070183c68eed45-e3660ed4-7bd3-455e-9622-94c68d0661b2-00%40eu-central-1.amazonses.com.


Re: [Django] #34059: Validation of check constraints on JSONField key transforms with None produces invalid SQL on PostgreSQL.

2022-09-28 Thread Django
#34059: Validation of check constraints on JSONField key transforms with None
produces invalid SQL on PostgreSQL.
-+-
 Reporter:  Dan LaManna  |Owner:  David
 |  Sanders
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  4.1
  (models, ORM)  |
 Severity:  Release blocker  |   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 David Sanders):

 * needs_better_patch:  0 => 1
 * has_patch:  0 => 1


Comment:

 PR: https://github.com/django/django/pull/16131

 Marking as "needs improvement" as some discussion needs to be had.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/010701838423bcb3-4534b3ef-9ad3-4379-a2f4-b6a700e9e3f2-00%40eu-central-1.amazonses.com.


Re: [Django] #34059: Validation of check constraints on JSONField key transforms with None produces invalid SQL on PostgreSQL. (was: Validation of check constraints on PostgreSQL & Oracle JSON fields

2022-09-28 Thread Django
#34059: Validation of check constraints on JSONField key transforms with None
produces invalid SQL on PostgreSQL.
-+-
 Reporter:  Dan LaManna  |Owner:  David
 |  Sanders
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  4.1
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Mariusz Felisiak):

 Validation of `json_field__key_transform=None` doesn't work only on
 PostgreSQL. Creating check constraint with `__exact` lookup e.g.
 `json_field__key_transform="value"` crashes on Oracle but it's a separate
 issue and not a regression (see #34060).

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107018382e11f5c-fd5ae5b2-a1cf-456a-bb65-9c892c3e4038-00%40eu-central-1.amazonses.com.