[SEDONA-362] RS_BandAsArray truncates the decimal part of float/double pixel values.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.1
• Fix Version/s: 1.5.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Kristin Cowalcijk
• Created: 15/Aug/23 08:34
• Updated: 19/Aug/23 23:31
• Resolved: 19/Aug/23 23:31

Description

When retrieving array from float/double bands using RS_BandAsArray, the band data were truncated. Here is an example:

WITH t AS (SELECT RS_AddBandFromArray(RS_MakeEmptyRaster(1, 2, 2, 0, 0, 1), ARRAY(1.1, 2.2, 3.3, 4.4), 1) rast)
SELECT RS_BandPixelType(rast, 1), RS_BandAsArray(rast, 1) as band FROM t
+-------------------------+--------------------+
|rs_bandpixeltype(rast, 1)|                band|
+-------------------------+--------------------+
|              REAL_64BITS|[1.0, 2.0, 3.0, 4.0]|
+-------------------------+--------------------+

While the expected result is [1.1, 2.2, 3.3, 4.4].

Issue Links

• links to: GitHub Pull Request #971