yujun777 opened a new pull request, #66659:
URL: https://github.com/apache/doris/pull/66659
### What problem does this PR solve?
Problem Summary: PL/SQL stored procedures were removed in #58700 because the
implementation had many bugs. That removal also deleted the `SHOW
(PROCEDURE|FUNCTION) STATUS` grammar, the `ShowProcedureStatusCommand`, and the
`information_schema.routines` scanner. Clients such as Bytebase send `SHOW
FUNCTION STATUS WHERE Db = '...'` during connection/metadata probing, and the
unsupported syntax now blocks users from using the database.
This PR only restores the SQL entry points so these statements parse and
always return empty result sets without errors. The stored procedure
functionality itself is NOT restored.
Related PR: #58700
### Release note
None
### Check List (For Author)
- Test:
- Regression test:
regression-test/suites/show_p0/test_show_procedure_function_status.groovy
- Manual test: verified SHOW PROCEDURE/FUNCTION STATUS (with/without
WHERE and LIKE) and information_schema.routines on a local cluster
- Behavior changed: Yes. `SHOW (PROCEDURE|FUNCTION) STATUS` and
`information_schema.routines` now parse and return an empty result set instead
of failing with a syntax error.
- Does this need documentation: No
--
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]
