WCPS1.5_Error when trimming at a point of a axis

[Bang Pham Huu]

WCPS query

for c in (eobstest) return encode(c[t(4:6),Lat(0:0), Long(25)], "csv")

which is translated to Rasql by WCPS 1.5

SELECT encode(c[4:5,0,151:150], "csv" ) FROM eobstest AS c

and throws exception

<ows:Exception exceptionCode="SemanticError">
<ows:ExceptionText>
GRPC Exception: Status code:UNAVAILABLE Status description:Connection going away, but for unknown reason Network channel closed
</ows:ExceptionText>
</ows:Exception>
<ows:Exception exceptionCode="RuntimeError">
<ows:ExceptionText>
java.lang.RuntimeException : GRPC Exception: Status code:UNAVAILABLE Status description:Connection going away, but for unknown reason Network channel closed
</ows:ExceptionText>
</ows:Exception>

while generated Rasql 1.0 query by WCPS 1.0

select csv((c) [4:6,0,151:151]) from eobstest AS c where oid(c)=46081

and returns

{-9999},{-9999}

btw, I think in DescribeCoverage function is inconsistent in time axis?

@Vlad: In coverage description ​https://www.diffchecker.com/6hkrykqf, I see

t (measured in d ) with domain extent from 0 to 6.

<lowerCorner>0 -40.5 25</lowerCorner>
<upperCorner>6 75.5 75.5</upperCorner>

but below this element I see 5 instead of 6 with time axis (t)

<GridEnvelope>
        <low>0 0 0</low>
        <high>5 100 231</high>
</GridEnvelope>

[Dimitar Misev]

Replying to bphamhuu:

WCPS query

for c in (eobstest) return encode(c[t(4:6),Lat(0:0), Long(25)], "csv")

which is translated to Rasql by WCPS 1.5

SELECT encode(c[4:5,0,151:150], "csv" ) FROM eobstest AS c

This looks wrong in any case, c[4:5,0,151:150]

[Bang Pham Huu]

that is the problem, good catch.

[Bang Pham Huu]

The problem of this ticket is due to slicing at a point of a axis, not related to time axis, e.g

for c in (eobstest) return encode ( 
c[t(0), Lat(10:10), Long(26:26) ] , "csv")

returns Rasql query in WCPS 1.5 as Dimitar's point

SELECT encode(c[0,2,131:130], "csv" ) FROM eobstest AS c

[Bang Pham Huu]

It could be also in

98-trim_asterisk_time2.test

for c in ( eobstest ) return encode( c[ Long(69.6), Lat(30.05), t(*:"1950-01-03T13-0500") ], "csv" )

returns WCPS query from WCPS1.5

SELECT encode(c[*:2,89,91:89], "csv" ) FROM eobstest AS c

and 99-trim_asterisk_time3.test

for c in ( eobstest ) return encode( c[ Long(69.6), Lat(30.05), t(*:*) ], "csv" )

with Rasql query returns

SELECT encode(c[*:*,89,91:89], "csv" ) FROM eobstest AS c

[Bang Pham Huu]

Patch was accepted, close ticket.