commit ac7a31e16f65d5683ea58a89ddffbf9090e63e95
author Rainer Döbele <doebele@apache.org> Mon Mar 29 16:00:21 2021 +0200
committer Rainer Döbele <doebele@apache.org> Mon Mar 29 16:00:21 2021 +0200
tree 8507fde5a74809a8d66b11e849c0d83714044b2d
parent f13449c081d33c7645b76552432cc2a54fc267ff

EMPIREDB-340
dont use command param when value is null

empire-db/src/main/java/org/apache/empire/db/DBCommand.java

diff --git a/empire-db/src/main/java/org/apache/empire/db/DBCommand.java b/empire-db/src/main/java/org/apache/empire/db/DBCommand.java
index b8b8b6f..67b1f6d 100644
--- a/empire-db/src/main/java/org/apache/empire/db/DBCommand.java
+++ b/empire-db/src/main/java/org/apache/empire/db/DBCommand.java
@@ -359,7 +359,7 @@
     protected boolean useCmdParam(DBColumn col, Object value)
     {
         // Cannot wrap DBExpr or DBSystemDate
-        if (value instanceof DBExpr || value instanceof DBDatabase.DBSystemDate)
+        if (value==null || value instanceof DBExpr || value instanceof DBDatabase.DBSystemDate)
             return false;
         // Check if prepared statements are enabled
         if (isPreparedStatementsEnabled())