Repository: ranger Updated Branches: refs/heads/ranger-0.7 7deed8eb5 -> 1686d4718
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/1686d471 Tree: http://git-wip-us.apache.org/repos/asf/ranger/tree/1686d471 Diff: http://git-wip-us.apache.org/repos/asf/ranger/diff/1686d471 Branch: refs/heads/ranger-0.7 Commit: 1686d4718727a762b733d703dd044075e6676edf Parents: 7deed8e 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 10:53:55 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/1686d471/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 53a6ca4..7c63aff 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';")) {