]
Steven Hawkins resolved TEIID-5369.
-----------------------------------
Fix Version/s: 10.3.2
Resolution: Done
Added an override to omit the on commit clause.
enableDependentJoins for Redshift translator
--------------------------------------------
Key: TEIID-5369
URL:
https://issues.jboss.org/browse/TEIID-5369
Project: Teiid
Issue Type: Enhancement
Components: JDBC Connector
Reporter: Chandra Akkinepalli
Assignee: Steven Hawkins
Fix For: 11.0, 10.3.2
When using Translator overwrite property enableDependentJoins with Redshift translator,
we got the following error.
Caused by: java.sql.SQLException: [Amazon](500310) Invalid operation: CREATE TEMP TABLE
ON COMMIT is not supported; at
com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException(ErrorResponse.java:1830)
... 30 lines omitted ... at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) Caused by:
com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: CREATE
TEMP TABLE ON COMMIT is not supported; ... 32 more