----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/62372/#review185536 -----------------------------------------------------------
Ship it! Ship It! - Qiang Zhang On 九月 18, 2017, 3:37 a.m., pengjianhua wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/62372/ > ----------------------------------------------------------- > > (Updated 九月 18, 2017, 3:37 a.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 > >
