 |
TC25 uses and AND instead of an OR. This should be OR because the TC is not a full mandatory constraint. Annotation 2020-03-28 160326.png (98,116 bytes) Annotation 2020-03-28 162132.png (145,906 bytes) |
|
|
Fixed by a new implementation of the SQL Rule: select distinct 'Populations must comply with totality constraints' as name, '"' || otftname || '" misses tuples in: ' || Population_Missing_Under, 'POPULATION' as repositoryType, otftname as repositoryID, 0 as status, 1 as enableEdit from ( select refs.otftname, refs.tc, group_concat(refs.partofft, ' or ') as Population_Missing_Under from ( select o.otftname, tfr.tc, p.tupleno, case when (not pr.tupleno is null) then 'Referenced' else '' end Status, r.partofft from tcforroles tfr -- find TCs join role r on r.roleno = tfr.nonlexrole -- get the TC Role join otft o on o.otftname = r.playedbyot -- get the OTFT played by these Roles join role ro on ro.partofft = o.otftname -- Find the OTFT and it's roles join population p on p.role = ro.roleno -- get the OTFT population which should be referenced by roles under the TC left outer join population pr on pr.role = tfr.nonlexrole and pr.reftupleno = p.tupleno ) refs left outer join ( select o.otftname, tfr.tc, p.tupleno, case when (not pr.tupleno is null) then 'Referenced' else '' end Status, r.partofft from tcforroles tfr -- find TCs join role r on r.roleno = tfr.nonlexrole -- get the TC Role join otft o on o.otftname = r.playedbyot -- get the OTFT played by these Roles join role ro on ro.partofft = o.otftname -- Find the OTFT and it's roles join population p on p.role = ro.roleno -- get the OTFT population which should be referenced by roles under the TC left outer join population pr on pr.role = tfr.nonlexrole and pr.reftupleno = p.tupleno ) used on refs.otftname = used.otftname and refs.tc = used.tc and refs.tupleno = used.tupleno and used.status = 'Referenced' where used.otftname is null group by refs.otftname, refs.tc ) messages order by otftname |
|
|
Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved. |
- Anonymous
