odata-v4-sql
odata-v4-sql copied to clipboard
mysql is incorrectly configured to handle ANSI SQL square brackets
running a query like http://serviceUrl?$filter=column%20eq%20value
and using createFilter with type 2 (SQLLang.MySql) results in the filter [column] = ?
This is valid for MSSQL but not MySql forcing me to use a global regex replace from square brackets to backticks in order for the query to succeed.