From 014f7eba231f2cb7163127de7d1450c44b00e281 Mon Sep 17 00:00:00 2001 From: Stephan Schwär Date: Tue, 20 Apr 2021 16:08:24 +0200 Subject: [server] Remove redundant null in sql query --- .../main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java index db56f78f..ed6cc656 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java @@ -271,10 +271,9 @@ public class DbImage { List versionList = new ArrayList<>(); MysqlStatement stmt = null; if (user.role == Role.STUDENT) { - stmt = connection - .prepareStatement("SELECT" + " imageversionid, createtime, expiretime, filesize, null," - + " isrestricted, isvalid, isprocessed" + " FROM imageversion" - + " WHERE imagebaseid = :imagebaseid AND isrestricted = 0"); + stmt = connection.prepareStatement("SELECT" + " imageversionid, createtime, expiretime, filesize," + + " isrestricted, isvalid, isprocessed" + " FROM imageversion" + + " WHERE imagebaseid = :imagebaseid AND isrestricted = 0"); } else { stmt = connection.prepareStatement( "SELECT" + " imageversionid, createtime, expiretime, filesize, uploaderid," -- cgit v1.2.3-55-g7522