[MXS-2579] adding schema to qla filter Created: 2019-06-26  Updated: 2019-12-12  Resolved: 2019-12-12

Status: Closed
Project: MariaDB MaxScale
Component/s: qlafilter
Affects Version/s: 2.3.5
Fix Version/s: 2.5.0

Type: New Feature Priority: Major
Reporter: Kadir Assignee: Niclas Antti
Resolution: Fixed Votes: 0
Labels: None

Epic Link: Filter Improvements
Sprint: MXS-SPRINT-96

 Description   

The query metadata captured by qlafilter does not contain the schema on which the query is done. Having this information is useful when multiple applications share a DB but are logically separated by the schema.

A solution might be to take the schema information from the connection. The only drawback here is queries where we explicitly define another schema. Example:

mysql -h host -u user -p salary
> [...] # any query gets automatically the `salary` schema
 
# edge case:
> select user from mysql.user;

I would be ok with the edge case not being covered.


Generated at Thu Feb 08 04:15:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.