On Tue, Feb 12, 2013 at 3:06 PM, Ian Kelly <ian.g.ke...@gmail.com> wrote:
> On Tue, Feb 12, 2013 at 2:25 PM, Aymeric Augustin
> <aymeric.augus...@polytechnique.org> wrote:
>>>>> c.execute("""SELECT "DT" FROM "TIMEZONES_EVENT" WHERE EXTRACT(MONTH FROM
>>>>> CAST((FROM_TZ("DT", 'UTC') AT TIME ZONE (:arg)) AS DATE)) = 1""",
>>>>> ['Africa/Nairobi']).fetchall()
>> Traceback (most recent call last):
>> File "<stdin>", line 1, in <module>
>> cx_Oracle.OperationalError: ORA-03113: end-of-file on communication channel
>>
>> * That's exactly the same query as above, except the time zone name is
>> passed in argument.
>> * Not only does it crash, but it closes the database connection!
>>
>> Obviously I'm hitting a bug in Oracle. Does anyone have ideas to solve this?
>
> I encounter the same bug in Oracle 10g XE. I tried it also on an 11.2
> database, and it seemed to work, but I ran into a different issue:
> neither of the time zones 'Africa/Nairobi' nor 'UTC' existed in the
> database. I substituted 'Africa/Cairo' and 'Etc/GMT' for the test.
> Wondering if that was just a local configuration issue, I tried it
> again on another newer 11.2 database. This one did recognize all the
> time zones, but also exhibited the connection loss bug.
Against the possible issue of non-recognition of UTC, I suggest using
'0:00' instead of 'UTC'.
--
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-developers+unsubscr...@googlegroups.com.
To post to this group, send email to django-developers@googlegroups.com.
Visit this group at http://groups.google.com/group/django-developers?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
