Custom Query (2765 matches)

Hello,

There is a little error in file "rasdaman/petascope/db/update0.sql" at row # 292 the PK is duplicated and the FK is wrong.

the original query: INSERT INTO ps_descriptions VALUES (1, 1, 'mean_summer_airtemp', 'This coverage shows the mean summer air temperatures over Australia in the period 2001-2007', 'summere temperature, australia');

probably you want to insert the coverage description like INSERT INTO ps_descriptions VALUES (2, 2, 'mean_summer_airtemp', 'This coverage shows the mean summer air temperatures over Australia in the period 2001-2007', 'summer temperature, australia');

Regards

Damiano

• the default 'labels.txt' of rView seems to be (accidentally) overwritten with the rView binary itself resulting in '???'-labels and a bad-line-format-message

bug derived by a discussion on rasdaman-users mailing list at ​http://groups.google.com/group/rasdaman-users/browse_thread/thread/bc36ed6e58cad3ba?hl=en

The following two query reproduce the error on a collection initialized as shown later on: rasql -q 'update aatsr as m set m[5, 100:355, 100:310] assign inv_tiff($1)' -f mr_1.tif rasql -q "update aatsr as m set m[5, 100:355, 100:310] assign shift(inv_tiff(\$1),[100, 100])" -f mr_1.tif

where aatsr is a 3D collection defined as atsrSet on the following types: typedef marray <char, [*:*, *:*, 0:*]> atsr; typedef set<atsr> atsrSet

initialised with: rasql -q "insert into aatsr values marray x in[0:0,0:0,0:0] values 0c"

the image used on this test (mr_1.tif) is the single band tif image included on the rasdaman package at: "/rasdaman/manuals_and_examples/examples/images"

the problem is for me critical since it limits the possibility of updating a 3D collection

Damiano