#25438: Oracle GIS test failures for Django 1.9
----------------------------+------------------------------------
Reporter: timgraham | Owner: nobody
Type: Bug | Status: new
Component: GIS | Version: master
Severity: Normal | Resolution:
Keywords: oracle 1.9 | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
----------------------------+------------------------------------
Comment (by felixxm):
Replying to [ticket:25438 timgraham]:
> After the patch for #24688 to add support for new-style GIS functions,
some test failures remain:
> {{{
>
gis_tests.geoapp.test_functions.GISFunctionsTests.test_difference_mixed_srid
>
> Traceback (most recent call last):
> File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/django/db/utils.py", line 102,
in inner
> return func(*args, **kwargs)
> File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/django/db/backends/oracle/base.py",
line 516, in fetchmany
> return tuple(_rowfactory(r, self.cursor) for r in
self.cursor.fetchmany(size))
> cx_Oracle.DatabaseError: ORA-13199: SRID does not exist.
> ORA-06512: at "MDSYS.MD", line 1723
> ORA-06512: at "MDSYS.MDERR", line 17
> ORA-06512: at "MDSYS.SDO_CS", line 5264
> ORA-06512: at "MDSYS.SDO_CS", line 3034
> }}}
Which Oracle version has been used? In `test_difference_mixed_srid` test
we can find crucial line :
{{{
185: geom = Point(556597.4, 2632018.6, srid=3857) # Spherical
mercator
}}}
as we can see srid=3857 is needed, but it appeared in 11.2.0.3.
http://docs.oracle.com/cd/E24693_01/appdev.11203/e11830/sdo_newfeat.htm
In previous versions we will need to use srid=3785 instead.
--
Ticket URL: <https://code.djangoproject.com/ticket/25438#comment:4>
Django <https://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 unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.0a8b9427409d4d69c6441780c14bc1d9%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
