E-VS-EXA-5

Message

Attention! Using literals and constant expressions with datatype `TIMESTAMP WITH LOCAL TIME ZONE` in Virtual Schemas can produce incorrect results.

Mitigation

We recommend using 'TIMESTAMP' instead. If you are willing to take the risk and want to use `TIMESTAMP WITH LOCAL TIME ZONE` anyway, please, create a Virtual Schema with the following additional property IGNORE_ERRORS = {{switchParameter}}. We also recommend to set Exasol system `time_zone` to UTC while working with `TIMESTAMP WITH LOCAL TIME ZONE`.

Source

src/main/java/com/exasol/adapter/dialects/exasol/ExasolSqlGenerationVisitor.java:37