Opened 8 years ago
Closed 8 years ago
#28151 closed Bug (wontfix)
'__startswith' issue on Oracle 10G
| Reported by: | Daniel Klass | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 1.10 |
| Severity: | Normal | Keywords: | Oracle, ORM, Queryset, startswith |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
I have a string that contains literal underscores that is being used in a 'startswith' query. I get
ORA-01424: missing or illegal character following the escape character
The query looks as so:
SELECT ... FROM... WHERE LIKE TRANSLATE(Some\_thing\_here\_now% USING NCHAR_CS) ESCAPE TRANSLATE(\ USING NCHAR_CS)
Change History (3)
comment:1 by , 8 years ago
comment:2 by , 8 years ago
I don't have access to other Oracle instances, so I'll close this issue. Thank you for your help!
comment:3 by , 8 years ago
| Resolution: | → wontfix |
|---|---|
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
Is the issue specific to Oracle 10? Django 1.7 is the last version of Django to support that version. (see the 1.8 release note)