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
9794	GeoDjango Distance Test Failures on Oracle 11g	jbronn	jbronn	"Ran the !GeoDjango test suite on Oracle 11g and received the following errors:
{{{
======================================================================
FAIL: Testing GML output from the database using GeoManager.gml().
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""C:\Program Files\GeoDjango\Django-1.0.2-final\django\contrib\gis\tests\geoapp\tests.py"", line 155, in test03b_gml
    self.assertEqual(True, bool(gml_regex.match(ptown.gml)))
AssertionError: True != False

======================================================================
FAIL: Testing the `distance` GeoQuerySet method on projected coordinate systems.

----------------------------------------------------------------------
Traceback (most recent call last):
  File ""C:\Program Files\GeoDjango\Django-1.0.2-final\django\contrib\gis\tests\distapp\tests.py"", line 129, in test03a_distance_method
    self.assertAlmostEqual(m_distances[i], c.distance.m, tol)
AssertionError: 147075.06981300001 != 44828.570935898977 within 2 places

======================================================================
FAIL: Testing the `distance_lt`, `distance_gt`, `distance_lte`, and `distance_gte` lookup types.
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""C:\Program Files\GeoDjango\Django-1.0.2-final\django\contrib\gis\tests\distapp\tests.py"", line 200, in test04_distance_lookups
    self.assertEqual(cities, ['Bellaire', 'Pearland', 'West University Place'])
AssertionError: [] != ['Bellaire', 'Pearland', 'West University Place']

}}}

The first failure is simply different precision values in the GML output, and is easily solved with a better regex in the test suite.  The next two problems from the distance test suite, however, will require more investigative work."		closed	GIS	1.0		fixed	gis oracle 11g distance	Erin Kelly Matt Boersma	Accepted	0	0	0	0	0	0