Literal date comparisons with databasetimezone set are incorrect
----------------------------------------------------------------
Key: TEIID-3586
URL:
https://issues.jboss.org/browse/TEIID-3586
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 8.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 8.7.1.6_2, 8.12, 8.11.2
If the database timezone property is set and a literal comparison is used, then the date
value will be shifted from the local timezone into the database timezone, but it should be
the other way around.