[MXS-1194] Check what 10.2 language extensions are not supported by which filters Created: 2017-03-21  Updated: 2017-04-21  Resolved: 2017-04-21

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: None
Fix Version/s: 2.1.3

Type: Task Priority: Major
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-31, 2017-32

 Description   

We need to document any issues with introduced functionality in 10.2 and MaxScale. E.g. how are windoing functions handled by various filters.

  • Window functions
  • CTE (common table expression)
  • JSON functions

 Comments   
Comment by Johan Wikman [ 2017-04-21 ]

In general, the new functionality of 10.2 is an issue for the parser, which will not be able to parse e.g. selects using window functions properly.

However, in general, but for the database firewall, neither filters nor routers are affected.

The database firewall is affected in two ways:

  • As the database firewall blocks all statements that can not be parsed completely, e.g. all selects using window functions will be blocked.
  • The parser parses WITH statements correctly, but fails to report variables and functions referred to in the SELECT of the WITH clause. Consequently, it will not block a WITH statement where the WITH clause refers to forbidden columns.
Generated at Thu Feb 08 04:04:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.