id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
25438	Oracle GIS test failures for Django 1.9	Tim Graham	nobody	"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

Traceback (most recent call last):
  File ""/mnt/jenkinsdata/workspace/pull-requests-oracle/database/oragis11/python/python3.5/django/test/testcases.py"", line 1093, in skip_wrapper
    return test_func(*args, **kwargs)
  File ""/mnt/jenkinsdata/workspace/pull-requests-oracle/database/oragis11/python/python3.5/tests/gis_tests/geoapp/test_functions.py"", line 180, in test_difference
    self.assertEqual(c.mpoly.difference(geom), c.diff)
AssertionError: <MultiPolygon object at 0x7f768d20f450> != <MultiPolygon object at 0x7f768d1df2b8>

gis_tests.geoapp.test_functions.GISFunctionsTests.test_intersection

Traceback (most recent call last):
  File ""/mnt/jenkinsdata/workspace/pull-requests-oracle/database/oragis11/python/python3.5/django/test/testcases.py"", line 1093, in skip_wrapper
    return test_func(*args, **kwargs)
  File ""/mnt/jenkinsdata/workspace/pull-requests-oracle/database/oragis11/python/python3.5/tests/gis_tests/geoapp/test_functions.py"", line 234, in test_intersection
    self.assertEqual(c.inter, expected)
AssertionError: '' != <GeometryCollection object at 0x7f768ea5a120>

gis_tests.geoapp.test_functions.GISFunctionsTests.test_difference_mixed_srid

Traceback (most recent call last):
  File ""/home/jenkins/workspace/django-oracle-1.9/database/oragis12/label/trusty/python/python2.7/django/test/testcases.py"", line 1093, in skip_wrapper
    return test_func(*args, **kwargs)
  File ""/home/jenkins/workspace/django-oracle-1.9/database/oragis12/label/trusty/python/python2.7/tests/gis_tests/geoapp/test_functions.py"", line 191, in test_difference_mixed_srid
    self.assertEqual(c.mpoly.difference(geom), c.difference)
AssertionError: <MultiPolygon object at 0x7f3422ed02e0> != <MultiPolygon object at 0x7f3422ed0130>

gis_tests.geogapp.tests.GeographyFunctionTests.test_distance_function

Traceback (most recent call last):
  File ""/mnt/jenkinsdata/workspace/pull-requests-oracle/database/oragis11/python/python3.5/django/test/testcases.py"", line 1093, in skip_wrapper
    return test_func(*args, **kwargs)
  File ""/mnt/jenkinsdata/workspace/pull-requests-oracle/database/oragis11/python/python3.5/tests/gis_tests/geogapp/tests.py"", line 120, in test_distance_function
    self.assertAlmostEqual(z.distance.m, ref, 2)
AssertionError: 4899.67677194225 != 4891.2 within 2 places
}}}

New since Jenkins was updated from Oracle 11 to Oracle 12.1.0.2.0:
{{{
gis_tests.geoapp.test_functions.GISFunctionsTests.test_sym_difference

Items in the first set but not the second: u'POLYGON ((-103.0024339999999938 36.5003969999999995, -103.0419239999999945 36.5004390000000001, .............

gis_tests.geogapp.tests.GeographyFunctionTests.test_geography_area
gis_tests.geogapp.tests.GeographyTest.test06_geography_area (same issue probably)

Traceback (most recent call last):
  File ""/home/jenkins/workspace/django-oracle-1.9/database/oragis12/label/trusty/python/python2.7/django/test/testcases.py"", line 1093, in skip_wrapper
    return test_func(*args, **kwargs)
  File ""/home/jenkins/workspace/django-oracle-1.9/database/oragis12/label/trusty/python/python2.7/tests/gis_tests/geogapp/tests.py"", line 131, in test_geography_area
    self.assertAlmostEqual(z.area.sq_m, ref_area, tol)
AssertionError: 5439100.13586914 != 5439100.95415646 within 5 places"	Bug	closed	GIS	dev	Normal	fixed	oracle 1.9	Jani Tiainen felisiak.mariusz@…	Accepted	0	0	0	0	0	0