ThanoshanMV opened a new pull request #16253:
URL: https://github.com/apache/shardingsphere/pull/16253


   For #6478 
   
   Changes proposed in this pull request:
   - Proofread SQLServer [CREATE 
ROLE](https://docs.microsoft.com/en-us/sql/t-sql/statements/create-role-transact-sql?view=sql-server-ver15),
 [ALTER 
ROLE](https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-role-transact-sql?view=sql-server-ver15),
 and[ DROP 
ROLE](https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-role-transact-sql?view=sql-server-ver15)
 statements.
   - I didn't add new test cases as all the possible test cases are available 
already. Earlier those SQLs were not parsed correctly and after proofreading 
they are parsed properly.
   For example:
   1. a. `CREATE ROLE` before:
   
![create-role-before](https://user-images.githubusercontent.com/48581379/159397213-fbc3d46d-f056-4f14-98a3-6e464f879ec9.png)
      b. `CREATE ROLE` after:
   
![create-role-after](https://user-images.githubusercontent.com/48581379/159397319-209f0abc-7b0a-4f88-a832-4d9bb45f21d7.png)
   
   2. a. `ALTER ROLE` before:
   
![alter-role-before](https://user-images.githubusercontent.com/48581379/159397410-ea00f134-5bdf-42d8-a7e0-e3421117d6dd.png)
      b. `ALTER ROLE` after:
   
![alter-role-after](https://user-images.githubusercontent.com/48581379/159397443-83873107-9ad7-4bd8-92dc-ee8d1ea82a9f.png)
   
   3. a. `DROP ROLE` before:
   
![drop-role-before](https://user-images.githubusercontent.com/48581379/159397515-0d93477c-ae35-4945-a815-778b6cc256bf.png)
      b. `DROP ROLE` after:
   
![drop-role-after](https://user-images.githubusercontent.com/48581379/159397540-8b6b2f18-3d4c-46fc-b6a9-71ff39a8d8dc.png)
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to