qian0817 opened a new issue, #30074: URL: https://github.com/apache/doris/issues/30074
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris-2.0.4-rc02-e529646 ### What's Wrong? When I use the switch method to use Doris's Hive catalog, encountering a non-existent function can prompt an error correctly. ```shell > mysql -uroot -h xxx -P9030 -uxxx -p123456 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 672 Server version: 5.7.99 Doris version doris-2.0.4-rc02-e529646 Copyright (c) 2000, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> switch hive; Query OK, 0 rows affected (0.00 sec) mysql> SELECT unkown_fn(1); ERROR 1105 (HY000): errCode = 2, detailMessage = No matching function with signature: unkown_fn(tinyint(4)). mysql> exit; Bye ``` When I connect to the hive catalog of Doris by directly specifying the database, encountering non-existent functions will prompt an error indicating lack of permission. ```shell > mysql -uroot -h xxx -P9030 -uxxx -p123456 -Dhive.default mysql: [Warning] Using a password on the command line interface can be insecure. Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 677 Server version: 5.7.99 Doris version doris-2.0.4-rc02-e529646 Copyright (c) 2000, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT unkown_fn(1); ERROR 1227 (42000): errCode = 2, detailMessage = Access denied; you need (at least one of) the SELECT privilege(s) for this operation mysql> ``` ### What You Expected? The correct error message should be returned. ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
