Repository: ranger Updated Branches: refs/heads/ranger-1 0a3029341 -> b6df76134
RANGER-2242: JiSQL utility is failing Oracle UDF Project: http://git-wip-us.apache.org/repos/asf/ranger/repo Commit: http://git-wip-us.apache.org/repos/asf/ranger/commit/b6df7613 Tree: http://git-wip-us.apache.org/repos/asf/ranger/tree/b6df7613 Diff: http://git-wip-us.apache.org/repos/asf/ranger/diff/b6df7613 Branch: refs/heads/ranger-1 Commit: b6df76134daf7d4b58a7592f7b4d88b7249119ec Parents: 0a30293 Author: Pradeep <[email protected]> Authored: Fri Oct 5 18:46:49 2018 +0530 Committer: Pradeep <[email protected]> Committed: Fri Oct 12 11:56:25 2018 +0530 ---------------------------------------------------------------------- jisql/src/main/java/org/apache/util/sql/Jisql.java | 3 +++ 1 file changed, 3 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ranger/blob/b6df7613/jisql/src/main/java/org/apache/util/sql/Jisql.java ---------------------------------------------------------------------- diff --git a/jisql/src/main/java/org/apache/util/sql/Jisql.java b/jisql/src/main/java/org/apache/util/sql/Jisql.java index 9746a9a..b3e2725 100644 --- a/jisql/src/main/java/org/apache/util/sql/Jisql.java +++ b/jisql/src/main/java/org/apache/util/sql/Jisql.java @@ -429,6 +429,9 @@ public class Jisql { if (trimmedLine.toUpperCase().startsWith("DECLARE")) { commandTerminator="/"; } + if ((trimmedLine.toUpperCase().startsWith("CREATE OR REPLACE PROCEDURE")) || (trimmedLine.toUpperCase().startsWith("CREATE OR REPLACE FUNCTION"))) { + commandTerminator="/"; + } } if(connectString.toLowerCase().startsWith("jdbc:postgresql") && inputFileName!=null){ if (trimmedLine.toLowerCase().startsWith("select 'delimiter start';")) {
