Ticket #427 (new defect)

Opened 5 years ago

Last modified 5 years ago

Data from PostGIS subqueries sometimes result in duplicate labels

Reported by: v@w.cl Assigned to: refractions
Priority: high Milestone:
Component: PostGIS Interface Version: 4.0
Severity: normal Keywords:
Cc:

Description 

Hello, this is a very weird behaviour I stumbled upon.

When adding a layer from a subquery (geom from (select geom,oid,bla from bla2 
where blu) as foo using unique oid using srid=-1), AND the FORCE parameter of a 
label in a class of that layer is set to TRUE AND/OR POSITION is set to AUTO, 
labels get drawn twice. If I set POSITION to UC,CC, etc OR FORCE to FALSE, the 
labels appear only once as supposed. What's weird about this is that when using 
the same layer but from a shapefile (obtained through pgsql2shp) or in a direct 
query (geom from bla), the labels always appear right.

I'll attach the mapfile, the sql dump and the shapefile

Attachments

bugreport.tgz (304.6 kB) - added by v@w.cl on 09/09/03 12:13:58.
The mapfile, the shapefile and a SQL dump. It's a .tgz file

Change History

09/09/03 12:13:58 changed by v@w.cl

  • attachment bugreport.tgz added.

The mapfile, the shapefile and a SQL dump. It's a .tgz file

09/09/03 12:17:08 changed by v@w.cl 

Oh, I forgot to mention, I'm using PHP 4.3.2, PHP/MapScript 4.0 (only used to 
draw the map this way:
$map = ms_newMapObj("bugreport.map");
$i = $map->draw();
$map->drawLabelCache($i);
)
PostgreSQL 7.3.4 and CVS PostGIS on a Linux 2.4 box

09/09/03 13:06:41 changed by v@w.cl

  • attachments changed.

09/12/03 18:06:47 changed by v@w.cl

  • severity changed from major to normal.