#24164: Oracle GIS geoapp extent test failure
---------------------------+-------------------------------------
Reporter: timgraham | Owner: nobody
Type: Bug | Status: new
Component: GIS | Version: 1.8alpha1
Severity: Normal | Resolution:
Keywords: oracle | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
---------------------------+-------------------------------------
Comment (by shaib):
The failing SQL is:
{{{#!sql
SELECT SDO_AGGR_MBR("__COL1") FROM (
SELECT * FROM (
SELECT "_SUB".*, ROWNUM AS "_RN" FROM (
SELECT "GEOAPP_CITY"."ID" AS Col1, "GEOAPP_CITY"."NAME" AS Col2,
SDO_UTIL.TO_WKTGEOMETRY("GEOAPP_CITY"."POINT") AS Col3,
SDO_UTIL.TO_WKTGEOMETRY("GEOAPP_CITY"."POINT") AS "__COL1"
FROM "GEOAPP_CITY"
) "_SUB" WHERE ROWNUM <= 3
) WHERE "_RN" > 0) subquery
}}}
An earlier query which succeeds in that test is
{{{#!sql
SELECT SDO_UTIL.TO_WKTGEOMETRY(SDO_AGGR_MBR("GEOAPP_CITY"."POINT")) AS
"POINT__EXTENT"
FROM "GEOAPP_CITY"
}}}
So it seems the problem is that `SDO_UTIL.TO_WKTGEOMETRY` is being called
"too soon"; it apparently needs to be called on geometric result values in
order to return the right type to the user, but here it is applied to an
intermediate result (before it is passed to the aggregate).
In particular, this means there is a real problem here, not just a testing
problem; skipping is the wrong solution.
--
Ticket URL: <https://code.djangoproject.com/ticket/24164#comment:1>
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.c7cfa25de239a9702da5b2df43e14918%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
