Index: Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs =================================================================== diff -u -rd5963f8720420df8d591646a4d47aa22bb4d6776 -r325db88a5aae33ac33e7293af9a608d6fb1a1019 --- Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision d5963f8720420df8d591646a4d47aa22bb4d6776) +++ Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 325db88a5aae33ac33e7293af9a608d6fb1a1019) @@ -831,39 +831,39 @@ public string GetDuneLocationCalculationsCountValidationQuery(CalculationType calculationType) { return $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + - "SELECT " + + "SELECT " + "COUNT() = 0 " + - "FROM " + + "FROM " + "( " + - "SELECT " + + "SELECT " + "[DuneErosionFailureMechanismMetaEntityId], " + - "COUNT() AS NewCount, " + - "OldCount " + + "COUNT() AS NewCount, " + + "OldCount " + GetDuneLocationCalculationsQuery(calculationType) + - "LEFT JOIN " + - "( " + - "SELECT " + + "LEFT JOIN " + + "( " + + "SELECT " + "[DuneErosionFailureMechanismMetaEntityId], " + "COUNT() as OldCount " + "FROM [SourceProject].DuneErosionFailureMechanismMetaEntity " + "JOIN [SourceProject].DuneLocationEntity USING(FailureMechanismEntityId) " + - "GROUP BY DuneErosionFailureMechanismMetaEntityId " + - ") USING(DuneErosionFailureMechanismMetaEntityId) " + - "GROUP BY DuneErosionFailureMechanismMetaEntityId " + - "UNION " + - "SELECT " + - "[DuneErosionFailureMechanismMetaEntityId], " + + "GROUP BY DuneErosionFailureMechanismMetaEntityId " + + ") USING(DuneErosionFailureMechanismMetaEntityId) " + + "GROUP BY DuneErosionFailureMechanismMetaEntityId " + + "UNION " + + "SELECT " + + "[DuneErosionFailureMechanismMetaEntityId], " + "NewCount, " + "COUNT() AS OldCount " + "FROM [SourceProject].DuneErosionFailureMechanismMetaEntity " + "JOIN [SourceProject].DuneLocationEntity USING(FailureMechanismEntityId) " + - "LEFT JOIN " + - "( " + + "LEFT JOIN " + + "( " + "SELECT " + "[DuneErosionFailureMechanismMetaEntityId], " + "COUNT() as NewCount " + GetDuneLocationCalculationsQuery(calculationType) + - "GROUP BY DuneErosionFailureMechanismMetaEntityId " + + "GROUP BY DuneErosionFailureMechanismMetaEntityId " + ") USING(DuneErosionFailureMechanismMetaEntityId) " + "GROUP BY DuneErosionFailureMechanismMetaEntityId " + ") " + @@ -1857,7 +1857,7 @@ GetHydraulicLocationCalculationsFromFailureMechanismQuery(calculationType) + "LEFT JOIN " + "( " + - "SELECT " + + "SELECT " + "[FailureMechanismEntityId], " + "COUNT(distinct GrassCoverErosionOutwardsHydraulicLocationEntityId) AS OldCount " + "FROM [SOURCEPROJECT].GrassCoverErosionOutwardsHydraulicLocationEntity " +