#11017: Oracle LIKEC query doesn't use index
---------------------------------------------------+------------------------
Reporter: jtiai | Owner: nobody
Status: new | Milestone: 1.2
Component: Database layer (models, ORM) | Version: SVN
Resolution: | Keywords: oracle
Stage: Accepted | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Comment (by jtiai):
It seems that there is some bug in Oracle 9.2.0.5 and previous versions
that didn't correctly handled escape. It's been fixed in later patchsets.
Because original report in #5985 didn't state which version Oracle was
used it is hard to tell was it Oracle bug or something else.
Known workaround for Oracle versions 9.2.0.5 and earlier is to use:
{{{
LIKE TRANSLATE(%s USING NCHAR_CS) ESCAPE TRANSLATE('\\' USING NCHAR_CS)
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/11017#comment:12>
Django <http://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 post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
