dble icon indicating copy to clipboard operation
dble copied to clipboard

[Optimization]`'`is used in manager commands that need to be unified

Open FlyingMao opened this issue 4 years ago • 0 comments

  • dble version:
    dble-9.9.9.9-9126b29739825a46313b28dab76555e1fd870996-20200310125806
  • preconditions :
    no
  • configs:

schema.xml



rule.xml



server.xml



  • steps:
    step1. some can't add ' but some must add ' in different manager commends such as:
mysql> show @@datanode where schema=schema1;
+------+------------------+---------------+-------+--------+------+------+---------+---------------+
| NAME | DATHOST          | SCHEMA_EXISTS | INDEX | ACTIVE | IDLE | SIZE | EXECUTE | RECOVERY_TIME |
+------+------------------+---------------+-------+--------+------+------+---------+---------------+
| dn1  | 10.186.60.41/db1 | true          |     0 |      0 |    0 | 1000 |     702 |            -1 |
| dn2  | 10.186.60.42/db1 | true          |     0 |      0 |    4 | 1000 |     844 |            -1 |
| dn3  | 10.186.60.41/db2 | true          |     0 |      0 |    6 | 1000 |     427 |            -1 |
| dn4  | 10.186.60.42/db2 | true          |     0 |      0 |    3 | 1000 |     630 |            -1 |
| dn6  | 10.186.60.41/db4 | false         |     0 |      0 |    0 | 1000 |       4 |            -1 |
| dn8  | 10.186.60.39/db2 | false         |     0 |      0 |    0 | 1000 |       1 |            -1 |
+------+------------------+---------------+-------+--------+------+------+---------+---------------+
6 rows in set (0.01 sec)

mysql> drop database @@datanode='dn1';
Query OK, 1 row affected (0.02 sec)
  • expect result:
    1.
  • real result:
    1.
  • supplements:
    1.

FlyingMao avatar Mar 19 '20 09:03 FlyingMao