Query rewrite not working

[renecannao]

How to reproduce it:
On admin module:

mysql> insert into mysql_query_rules(rule_id, active, username, schemaname, flagIN, match_pattern, negate_match_pattern,flagOUT ,replace_pattern,destination_hostgroup,cache_ttl,apply)  values(1,1,NULL,NULL,0,"SELECT * FROM proxytest",1,0,"SELECT id FROM test",0,1,1);
Query OK, 1 row affected (0.01 sec)

mysql> LOAD MYSQL QUERY RULES TO RUNTIME;                                                                                                                                                      Query OK, 0 rows affected (0.01 sec)

On mysql module:

mysql> SELECT * FROM proxytest;
ERROR 1109 (42S02): Unknown table 'proxytest' in information_schema

[renecannao]

Here there was a bug: the rewrite was happening, but ignored.
Additionally, there are 2 errors in the rule:

• negate_match_pattern is set to 1 (should be 0)
• asterisk in match_pattern should be escaped.

The correct syntax should be:

mysql> insert into mysql_query_rules(rule_id, active, username, schemaname, flagIN, match_pattern, negate_match_pattern,flagOUT ,replace_pattern,destination_hostgroup,cache_ttl,apply)  values(1,1,NULL,NULL,0,"SELECT \* FROM proxytest",0,0,"SELECT id FROM test",0,1,1);