Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
Description
MaxScale is configured with database firewall filter and readwrite split service. Configuration files are attached
Parsing for following query fails when invoked from dbfwfilter
MySQL [tpcc]> select * from orders having count(*) > 10 group by o_carrier_id limit 10; |
ERROR 1141 (HY000): Access denied for user 'appuser'@'172.19.0.1' to database 'tpcc': dbfwfilter: |
Query could not be parsed completely and will hence be rejected.
|
Parsing of following query does not fail.
MySQL [tpcc]> select * from orders where o_id > 1000 limit 10; |
+------+--------+--------+--------+--------------+----------+-------------+---------------------+
|
| o_id | o_w_id | o_d_id | o_c_id | o_carrier_id | o_ol_cnt | o_all_local | o_entry_d |
|
+------+--------+--------+--------+--------------+----------+-------------+---------------------+
|
| 1001 | 1 | 1 | 2350 | 9 | 8 | 1 | 2016-10-06 02:31:53 | |
| 1002 | 1 | 1 | 2977 | 4 | 5 | 1 | 2016-10-06 02:31:53 | |
| 1003 | 1 | 1 | 1863 | 7 | 8 | 1 | 2016-10-06 02:31:53 | |
| 1004 | 1 | 1 | 2684 | 6 | 6 | 1 | 2016-10-06 02:31:53 | |
| 1005 | 1 | 1 | 2378 | 10 | 5 | 1 | 2016-10-06 02:31:53 | |
| 1006 | 1 | 1 | 2689 | 5 | 14 | 1 | 2016-10-06 02:31:53 | |
| 1007 | 1 | 1 | 2116 | 6 | 9 | 1 | 2016-10-06 02:31:53 | |
| 1008 | 1 | 1 | 1521 | 1 | 8 | 1 | 2016-10-06 02:31:53 | |
| 1009 | 1 | 1 | 1249 | 10 | 15 | 1 | 2016-10-06 02:31:53 | |
| 1010 | 1 | 1 | 2502 | 2 | 12 | 1 | 2016-10-06 02:31:53 | |
+------+--------+--------+--------+--------------+----------+-------------+---------------------+
|
10 rows in set (0.01 sec) |