You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Pradeep Agrawal <pr...@gmail.com> on 2023/05/16 14:33:33 UTC
Review Request 74439: RANGER-4241: Fix sql patch 65 syntax issue for oracle db
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74439/
-----------------------------------------------------------
Review request for ranger, bhavik patel, Abhay Kulkarni, Madhan Neethiraj, Nikhil P, Pradeep Agrawal, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
Bugs: RANGER-4241
https://issues.apache.org/jira/browse/RANGER-4241
Repository: ranger
Description
-------
**Problem Statement:** Sql Patch 065 have an incorrect drop index statement which may cause failure of the patch.
**Proposed Solution:** drop index statmenet should be modified so that patch 065 should not fail.
**Incorrect statement:**
DROP INDEX x_rms_svc_res_IDX_res_sgn ON x_rms_service_resource(resource_signature);
**Correct statement: **
DROP INDEX x_rms_svc_res_IDX_res_sgn;
Diffs
-----
security-admin/db/oracle/patches/065-add-uk-on-x_rms_service_resource-resource_signature.sql f91dfef06
Diff: https://reviews.apache.org/r/74439/diff/1/
Testing
-------
Thanks,
Pradeep Agrawal
Re: Review Request 74439: RANGER-4241: Fix sql patch 65 syntax issue for oracle db
Posted by Kishor Gollapalliwar <ki...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74439/#review225461
-----------------------------------------------------------
Ship it!
Ship It!
- Kishor Gollapalliwar
On May 16, 2023, 2:33 p.m., Pradeep Agrawal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/74439/
> -----------------------------------------------------------
>
> (Updated May 16, 2023, 2:33 p.m.)
>
>
> Review request for ranger, bhavik patel, Abhay Kulkarni, Madhan Neethiraj, Nikhil P, Pradeep Agrawal, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-4241
> https://issues.apache.org/jira/browse/RANGER-4241
>
>
> Repository: ranger
>
>
> Description
> -------
>
> **Problem Statement:** Sql Patch 065 have an incorrect drop index statement which may cause failure of the patch.
> **Proposed Solution:** drop index statmenet should be modified so that patch 065 should not fail.
>
> **Incorrect statement:**
> DROP INDEX x_rms_svc_res_IDX_res_sgn ON x_rms_service_resource(resource_signature);
>
> **Correct statement: **
> DROP INDEX x_rms_svc_res_IDX_res_sgn;
>
>
> Diffs
> -----
>
> security-admin/db/oracle/patches/065-add-uk-on-x_rms_service_resource-resource_signature.sql f91dfef06
>
>
> Diff: https://reviews.apache.org/r/74439/diff/1/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Pradeep Agrawal
>
>