[mapserver-users] Floating point exception

[Luca Delucchi]

On Fri, 8 Apr 2022 at 15:35, Jeff McKenna <jmckenna at gatewaygeomatics.com> wrote:
>
> Ciao Luca,
>

Jeff,

> What happens when you pass the full query through ogrinfo with the
> "-sql" switch:
>
>    ogrinfo -ro PG:"user=xxxx password=xxxx host=127.0.0.1 port=5432
> dbname=xxxx" -sql "select "short_name"::text,ST_AsBinary(("geom"),'NDR')
> as geom,"research_groups_id"::text from (select research_groups_id,
> short_name, geom from main.research_groups where
> ST_Contains(ST_GeomFromText('POLYGON((-15.2587587587588
> 35,-15.2587587587588 70,37.2587587587588 70,37.2587587587588
> 35,-15.2587587587588 35))',4326), geom)) as subquery"
>

it works properly

Layer name: sql_statement
Geometry: None
Feature Count: 54
Layer SRS WKT:
(unknown)
short_name: String (0.0)
geom: Binary (0.0)
research_groups_id: String (0.0)
OGRFeature(sql_statement):0
  short_name (String) = CROC
  geom (Binary) = 0101000000037AE1CE85E11940F279C5538F784840
  research_groups_id (String) = 1
..........
OGRFeature(sql_statement):53
  short_name (String) = JdE
  geom (Binary) = 010100000035B22B2D236519C0828FC18A53754340
  research_groups_id (String) = 55

At this point I tried to compile the 7.6 version and use the compiled
shp2img and I didn't get anymore the "Floating point exception"
problem. I don't know where it was coming from :-/

>
> -jeff
>

-- 
ciao
Luca

www.lucadelu.org