rasql - error inserting float null value for collection with composite bands

[Bang Pham Huu]

This float null value 9.96921e+35 is used on a collection with 3 bands. Queries below generated by petascope:

CREATE TYPE test_AverageTemperature_Cell AS ( band0 char, band1 char, band2 char )

CREATE TYPE test_AverageTemperature_Array AS test_AverageTemperature_Cell MDARRAY [D0,D1,D2]

CREATE TYPE test_AverageTemperature_Set AS SET (test_AverageTemperature_Array NULL VALUES [9.96921e+35])

INSERT INTO test_AverageTemperature VALUES <[0:0,0:0,0:0] {9.96921e+35c,9.96921e+35c,9.96921e+35c}> TILING ALIGNED [0:0, 0:999, 0:999]'. Reason: Parsing error 300 in line 1, column 71: Unexpected name c.

Error evaluating rasdaman query: 'INSERT INTO test_AverageTemperature VALUES <[0:0,0:0,0:0] {9.96921e+35c,9.96921e+35c,9.96921e+35c}> TILING ALIGNED [0:0, 0:999, 0:999]'. 

Reason: Parsing error 300 in line 1, column 71: Unexpected name c.

[Dimitar Misev]

9.96921e+35c is not a valid constant. As you can see ​here, suffix c is for char values, not float.

[Bang Pham Huu]

The float number is invalid to put on collection with char data type. Rasdaman validates it already and throws error.

[Dimitar Misev]

Yes it's invalid, it should be fixed in petascope.

[Dimitar Misev]

Sorry I didn't notice that the bands are char, so this is a user error as it provided out of range null value.