diff options
author | Yorhel <git@yorhel.nl> | 2018-10-25 10:24:34 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2018-10-25 10:29:18 +0200 |
commit | 95feae6a676d5d312b2ad9b2994d56842acb4795 (patch) | |
tree | 6b5ea687c401931bf95ba2edb453576a61fa774c /lib/VNDB/Util | |
parent | 22b070a421fd15435cd10d4084fea05526660c11 (diff) |
DB::Releases: Don't return duplicate releases in dbReleaseGet(vid => [...])
In the special case where the releases of multiple VNs are requested,
and those VNs have releases in common, dbReleaseGet() would return those
releases multiple times. Using a JOIN in order to filter rows isn't safe
if the join condition isn't unique - so use an "id IN(SELECT ..)" filter
instead.
(I found this while editing c15068 and noticing that some releases were
listed twice in the edit form. Editing that entry without manually
removing those duplicates would trigger an internal server error due to
duplicate relations)
Diffstat (limited to 'lib/VNDB/Util')
0 files changed, 0 insertions, 0 deletions