----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/62372/ -----------------------------------------------------------
(Updated Sept. 19, 2017, 1:59 p.m.) Review request for ranger, Alok Lal, Ankita Sinha, Don Bosco Durai, Colm O hEigeartaigh, Gautam Borad, Madhan Neethiraj, Ramesh Mani, Selvamohan Neethiraj, Velmurugan Periasamy, and Qiang Zhang. Bugs: RANGER-1788 https://issues.apache.org/jira/browse/RANGER-1788 Repository: ranger Description ------- 1. Fetch latest source using "git clone https://git-wip-us.apache.org/repos/asf/ranger.git" command. 2. Build. 3. Install Ranger admin. Error information is as following: 2017-09-16 23:39:54,695 [E] 028-add-unique-constraint-on-table-x_group.sql import failed! Execute 028-add-unique-constraint-on-table-x_group.sql file separately, there are following: 1. error code:1314 ALTER VIEW is not allowed in stored procedures 2. error code:1305 PROCEDURE ranger.create_unique_constraint_on_groupname does not exist This issue was introduced by the RANGER-1765. mysql> source /diskc/installranger/run/ranger-1.0.0-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql Query OK, 0 rows affected, 1 warning (0.00 sec) ERROR 1314 (0A000): ALTER VIEW is not allowed in stored procedures ERROR 1305 (42000): PROCEDURE ranger.create_unique_constraint_on_groupname does not exist Query OK, 0 rows affected, 1 warning (0.00 sec) Reason: As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error. Diffs ----- security-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql 2c5be737 Diff: https://reviews.apache.org/r/62372/diff/1/ Testing ------- Thanks, pengjianhua