LIKE clauses fail in Oracle 220.127.116.11
|Reported by:||JirkaV||Owned by:||nobody|
|Component:||Database layer (models, ORM)||Version:||1.2|
|Cc:||ikelly, mboersma, andrewsk, tsawyer1||Triage Stage:||Accepted|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
I've recently started using Oracle backend, connecting to a database I don't own or operate. I started seeing behaviour described in #5985 (DatabaseError: ORA-01425: escape character must be character string of length 1), fixed in r7412. Since I was hitting an issue that's been apparently fixed, I started digging in history and found that the fix was reverted in r12293 (related ticket: #11017). The fact that it might reintroduce the bug is actually mentioned in the ticket.
I'm happy monkeypatching my Oracle base.py as I may as well be the only person suffering from this issue these days. Mentioning it here mostly for the record, if someone searches for it in future. I'm also happy to help testing any suggested solutions if someone has an idea that would fix #5985 without breaking #11017 again.
For the record, the database I'm connecting to is 18.104.22.168 (I know, old).
Change History (14)
comment:1 Changed 4 years ago by thejaswi_puthraya
- Component changed from Uncategorized to Database layer (models, ORM)
- Needs documentation unset
- Needs tests unset
- Patch needs improvement unset
comment:4 Changed 4 years ago by ikelly
- Summary changed from Oracle backend - conflict between two tickets to LIKE clauses fail in Oracle 22.214.171.124
Changed 4 years ago by ikelly
comment:9 Changed 4 years ago by ikelly
- Has patch set
- Triage Stage changed from Unreviewed to Accepted