Opened 13 years ago
Closed 13 years ago
#71 closed defect (fixed)
Error in petascope update query
Reported by: | Owned by: | Dimitar Misev | |
---|---|---|---|
Priority: | minor | Milestone: | |
Component: | petascope | Version: | 8.2 |
Keywords: | Cc: | ||
Complexity: | Medium |
Description
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
Fixed now, thanks for reporting!