#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 [email protected].
To post to this group, send email to [email protected].
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.
