Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171011.sql =================================================================== diff -u -rba995699c252120c1dfcbf13e0043993a804abe6 -rb84f4507a85a8c50ffcce01b5c5a988ac56f0849 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171011.sql (.../patch20171011.sql) (revision ba995699c252120c1dfcbf13e0043993a804abe6) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171011.sql (.../patch20171011.sql) (revision b84f4507a85a8c50ffcce01b5c5a988ac56f0849) @@ -11,7 +11,7 @@ WHERE (a.assessment_uid = b.assessment_uid OR a.assessment_uid IS NULL AND b.assessment_uid IS NULL) AND (a.user_uid = b.user_uid OR a.user_uid IS NULL AND b.user_uid IS NULL) - AND (a.latest = b.latest AND latest = 1) + AND (a.latest = 1 AND b.latest = 1) AND a.uid < b.uid; --set up tl_laasse10_assessment_result table to properly handle constraint