fix: De-parse TableFunction

Signed-off-by: Andreas Reichel <andreas@manticore-projects.com> Signed-off-by: manticore-projects <andreas@manticore-projects.com>
JSQLParser · Dec 8, 2024 · e122bcf · e122bcf
1 parent 469190d
commit e122bcf
Show file tree

Hide file tree

Showing 2 changed files with 13 additions and 1 deletion.
diff --git a/src/main/java/net/sf/jsqlparser/util/deparser/ExpressionDeParser.java b/src/main/java/net/sf/jsqlparser/util/deparser/ExpressionDeParser.java
@@ -833,6 +833,11 @@ public <S> StringBuilder visit(Function function, S context) {
             } else if (function.isUnique()) {
                 buffer.append("UNIQUE ");
             }
+
+            if (function.getExtraKeyword() != null) {
+                buffer.append(function.getExtraKeyword()).append(" ");
+            }
+
             if (function.getNamedParameters() != null) {
                 function.getNamedParameters().accept(this, context);
             }

diff --git a/src/main/java/net/sf/jsqlparser/util/deparser/SelectDeParser.java b/src/main/java/net/sf/jsqlparser/util/deparser/SelectDeParser.java
@@ -704,7 +704,14 @@ public <S> StringBuilder visit(TableStatement tableStatement, S context) {
 
     @Override
     public <S> StringBuilder visit(TableFunction tableFunction, S context) {
-        buffer.append(tableFunction.toString());
+        if (tableFunction.getPrefix() != null) {
+            buffer.append(tableFunction.getPrefix()).append(" ");
+        }
+        tableFunction.getFunction().accept(this.expressionVisitor, context);
+
+        if (tableFunction.getAlias() != null) {
+            buffer.append(tableFunction.getAlias());
+        }
         return buffer;
     }