#25482: Field lookup istartswith not showing results in django 1.8.4 with mysql
5.5.44
-------------------------------+-------------------------
     Reporter:  deepinder19    |      Owner:  nobody
         Type:  Bug            |     Status:  new
    Component:  Uncategorized  |    Version:  1.8
     Severity:  Normal         |   Keywords:  istartswith
 Triage Stage:  Unreviewed     |  Has patch:  0
Easy pickings:  0              |      UI/UX:  0
-------------------------------+-------------------------
 According to documentation istartswith is Case-insensitive starts-with.

 So following query should return results for names starting with keyword
 '''"wash"''':


 {{{
 >>> cities = City.objects.filter(name__istartswith="wash")
 }}}

 But what happens in actual is I am geting results only while using keyword
 '''"Wash"''':


 {{{
 >>> cities = City.objects.filter(name__istartswith="wash")
 >>> cities
 []
 >>> cities = City.objects.filter(name__istartswith="Wash")
 >>> cities
 [<City: Washington>, <City: Washington>, <City: Washington>, <City:
 Washington>, <City: Washington>, <City: Washington>, <City: Washington>,
 <City: Washington>, <City: Washington>, <City: Washington Court House>,
 <City: Washington Terrace>, <City: Washington, D.C.>, <City:
 Washingtonville>, <City: Washougal>]
 }}}

--
Ticket URL: <https://code.djangoproject.com/ticket/25482>
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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/054.14415e1c699c9e290db69bff2ed2f397%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to