Project

General

Profile

Revision 9c9fe9df

ID9c9fe9df0e457937b29c660986aabd0bb83aad61
Parent f15eb5ec
Child a3cae466

Added by Andreas Müller 6 months ago

fix #7682 set Point.precision to null where 0

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v50_51/SchemaUpdater_50_55.java
84 84
        step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, null, !NOT_NULL);
85 85
        stepList.add(step);
86 86

  
87
        //7682 update Point.precision from 0 to null
88
        stepName = "update Point.precision from 0 to null";
89
        query = "UPDATE @@GatheringEvent@@ SET exactLocation_errorRadius = null WHERE exactLocation_errorRadius = 0 ";
90
        tableName = "GatheringEvent";
91
        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
92
        stepList.add(step);
93

  
87 94
        return stepList;
88 95

  
89 96
	}

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)