[mapserver-users] bug: postgis connector subselects

[Twan Kogels]

Hello,

I think i've found a bug in the postgis connector. When you do a subselect 
in the DATA field and the first table is not the table with a geometric 
column, the resultset will be empty.

pc6punten is the table with the geometric column.
objecteigenschappen is a normal table, without geometric information.

A example:
DATA "the_geom from (select p.oid, p.* from pc6punten p, 
objecteigenschappen o where o.eigenschap_3=p.pc6) as foo"
Works oke, because in pc6punten a geometric column named the_geom exists.

DATA "the_geom from (select p.oid, p.* from objecteigenschappen o, 
pc6punten p where o.eigenschap_3=p.pc6) as foo"
Returns a empty resultset aka no points.

Anothe example:
DATA "the_geom from (select p.oid, p.* from pc6punten p left join 
objecteigenschappen o on p.pc6=o.eigenschap_3 where o.keur<>'') as foo"
Works oke.

DATA "the_geom from (select p.oid, p.* from objecteigenschappen o left join 
pc6punten p on p.pc6=o.eigenschap_3 where o.keur<>'') as foo"
Returns a empty resultset.

When using a normal postgresql client, all queries returns points.

I'm using mapserver 3.6.

Best regards,
Twan



-- 
http://www.twansoft.com