[jira] [Created] (AMBARI-4391) During Oracle schema upgrade, syntax error in Oracle DML scripts

["Nate Cole (JIRA)" <ji...@apache.org>]

Nate Cole created AMBARI-4391:
---------------------------------

             Summary: During Oracle schema upgrade, syntax error in Oracle DML scripts
                 Key: AMBARI-4391
                 URL: https://issues.apache.org/jira/browse/AMBARI-4391
             Project: Ambari
          Issue Type: Bug
          Components: controller
            Reporter: Nate Cole
            Assignee: Nate Cole
             Fix For: 1.4.4


When executing Ambari-DML-Oracle-FIX_LOCAL_REPO.sql, the following error occurs to every single query with INSTR() function:
{code}
SQL> SQL>   2    3    WHERE INSTR('HDPLocal' in current_stack_version) > 0
                         *
ERROR at line 3:
ORA-00907: missing right parenthesis
{code}


When executing Ambari-DML-Oracle-INSERT_METAINFO.sql
* Need commit;
* Need to single-quote string values
* Need to double-quote metainfo column names, because the create script uses double-quoted column names.




--
This message was sent by Atlassian JIRA
(v6.1.5#6160)