Actions
bug #9124
closedAltitude feature should have [m] as measurement unit by default
Start date:
Due date:
% Done:
100%
Estimated time:
Severity:
normal
Found in Version:
Description
This requires that measurement units are loaded before.
Update script needed
Related issues
Updated by Andreas Müller over 3 years ago
- Related to feature request #9043: Add feature "Altitude" added
Updated by Andreas Müller about 3 years ago
- Priority changed from New to Highest
Updated by Andreas Müller about 3 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 50
Updated by Andreas Müller about 3 years ago
The first implementatin of the update script had a serious bug as it filled the table DefinedTermBase_StatisticalMeasure instead of DefinedTermBase_MeasurementUnit.
This is fixed and an update script for the wrong update is committed. The result can be checked by:
SELECT MN.feature_id, MN.recommendedstatisticalmeasures_id
FROM DefinedTermBase_StatisticalMeasure MN
INNER JOIN DefinedTermBase alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase sm ON sm.id = MN.recommendedstatisticalmeasures_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671' AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6';
SELECT MN.REV, MN.feature_id, MN.recommendedstatisticalmeasures_id
FROM DefinedTermBase_StatisticalMeasure_AUD MN
INNER JOIN DefinedTermBase_AUD alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase_AUD sm ON sm.id = MN.recommendedstatisticalmeasures_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671' AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6';
SELECT MN.feature_id, MN.recommendedmeasurementunits_id
FROM DefinedTermBase_MeasurementUnit MN
INNER JOIN DefinedTermBase alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase sm ON sm.id = MN.recommendedmeasurementunits_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671' AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6';
SELECT MN.REV, MN.feature_id, MN.recommendedmeasurementunits_id
FROM DefinedTermBase_MeasurementUnit_AUD MN
INNER JOIN DefinedTermBase_AUD alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase_AUD sm ON sm.id = MN.recommendedmeasurementunits_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671' AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6'
Updated by Andreas Müller about 3 years ago
- % Done changed from 50 to 90
I tested on test and integration. The result looks fine. But we should also run on production once after the release therefore I keep ticket open.
Updated by Andreas Müller about 3 years ago
- Target version changed from CDM UML 5.42 to Release 5.18
Updated by Andreas Müller about 3 years ago
- % Done changed from 90 to 100
I expect this to work so I close the ticket.
Updated by Andreas Müller about 3 years ago
- Status changed from Resolved to Closed
Actions