Repository: ranger Updated Branches: refs/heads/ranger-1.2 2ac952ba2 -> 60a496599
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/60a49659 Tree: http://git-wip-us.apache.org/repos/asf/ranger/tree/60a49659 Diff: http://git-wip-us.apache.org/repos/asf/ranger/diff/60a49659 Branch: refs/heads/ranger-1.2 Commit: 60a496599c18781fb24fceb7c9833bf270628577 Parents: 2ac952b Author: Abhay Kulkarni <akulka...@hortonworks.com> Authored: Thu Oct 11 10:53:55 2018 -0700 Committer: Abhay Kulkarni <akulka...@hortonworks.com> Committed: Thu Oct 11 11:18:39 2018 -0700 ---------------------------------------------------------------------- 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/60a49659/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';")) {