-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/62372/
-----------------------------------------------------------
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
