[MXS-75] "wildcard" rule also blocks COUNT(*) Created: 2015-03-31 Updated: 2015-06-17 Resolved: 2015-05-03 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | dbfwfilter |
| Affects Version/s: | 1.1.0 |
| Fix Version/s: | 1.1.1 |
| Type: | Bug | Priority: | Major |
| Reporter: | Kolbe Kegel (Inactive) | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
The "wildcard" rule in FWfilter might be useful to prevent users from doing "SELECT *", but it should still be possible to do SELECT COUNT( * ), which has a very different use and very different semantics. Unfortunately, the "wildcard" rule blocks COUNT( * ). This should be changed in a future release, as there really isn't any good reason to block COUNT( * ). |
| Comments |
| Comment by markus makela [ 2015-05-03 ] |
|
Removed COUNT( * ) from wildcard rule matching. |
| Comment by Timofey Turenko [ 2015-05-04 ] |
|
SELECT COUNT( * ) added to fwf test (to rule1 test) |
| Comment by Timofey Turenko [ 2015-05-12 ] |
|
verified by adding SELECT COUNT( * ) to fwf test (see https://github.com/mariadb-corporation/maxscale-system-test/blob/master/fwf.cpp and rule file https://github.com/mariadb-corporation/maxscale-system-test/blob/master/fw/pass1) |