heguanhui opened a new pull request, #63635:
URL: https://github.com/apache/doris/pull/63635
### What problem does this PR solve?
Issue Number: close #xxx
Problem Summary: SHOW CATALOG RECYCLE BIN only supports Name filter with =
and LIKE, but does not support filtering by Type, DbId or TableId. When there
are many entries in the recycle bin, users cannot quickly locate entries by
database, type or table level (e.g. find all dropped partitions of a specific
table).
### Release note
Support Type, DbId and TableId filter conditions in SHOW CATALOG RECYCLE BIN
WHERE clause, and support AND compound predicate. For example: `SHOW CATALOG
RECYCLE BIN WHERE Type = "Partition" AND TableId = "12345"`
### Check List (For Author)
- Test
- [x] Regression test
- [x] Unit Test
- [ ] Manual test
- [ ] No need to test
- Behavior changed:
- [ ] No.
- [x] Yes. SHOW CATALOG RECYCLE BIN now supports additional WHERE
conditions (Type, DbId, TableId) and AND compound predicate
- Does this need documentation?
- [ ] No.
- [x] Yes.
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label
--
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]
