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
31015	loss of precision of geometry coordinates on Oracle 18	Sergey Fedoseev	nobody	"This test fails on Oracle 18, but works on Oracle 12 and other backends:

{{{
    def test_round_trip(self):
        g = City.objects.values_list(models.Value(Point(-87.650175, 41.850385), models.PointField()), flat=True)[0]
        self.assertEqual(g.wkt, 'POINT (-87.650175 41.850385)')
}}}

{{{
Traceback (most recent call last):
  File ""/home/jenkins/workspace/pull-requests-oracle/database/oragis18/label/bionic-pr/python/python3.8/tests/gis_tests/geoapp/tests.py"", line 228, in test_round_trip
    self.assertEqual(g.wkt, 'POINT (-87.650175 41.850385)')
AssertionError: 'POINT (-87.65017499999999 41.850385)' != 'POINT (-87.650175 41.850385)'
- POINT (-87.65017499999999 41.850385)
?                 ^^^^^^^^^
+ POINT (-87.650175 41.850385)
?                 ^
}}}

I'm not sure if we should fix it, since it might be treated like Oracle bug, but it looks like it can be fixed by using WKB instead of WKT in queries on Oracle."	Bug	closed	GIS	2.2	Normal	invalid			Unreviewed	0	0	0	0	0	0