Vallishp opened a new pull request, #43231:
URL: https://github.com/apache/doris/pull/43231
### What problem does this PR solve?
<!--
You need to clearly describe your PR in this part:
1. What problem was fixed (it's best to include specific error reporting
information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it
now, why was it modified, and what possible impacts might there be.
3. What features were added. Why this function was added.
4. Which codes were refactored and why this part of the code was refactored.
5. Which functions were optimized and what is the difference before and
after the optimization.
The description of the PR needs to enable reviewers to quickly and clearly
understand the logic of the code modification.
-->
support drop role command in nereids
<!--
If there are related issues, please fill in the issue number.
- If you want the issue to be closed after the PR is merged, please use
"close #12345". Otherwise, use "ref #12345"
-->
Issue Number: close #42618
<!--
If this PR is followup a preivous PR, for example, fix the bug that
introduced by a related PR,
link the PR here
-->
Related PR: #
Problem Summary:
### Check List (For Committer)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No colde files have been changed.
- [ ] Other reason <!-- Add your reason? -->
test_grant_priv.groovy already cover it.
2024-11-04 15:47:00.905 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: drop role if exists test_grant_priv_role1
2024-11-04 15:47:00.908 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: DROP DATABASE IF EXISTS test_grant_priv_db
2024-11-04 15:47:00.913 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: CREATE DATABASE test_grant_priv_db
2024-11-04 15:47:00.921 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: CREATE ROLE test_grant_priv_role1
2024-11-04 15:47:00.928 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: CREATE USER 'test_grant_priv_user1' IDENTIFIED BY '123456'
2024-11-04 15:47:00.938 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: CREATE USER 'test_grant_priv_user2' IDENTIFIED BY '123456'
2024-11-04 15:47:00.946 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant select_priv on test_grant_priv_db.* to test_grant_priv_user1
2024-11-04 15:47:00.969 INFO [suite-thread-1] (SuiteContext.groovy:299) -
Create new connection for user 'test_grant_priv_user1' to
'jdbc:mysql://127.0.0.1:9030/test_grant_priv_db?'
2024-11-04 15:47:01.016 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant select_priv on test_grant_priv_db.* to test_grant_priv_user2
2024-11-04 15:47:01.034 INFO [suite-thread-1] (test_grant_priv.groovy:46) -
errCode = 2, detailMessage = Access denied; you need all [Grant_priv,
Select_priv] privilege(s) for this operation
2024-11-04 15:47:01.034 INFO [suite-thread-1] (SuiteContext.groovy:309) -
Recover original connection to 'jdbc:mysql://127.0.0.1:9030/test_grant_priv_db?'
2024-11-04 15:47:01.035 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant grant_priv on test_grant_priv_db.* to test_grant_priv_user1
2024-11-04 15:47:01.042 INFO [suite-thread-1] (SuiteContext.groovy:299) -
Create new connection for user 'test_grant_priv_user1' to
'jdbc:mysql://127.0.0.1:9030/test_grant_priv_db?'
2024-11-04 15:47:01.079 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant select_priv on test_grant_priv_db.* to test_grant_priv_user2
2024-11-04 15:47:01.090 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant load_priv on test_grant_priv_db.* to test_grant_priv_user2
2024-11-04 15:47:01.099 INFO [suite-thread-1] (test_grant_priv.groovy:63) -
errCode = 2, detailMessage = Access denied; you need all [Grant_priv,
Load_priv] privilege(s) for this operation
2024-11-04 15:47:01.100 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant 'test_grant_priv_role1' to test_grant_priv_user2
2024-11-04 15:47:01.116 INFO [suite-thread-1] (test_grant_priv.groovy:70) -
errCode = 2, detailMessage = Access denied; you need (at least one of) the
(GRANT/REVOKE) privilege(s) for this operation
2024-11-04 15:47:01.116 INFO [suite-thread-1] (SuiteContext.groovy:309) -
Recover original connection to 'jdbc:mysql://127.0.0.1:9030/test_grant_priv_db?'
2024-11-04 15:47:01.117 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant grant_priv on *.* to test_grant_priv_user1
2024-11-04 15:47:01.127 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: grant 'test_grant_priv_role1' to test_grant_priv_user2
2024-11-04 15:47:01.139 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: drop user if exists test_grant_priv_user1
2024-11-04 15:47:01.149 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: drop user if exists test_grant_priv_user2
2024-11-04 15:47:01.165 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: drop role if exists test_grant_priv_role1
2024-11-04 15:47:01.172 INFO [suite-thread-1] (Suite.groovy:384) - Execute
sql: DROP DATABASE IF EXISTS test_grant_priv_db
2024-11-04 15:47:01.184 INFO [suite-thread-1] (ScriptContext.groovy:120) -
Run test_grant_priv in
/root/doris/workspace/doris/regression-test/suites/account_p0/test_grant_priv.groovy
succeed
2024-11-04 15:47:09.541 INFO [main] (RegressionTest.groovy:281) - Start to
run single scripts
2024-11-04 15:48:21.903 INFO [main] (RegressionTest.groovy:410) - Success
suites:
/root/doris/workspace/doris/regression-test/suites/account_p0/test_grant_priv.groovy:
group=default,p0, name=test_grant_priv
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
- Release note
<!-- bugfix, feat, behavior changed need a release note -->
<!-- Add one line release note for this PR. -->
None
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should
merge into -->
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
