Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.0_4.9.1.sql =================================================================== diff -u -r19866 -r19879 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.0_4.9.1.sql (.../4.9.0_4.9.1.sql) (revision 19866) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.0_4.9.1.sql (.../4.9.0_4.9.1.sql) (revision 19879) @@ -1 +1 @@ -update PackingRecord set tousseDefinitionId=(select distinct ti.tousseDefinition_id from TousseInstance ti where ti.packingRecord_id=PackingRecord.id) where tousseDefinitionId is null; \ No newline at end of file +update PackingRecord set tousseDefinitionId=(select min(ti.tousseDefinition_id) from TousseInstance ti where ti.packingRecord_id=PackingRecord.id group by ti.packingRecord_id) where tousseDefinitionId is null; \ No newline at end of file