(empire-db) branch master updated: EMPIREDB-456 DBMSHandlerOracle: decode formatting fix

[doebele]

This is an automated email from the ASF dual-hosted git repository.

doebele pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/empire-db.git


The following commit(s) were added to refs/heads/master by this push:
     new 0e83bf79 EMPIREDB-456 DBMSHandlerOracle: decode formatting fix
0e83bf79 is described below

commit 0e83bf7944421d2c26f3ff1633e8f1bd48fce6c5
Author: Rainer Döbele <doeb...@apache.org>
AuthorDate: Fri Mar 28 11:27:17 2025 +0100

    EMPIREDB-456
    DBMSHandlerOracle: decode formatting fix
---
 .../main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java    | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java 
b/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java
index ff997b0f..dfea4bc4 100644
--- 
a/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java
+++ 
b/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java
@@ -228,8 +228,8 @@ public class DBMSHandlerOracle extends DBMSHandlerBase
             case SQL_FUNC_AVG:                  return "avg(?)";
             case SQL_FUNC_STRAGG:               return "listagg(?,{0}) WITHIN 
GROUP (ORDER BY {1})";
             // Others
-            case SQL_FUNC_DECODE:               return "decode(? {0})";
-            case SQL_FUNC_DECODE_SEP:           return ",";
+            case SQL_FUNC_DECODE:               return "decode(?{0})";
+            case SQL_FUNC_DECODE_SEP:           return ", ";
             case SQL_FUNC_DECODE_PART:          return "{0}, {1}";
             case SQL_FUNC_DECODE_ELSE:          return "{0}";
             // Not defined