RASQL error when requesting time interval that is not aligned with coverage time grid

[Javier Urien]

Starting from the coverage and data provided at: ​https://drive.google.com/file/d/1jAGFgRAY-5n93vrenxdFOClBht6_xtRZ/view?usp=drive_link

And configuring the WMS layer with a style with a RASQL to select the first band: $c.0

When requesting an time interval where only one one time slice is present, the request returns with an error.

Request:

/rasdaman/ows?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image%2Fpng&TRANSPARENT=true&LAYERS=mosaico_small&STYLES=&SRS=EPSG%3A3857&CRS=EPSG%3A3857&TILED=true&time=2022-07-25T12%3A00%3A00.560Z%2F2022-07-26T12%3A00%3A00.307Z&_v_=1695477921200&WIDTH=256&HEIGHT=256&BBOX=-6741134.398526264%2C-4657155.259359218%2C-6736242.428716013%2C-4652263.289548967

Error:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ows:ExceptionReport version="2.0.1"
    xsi:schemaLocation="http://www.opengis.net/ows/2.0 http://schemas.opengis.net/ows/2.0/owsExceptionReport.xsd"
    xmlns:ows="http://www.opengis.net/ows/2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xlink="http://www.w3.org/1999/xlink">
    <ows:Exception exceptionCode="RasdamanRequestFailed" >
        <ows:ExceptionText>Failed to run query: SELECT ENCODE((  ( project( ( ( c0[3,1207:1497,-417:-46] OVERLAY c0[4,1207:1497,-417:-46].0 ) ), "-60.59697021835936982499, -38.5826119505859409966, -60.51618861835936737186, -38.4793447505859401782" , "EPSG:4326" , "-6741134.398526264, -4657155.259359218, -6736242.428716013, -4652263.289548967" , "EPSG:3857" , 256, 256, near, 0.125 ) )  ), "png", "{\"colorMap\":{\"type\":\"ramp\",\"colorTable\":{\"0\":[0,0,0,0],\"5\":[128,0,0,255],\"10\":[255,0,0,255],\"15\":[255,128,0,255],\"20\":[255,255,0,255],\"25\":[127,255,129,255],\"30\":[0,255,255,255],\"35\":[0,128,255,255],\"40\":[0,0,255,255],\"45\":[38,38,38,255]}},\"nodata\":[0.0]}") FROM mosaico_small AS c0. Reason: Execution error 381 in line 1, column 8, near token ENCODE: Error in convertor of the selected data exchange format.</ows:ExceptionText>
    </ows:Exception>
</ows:ExceptionReport>

From what I can tell, the query that is sent to rasdaman should not include 2 time slices (3 and 4) just the one that is inside the interval requested.
But also there is another thing that is what is triggering the error: the first time requested does not include the band 0 as does the second.

Regards

[Javier Urien]

From what I can tell, the query that is sent to rasdaman should not include 2 time slices (3 and 4) just the one that is inside the interval requested.

If I am reading correctly from: ​https://doc.rasdaman.org/05_geo-services-guide.html#subsetting-behavior the above is wrong.