Bug #73811 GLength returns non-INF value on 32bit platforms for linestring of INF length
Submitted: 5 Sep 2014 5:40 Modified: 30 Oct 2014 18:04
Reporter: Wei Zhao Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[5 Sep 2014 5:40] Wei Zhao 
Description:
Glength returns non-INF value on 32bit platforms for linestrings which has INF length on 64bit platforms.

This query:

select GLength(MLineFromWKB(0x0000000005000000020000000002000000035FB317E5EF3AB327E3A4B378469B67320000000000000000C0240000000000003FF05FD8ADAB9F560000000000000000000000000200000003000000000000000000000000000000000000000000000000BFF08B439581062540240000000000004341C37937E08000));
 
returns NULL on 64bit platform and returns 1e172 on 32bit platform.

How to repeat:
select GLength(MLineFromWKB(0x0000000005000000020000000002000000035FB317E5EF3AB327E3A4B378469B67320000000000000000C0240000000000003FF05FD8ADAB9F560000000000000000000000000200000003000000000000000000000000000000000000000000000000BFF08B439581062540240000000000004341C37937E08000));
[30 Oct 2014 18:04] Paul DuBois 
Noted in 5.7.6 changelog.

On 32-bit systems, GLength() returned a non-INF value for LineString
values of infinite length.