[Enhancement] show brokers instant of show broker

[dataalive]

Search before asking

• I had searched in the issues and found no similar issues.

Description

why is show broker not show brokers

mysql> show broker;
+----------+------------+-------+-------+---------------------+---------------------+--------+
| Name     | IP         | Port  | Alive | LastStartTime       | LastUpdateTime      | ErrMsg |
+----------+------------+-------+-------+---------------------+---------------------+--------+
| mybroker | 172.21.0.5 | 48000 | true  | 2022-03-28 15:53:49 | 2022-03-28 17:46:26 |        |
+----------+------------+-------+-------+---------------------+---------------------+--------+
1 row in set (0.00 sec)

mysql> show brokers;
ERROR 1105 (HY000): errCode = 2, detailMessage = Syntax error in line 1:
show brokers
     ^
Encountered: IDENTIFIER
Expected

mysql> show proc '/brokers'
    -> ;
+----------+------------+----------+-------+-------+---------------------+---------------------+--------+
| Name     | IP         | HostName | Port  | Alive | LastStartTime       | LastUpdateTime      | ErrMsg |
+----------+------------+----------+-------+-------+---------------------+---------------------+--------+
| mybroker | 172.21.0.5 | dev-bj01 | 48000 | true  | 2022-03-28 15:53:49 | 2022-03-28 17:47:21 |        |
+----------+------------+----------+-------+-------+---------------------+---------------------+--------+
1 row in set (0.13 sec)

other roles show function is show backends; or show frontends;

Solution

support or change command with show brokers

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct