[Django] #25599: __iexact filter matches strings of different length
Django
-------------------------------------+-------------------------------------
Reporter: ahalma | Owner: nobody
Type: Uncategorized | Status: new
Component: Database layer | Version: 1.8
(models, ORM) | Keywords: iexact, filter, query,
Severity: Normal | model
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
I would expect that the __iexact filter for querying models only results
in string matches that possibly differ in case, however, it also matches
prefixes...
{{{
MyModel.objects.filter(name__iexact='king').all()
[<MyModel: KING>, <MyModel: King of Spain>, <MyModel: King of Holland>]
}}}
This looks more like __icontains to me... I expected only [<MyModel:
KING>]
--
Ticket URL: <https://code.djangoproject.com/ticket/25599>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
-------------------------------------+-------------------------------------
Reporter: ahalma | Owner: nobody
Component: Database layer | Version: 1.8
(models, ORM) |
Keywords: iexact, filter, | Triage Stage:
query, model | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* needs_better_patch: => 0
* type: Uncategorized => Bug
* needs_tests: => 0
* needs_docs: => 0
--
Ticket URL: <https://code.djangoproject.com/ticket/25599#comment:1>
Django
-------------------------------------+-------------------------------------
Reporter: ahalma | Owner: nobody
Component: Database layer | Version: 1.8
(models, ORM) |
Keywords: iexact, filter, | Triage Stage:
query, model | Unreviewed
Has patch: 0 | Needs documentation: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Old description:
> I would expect that the __iexact filter for querying models only results
> in string matches that possibly differ in case, however, it also matches
> prefixes...
>
> {{{
> MyModel.objects.filter(name__iexact='king').all()
> [<MyModel: KING>, <MyModel: King of Spain>, <MyModel: King of Holland>]
> }}}
>
> This looks more like __icontains to me... I expected only [<MyModel:
> KING>]
New description:
I would expect that the `__iexact` filter for querying models only results
in string matches that possibly differ in case, however, it also matches
prefixes...
{{{
MyModel.objects.filter(name__iexact='king').all()
[<MyModel: KING>, <MyModel: King of Spain>, <MyModel: King of Holland>]
}}}
This looks more like `__icontains` to me... I expected only [<MyModel:
KING>]
--
Comment (by timgraham):
What database are you using?
--
Ticket URL: <https://code.djangoproject.com/ticket/25599#comment:2>
Django
-------------------------------------+-------------------------------------
Reporter: ahalma | Owner: nobody
Component: Database layer | Version: 1.8
(models, ORM) |
Keywords: iexact, filter, | Triage Stage:
query, model | Unreviewed
Has patch: 0 | Needs documentation: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* status: new => closed
* resolution: => invalid
Old description:
> I would expect that the `__iexact` filter for querying models only
> results in string matches that possibly differ in case, however, it also
> matches prefixes...
>
> {{{
> MyModel.objects.filter(name__iexact='king').all()
> [<MyModel: KING>, <MyModel: King of Spain>, <MyModel: King of Holland>]
> }}}
>
> This looks more like `__icontains` to me... I expected only [<MyModel:
> KING>]
New description:
I would expect that the __iexact filter for querying models only results
in string matches that possibly differ in case, however, it also matches
prefixes...
{{{
MyModel.objects.filter(name__iexact='king').all()
[<MyModel: KING>, <MyModel: King of Spain>, <MyModel: King of Holland>]
}}}
This looks more like __icontains to me... I expected only [<MyModel:
KING>]
--
--
Ticket URL: <https://code.djangoproject.com/ticket/25599#comment:3>