#5985: ORA-01425: escape character must be character string of length 1
---------------------------------------+------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: nobody
Status: new | Component: Database wrapper
Version: SVN | Keywords: ORACLE
Stage: Unreviewed | Has_patch: 0
---------------------------------------+------------------------------------
Hello,
In order to update my project to a later version of trunk, I recreated all
tables in my DB (dropped all tables and sequences, and then performed a
syncdb with the newer django version)
My Database is an Oracle 9i.
Strangely enough, now I get 500 server errors executing some of my views
(that worked fine previously).
The problem is always:
ORA-01425: escape character must be character string of length 1
I know, this sounds related to ticket 5558, but it isnt
I looked in the debug view, which query is executed when the problem
arises, and it looks as follows:
{{{
args [':arg0', ':arg1', ':arg2']
i 2
params ('2007-10-21 00:00:00', '2007-11-19 16:08:17.025442', 'webb%')
query u'SELECT COUNT(*) FROM "LOG_JOBSTATUS" INNER JOIN "CONFIG_CHANNEL"
"LOG_JOBSTATUS__CHANNEL" ON "LOG_JOBSTATUS"."CHANNEL_ID" =
"LOG_JOBSTATUS__CHANNEL"."ID" WHERE ("LOG_JOBSTATUS"."STARTED" BETWEEN
:arg0 AND :arg1 AND UPPER("LOG_JOBSTATUS__CHANNEL"."NAME") LIKE
UPPER(:arg2) ESCAPE \'\\\')'
self <django.db.backends.oracle.base.FormatStylePlaceholderCursor on
<cx_Oracle.Connection to
mcca@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=arnd.svt.se)(PORT=1522)))(CONNECT_DATA=(SID=matd)))>>
}}}
Oracle's problem seems to be the '''ESCAPE \'\\\' ''' at the end of the
sql query string.
I looked at oracle/base.py and saw that the original string is ''' ESCAPE
'\\' '''. Looks like a bug in the escape handling to me (i.e. the quotes
are escaped before the escaped backslash is un-escaped). Or something like
that....
--
Ticket URL: <http://code.djangoproject.com/ticket/5985>
Django Code <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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
