odata-v4-sql icon indicating copy to clipboard operation
odata-v4-sql copied to clipboard

mysql is incorrectly configured to handle ANSI SQL square brackets

Open mark-butterworth-lookinglocal opened this issue 1 year ago • 0 comments

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.