-
Notifications
You must be signed in to change notification settings - Fork 320
Closed
Description
Raised by: @zhunina
- If where condition is with single quote
mysql> show @@datanode where schema='tpcc';
Empty set (0.00 sec)
mysql> show @@datanode where schema=tpcc;
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| NAME | DATHOST | INDEX | ACTIVE | IDLE | SIZE | EXECUTE | TOTAL_TIME | MAX_TIME | MAX_SQL | RECOVERY_TIME |
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| dn1 | 10.186.21.73/db1 | 0 | 0 | 3 | 400 | 42935 | 0 | 0 | 0 | -1 |
| dn2 | 10.186.21.75/db1 | 0 | 0 | 0 | 100 | 246 | 0 | 0 | 0 | -1 |
| dn3 | 10.186.21.73/db2 | 0 | 0 | 1 | 400 | 246 | 0 | 0 | 0 | -1 |
| dn4 | 10.186.21.75/db2 | 0 | 0 | 3 | 100 | 42822 | 0 | 0 | 0 | -1 |
+------+------------------+-------+--------+------+------+---------+------------+----------+---------+---------------+
4 rows in set (0.00 sec)
- If equality should with space wrapped or without
- If space could be replaced by tab or line separator