tidb 查询问题

开启tidb GENERAL_LOG 看arguments也是对的


下面是query rule

+---------+--------+----------+--------------------+--------+-------------+------------+------------+--------+--------------+----------------------------------------------------------------------------------------------------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+------------------------------------------------------------+--------+-------------+-----------+---------------------+-----+-------+------------+---------+
| rule_id | active | username | schemaname         | flagIN | client_addr | proxy_addr | proxy_port | digest | match_digest | match_pattern                                                                                            | negate_match_pattern | re_modifiers | flagOUT | replace_pattern | destination_hostgroup | cache_ttl | cache_empty_result | cache_timeout | reconnect | timeout | retries | delay | next_query_flagIN | mirror_flagOUT | mirror_hostgroup | error_msg                                                  | OK_msg | sticky_conn | multiplex | gtid_from_hostgroup | log | apply | attributes | comment |
+---------+--------+----------+--------------------+--------+-------------+------------+------------+--------+--------------+----------------------------------------------------------------------------------------------------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+------------------------------------------------------------+--------+-------------+-----------+---------------------+-----+-------+------------+---------+
| 1       | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*CREATE\s+USER                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to create user, please contact the db admin.     | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 2       | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*INSERT\s+INTO\s+user                                                              | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to create user, please contact the db admin.     | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 3       | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*INSERT\s+INTO\s+mysql\s*\.\s*user                                                 | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to create user, please contact the db admin.     | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 4       | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DROP\s+USER                                                                       | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to drop user, please contact the db admin.       | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 5       | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DELETE\s+FROM\s+user                                                              | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to drop user, please contact the db admin.       | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 6       | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DELETE\s+FROM\s+mysql\s*\.\s*user                                                 | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to drop user, please contact the db admin.       | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 7       | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*SET\s+PASSWORD                                                                    | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to update user, please contact the db admin.     | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 8       | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*UPDATE\s+user                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to update user, please contact the db admin.     | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 9       | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*UPDATE\s+mysql\s*\.\s*user                                                        | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to update user, please contact the db admin.     | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 12      | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         
| 13      | 1      | NULL     | INFORMATION_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*CREATE\s+TABLE                                                                    | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 14      | 1      | NULL     | METRICS_SCHEMA     | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*CREATE\s+TABLE                                                                    | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 15      | 1      | NULL     | PERFORMANCE_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*CREATE\s+TABLE                                                                    | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 16      | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*CREATE\s+TABLE                                                                    | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 17      | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DROP\s+DATABASE\s+(INFORMATION_SCHEMA|METRICS_SCHEMA|PERFORMANCE_SCHEMA|mysql)    | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 18      | 1      | NULL     | INFORMATION_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DROP\s+TABLE                                                                      | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 19      | 1      | NULL     | METRICS_SCHEMA     | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DROP\s+TABLE                                                                      | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 20      | 1      | NULL     | PERFORMANCE_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DROP\s+TABLE                                                                      | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 21      | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DROP\s+TABLE                                                                      | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 22      | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*INSERT\s+INTO\s+(INFORMATION_SCHEMA|METRICS_SCHEMA|PERFORMANCE_SCHEMA|mysql)\s*\. | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 23      | 1      | NULL     | INFORMATION_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*INSERT\s+INTO                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 24      | 1      | NULL     | METRICS_SCHEMA     | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*INSERT\s+INTO                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 25      | 1      | NULL     | PERFORMANCE_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*INSERT\s+INTO                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 26      | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*INSERT\s+INTO                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 27      | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*UPDATE\s+(INFORMATION_SCHEMA|METRICS_SCHEMA|PERFORMANCE_SCHEMA|mysql)\s*\.        | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 28      | 1      | NULL     | INFORMATION_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*UPDATE                                                                            | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 29      | 1      | NULL     | METRICS_SCHEMA     | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*UPDATE                                                                            | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 30      | 1      | NULL     | PERFORMANCE_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*UPDATE                                                                            | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 31      | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*UPDATE                                                                            | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 32      | 1      | NULL     | NULL               | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DELETE\s+FROM\s+(INFORMATION_SCHEMA|METRICS_SCHEMA|PERFORMANCE_SCHEMA|mysql)\s*\. | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 33      | 1      | NULL     | INFORMATION_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DELETE\s+FROM                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 34      | 1      | NULL     | METRICS_SCHEMA     | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DELETE\s+FROM                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 35      | 1      | NULL     | PERFORMANCE_SCHEMA | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DELETE\s+FROM                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
| 36      | 1      | NULL     | mysql              | 0      | NULL        | NULL       | NULL       | NULL   | NULL         | ^\s*(\/\*(.*?)\*\/)?\s*DELETE\s+FROM                                                                     | 0                    | CASELESS     | NULL    | NULL            | NULL                  | NULL      | NULL               | NULL          | NULL      | NULL    | NULL    | NULL  | NULL              | NULL           | NULL             | not allow to change system db, please contact the db admin | NULL   | NULL        | NULL      | NULL                | NULL | 1     |            | NULL    |
+---------+--------+----------+--------------------+--------+-------------+------------+------------+--------+--------------+----------------------------------------------------------------------------------------------------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+------------------------------------------------------------+--------+-------------+-----------+---------------------+-----+-------+------------+---------+