[AMBARI-4391] During Oracle db upgrade, syntax error in Oracle DML scripts

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.4
• Component/s: ambari-server
• Assignee: Nate Cole
• Reporter: Nate Cole
• Created: 23/Jan/14 11:52
• Updated: 23/Jan/14 15:25
• Resolved: 23/Jan/14 15:25

Description

When executing Ambari-DML-Oracle-FIX_LOCAL_REPO.sql, the following error occurs to every single query with INSTR() function:

SQL> SQL>   2    3    WHERE INSTR('HDPLocal' in current_stack_version) > 0
                         *
ERROR at line 3:
ORA-00907: missing right parenthesis

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.

Issue Links

• links to: ReviewBoard