diff -r 8be80ea4f52b -r 250c5cbb8276 src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java --- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Sat Aug 29 16:48:15 2020 +0200 +++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Sat Aug 29 17:13:09 2020 +0200 @@ -54,7 +54,7 @@ "userid, username, givenname, lastname, mail, " + "created, updated, eta " + "from lpit_issue i " + - "left join lpit_project p on project = projectid " + + "join lpit_project p on project = projectid " + "left join lpit_user on userid = assignee " + "where project = ? "+ "order by eta asc, updated desc"); @@ -67,10 +67,10 @@ "userid, username, givenname, lastname, mail, " + "created, updated, eta " + "from lpit_issue i " + - "join issue_version using (issueid) "+ - "left join lpit_project p on project = projectid " + + "join lpit_project p on project = projectid " + + "left join issue_version using (issueid) "+ "left join lpit_user on userid = assignee " + - "where versionid = ? "+ + "where coalesce(versionid,-1) = ? "+ "order by eta asc, updated desc" ); @@ -222,7 +222,7 @@ @Override public List list(Version version) throws SQLException { - return list(listForVersion, version.getId()); + return list(listForVersion, version == null ? -1 : version.getId()); } @Override