-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/46959/
-----------------------------------------------------------
(Updated May 3, 2016, 8:57 p.m.)
Review request for Ambari, Ajit Kumar and Sumit Mohanty.
Changes
-------
Fix Derby DB as well.
Bugs: AMBARI-16240
https://issues.apache.org/jira/browse/AMBARI-16240
Repository: ambari
Description
-------
AMBARI-16240: Ambari operation history: Syntax error in
Ambari-DDL-Postgres-CREATE.sql causes ambari-server setup to fail in 2.4.0.0-489
** Issue **:
Presence of highlighted semi-colon below causes setup of Ambari 2.4.0.0-489 to
fail in PostgresDB.
./ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
1087 select 'servicecomponent_history_id_seq', 0
1088 union all
1089 select 'blueprint_setting_id_seq', 0**;**
{color}
1090 union all
1091 select 'ambari_operation_history_id_seq', 0;
Diffs (updated)
-----
ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
c9026378b4167ab9c857151e1e5d529ca6cadc45
ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
85cc0be5520327800de9f0e4fa84daf78b53b7af
Diff: https://reviews.apache.org/r/46959/diff/
Testing
-------
** Manual Testing **
Ran the Ambari-DDL-Postgres-CREATE.sql file on an emtpy *ambari* database on
Postgres SQL server and verified that no exceptions were thrown.
Thanks,
Nahappan Somasundaram
