Changeset 25198 in main for trunk/db/src/main/scripts/mysql/migrate/4_data-iv_misc.sql

Timestamp:

05/04/22 19:36:40 (3 months ago)

Author:

GarthBraithwaite_STG

Message:

db - updated the ds create to key off of SO3 and "Country" and cleaned out dup SO1 and SO3 usage. Added map_name cleanup to set to None vs DEFAULT. Added more select tests. Added test for VALUE_ATTR and null measure value.

File:

• trunk/db/src/main/scripts/mysql/migrate/4_data-iv_misc.sql (modified) (1 diff)

trunk/db/src/main/scripts/mysql/migrate/4_data-iv_misc.sql

@@ -6 +6 @@
 */
 update INDICATOR_VIEW set MEASURE_TITLE_OVERRIDE = (select MEASURE_TITLE_OVERRIDE from TMP_IPV_MEASURE where IPV_NAME3 = NAME);
-