You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Dhaval Shah <dh...@gmail.com> on 2020/07/21 10:05:38 UTC

Review Request 72697: RANGER-2920 : Improvement in DB scripts for handling upgrade scenario for MS-SQL

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72697/
-----------------------------------------------------------

Review request for ranger, Ankita Sinha, Gautam Borad, Jayendra Parab, Mehul Parikh, Pradeep Agrawal, and Velmurugan Periasamy.


Bugs: RANGER-2920
    https://issues.apache.org/jira/browse/RANGER-2920


Repository: ranger


Description
-------

1.) 046-insert-statename-in-x-ranger-global-state.sql
Need to change getXportalUIdByLoginId to dbo.getXportalUIdByLoginId

2.) 047-sortorder-column-size.sql
=> Declare scalar variable stmt


Diffs
-----

  security-admin/db/sqlserver/patches/046-insert-statename-in-x-ranger-global-state.sql 1d37a3b0e 
  security-admin/db/sqlserver/patches/047-sortorder-column-size.sql d812df6f2 


Diff: https://reviews.apache.org/r/72697/diff/1/


Testing
-------

Successfully tested upgrade scenario from ranger-0.7 to master with DB MS-SQL


Thanks,

Dhaval Shah


Re: Review Request 72697: RANGER-2920 : Improvement in DB scripts for handling upgrade scenario for MS-SQL

Posted by Pradeep Agrawal <pr...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72697/#review221281
-----------------------------------------------------------


Ship it!




Ship It!

- Pradeep Agrawal


On July 21, 2020, 10:05 a.m., Dhaval Shah wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72697/
> -----------------------------------------------------------
> 
> (Updated July 21, 2020, 10:05 a.m.)
> 
> 
> Review request for ranger, Ankita Sinha, Gautam Borad, Jayendra Parab, Mehul Parikh, Pradeep Agrawal, and Velmurugan Periasamy.
> 
> 
> Bugs: RANGER-2920
>     https://issues.apache.org/jira/browse/RANGER-2920
> 
> 
> Repository: ranger
> 
> 
> Description
> -------
> 
> 1.) 046-insert-statename-in-x-ranger-global-state.sql
> Need to change getXportalUIdByLoginId to dbo.getXportalUIdByLoginId
> 
> 2.) 047-sortorder-column-size.sql
> => Declare scalar variable stmt
> 
> 
> Diffs
> -----
> 
>   security-admin/db/sqlserver/patches/046-insert-statename-in-x-ranger-global-state.sql 1d37a3b0e 
>   security-admin/db/sqlserver/patches/047-sortorder-column-size.sql d812df6f2 
> 
> 
> Diff: https://reviews.apache.org/r/72697/diff/1/
> 
> 
> Testing
> -------
> 
> Successfully tested upgrade scenario from ranger-0.7 to master with DB MS-SQL
> 
> 
> Thanks,
> 
> Dhaval Shah
> 
>