#34079: Excessive parentheses when generating a query
-----------------------------------------+------------------------
               Reporter:  Lelikov        |          Owner:  nobody
                   Type:  Uncategorized  |         Status:  new
              Component:  Uncategorized  |        Version:  4.1
               Severity:  Normal         |       Keywords:
           Triage Stage:  Unreviewed     |      Has patch:  0
    Needs documentation:  0              |    Needs tests:  0
Patch needs improvement:  0              |  Easy pickings:  0
                  UI/UX:  0              |
-----------------------------------------+------------------------
 ORM:
 {{{
 Model.objects.filter(field=Func(F("user__notification_email_types"),
 function="ANY")
 }}}

 SQL:
 {{{
 ..."app_model"."filed" = (ANY("app_user"."notification_email_types")))
 }}}

 Error:
 {{{
 syntax error at or near "ANY"
 }}}

 The reason for the code change in version 4.0. The excessive parentheses
 around the function ANY
 django/db/models/lookups.py
 {{{
 if sql and sql[0] != "(":
     sql = "(%s)" % sql
 }}}
 In version 3.2 everything worked correctly

-- 
Ticket URL: <https://code.djangoproject.com/ticket/34079>
Django <https://code.djangoproject.com/>
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/01070183bd89e6bc-3999abab-96dd-497f-91a9-1a1f2c661be8-000000%40eu-central-1.amazonses.com.

Reply via email to