Default ANSI quotes for MySQL table names

Description

The following query successfully executes in all databases but MySQL:

select * from "AO_69D057_FILTER" where "SHARED" = true AND "CONTAINS_PROJECT" = true AND UPPER("FILTER_NAME") like UPPER('%pr%').

The reason is that MySQL does not support double quotes like " as a default.
The solution is to configure the session with a param:

SET SQL_MODE=ANSI_QUOTES;

Using AO does not support to use such properties, I suggest to use this behaviour as a default for AO since quoting for all other db's would be fine.

Environment

None

Testing Notes

Add notes...

Status

Assignee

Unassigned

Reporter

Carsten Hilber

Labels

None

Add-on Type

None

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Components

Affects versions

1.1.3

Priority

Major
Configure