#3274 closed defect (fixed)
msPostGISLayerGetItems() error with !BOX! macro
Reported by: | szigeti | Owned by: | pramsey |
---|---|---|---|
Priority: | normal | Milestone: | 6.0 release |
Component: | PostGIS Interface | Version: | svn-trunk (development) |
Severity: | normal | Keywords: | !BOX!, LayerGetItems |
Cc: |
Description
The msPostGISLayerGetItems()
function performs an sql query, but in the
query string the !BOX!
macro is not substituted by any valid expression,
so the postrgesql backend complains about some unknown column.
In the patch I have written !BOX!
is replaced by "st_setsrid(st_makebox2d(st_point(0,0),st_point(0,0)),4326)"
.
Maybe it is not the best choice, since it uses a predefined srid value..
Feel free to apply/rewrite the patch!
Attachments (1)
Change History (3)
by , 14 years ago
Attachment: | postgis_box.patch added |
---|
comment:1 by , 14 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:2 by , 13 years ago
Milestone: | → 6.0 release |
---|
Note:
See TracTickets
for help on using tickets.
I didn't use the patch, but this issue provided some good motivation to investigate and rationalize how !BOX! is handled throughout the code. Thanks, committed a change at r9737 in trunk.