#17448: Error reading PointField in objects.raw(sql) query
-----------------------------+---------------------------------------
Reporter: oluckyman | Owner: DavidEklund
Type: Bug | Status: reopened
Component: GIS | Version: 1.3
Severity: Normal | Resolution:
Keywords: raw sql gis | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-----------------------------+---------------------------------------
Changes (by claudep):
* status: closed => reopened
* resolution: fixed =>
Comment:
This is failing with MySQL, see http://ci.django-cms.org/job/Django/1571/
As far as I understand, the default return value from a geometry field in
`PostGis` is returned as a HEXEWKB string which is recognized by the
GEOSGeometry constructor. However, with MySQL, the default return value is
an internal representation not understood by GEOSGeometry. Hence the
required asText() or asBinary() function around the geometry field in the
SQL query string. This should be documented.
--
Ticket URL: <https://code.djangoproject.com/ticket/17448#comment:13>
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 post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit https://groups.google.com/groups/opt_out.
