Requesting help from Oracle backend devs re: regex field lookups

[Tom Tobin]

Now that boulder-oracle-sprint has been merged into trunk, I'd like to
ask the Oracle backend developers to take a look at Ticket #1465,
implementing regular expression field lookups (i.e.,
"somefield__regex=foo" or "somefield__iregex=foo"); the patch there
currently lacks support for Oracle.

Based on docs from oracle.com [1], I *believe* the incantations for Oracle are:

case-sensitive: REGEXP_LIKE(field, pattern, 'c')
case-insensitive: REGEXP_LIKE(field, pattern, 'i')

Am I on target here? Also, are there versions of Oracle usable with
Django that might not support these?

[1] http://www.oracle.com/technology/obe/obe10gdb/develop/regexp/regexp.htm

[Ian Kelly]

Hi Tom,

You've got it right. In addition to Oracle 10g, we're also trying to
support Oracle 9i, which lacks the REGEXP_LIKE condition. However,
Oracle is ending support for 9i this month, so I don't think that we
necessarily need to support new Django features against 9i as long as
the documentation notes that 10g is required.

Let me know if I can be of any other help, e.g. with testing.

Thanks,
Ian

[Tom Tobin]

On 6/26/07, Ian Kelly <ian.g...@gmail.com> wrote:
>
> On 6/23/07, Tom Tobin <kor...@korpios.com> wrote:
> >
> > Am I on target here? Also, are there versions of Oracle usable with
> > Django that might not support these?
>

> Hi Tom,
>
> You've got it right. In addition to Oracle 10g, we're also trying to
> support Oracle 9i, which lacks the REGEXP_LIKE condition. However,
> Oracle is ending support for 9i this month, so I don't think that we
> necessarily need to support new Django features against 9i as long as
> the documentation notes that 10g is required.
>
> Let me know if I can be of any other help, e.g. with testing.

I've updated the attached patch on the ticket [1]; if you could test
it out under Oracle (both trying the field lookups directly, and
running the testing framework) that would be a huge help. :-)

[1] http://code.djangoproject.com/attachment/ticket/1465/regex-field-lookups.patch

[Tom Tobin]

On 6/26/07, Ian Kelly <ian.g...@gmail.com> wrote:
>

> Let me know if I can be of any other help, e.g. with testing.

Thanks for helping me catch that bug; I think the patch is finally
ready to be committed. :-)