xinyiZzz commented on PR #32866:
URL: https://github.com/apache/doris/pull/32866#issuecomment-2023031057
good job!
after that, show procedure need to support filter, record in TODO list:
1. `SELECT * FROM information_schema.ROUTINES` support filter and order by,
such as:
```
SELECT * FROM information_schema.ROUTINES WHERE
ROUTINE_SCHEMA='__internal_schema' AND ROUTINE_TYPE IN ('PROCEDURE','FUNCTION')
ORDER BY ROUTINE_NAME
```
2. `SHOW PROCEDURE STATUS` support filter and support filter based on `db
name`, such as:
```
SHOW PROCEDURE STATUS WHERE Db = '__internal_schema' AND Name LIKE 'pro5';
```
currently procedure only save the `db id` in metadata, so we need to use db
name to find the db id and then filter it.
--
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]
