matrixorigin
[Bug]: All show statements should add the limits of account, user, role, otherwise the output table may not be correct.
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Environment
- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:
Actual Behavior
return system table
Expected Behavior
No response
Steps to Reproduce
No response
Additional information
No response
@nnsgmsone @domingozhang @daviszhen pls record a result and update the status of this issue, thank you.
It only has already known problems introduced by pr #5824 @nnsgmsone the database system of general account has the extra views or tables from sys account:
- rawlog
- log_info
- error_info
- span_info
- statement_info
the database system_metrics of general account has the extra views or tables from sys account :
- views started by process_, sys_
add account limit for
-
show databases -
show table -
show table status -
show index -
show columns
confirm,closed
commit id:f78df23895c59bbe3f662ecbf5f5ae9d590bac03
sys and non sys account show commad results:
show databases
show tables
show table status
show index
show columns
