Repository: ranger Updated Branches: refs/heads/ranger-1.0 012cf9936 -> 3d4513ec0
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/3d4513ec Tree: http://git-wip-us.apache.org/repos/asf/ranger/tree/3d4513ec Diff: http://git-wip-us.apache.org/repos/asf/ranger/diff/3d4513ec Branch: refs/heads/ranger-1.0 Commit: 3d4513ec0bd7044681f8172259ea23c1f7c3edb9 Parents: 012cf99 Author: Abhay Kulkarni <[email protected]> Authored: Thu Oct 11 10:53:55 2018 -0700 Committer: Abhay Kulkarni <[email protected]> Committed: Thu Oct 11 11:16:20 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/3d4513ec/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';")) {
