]
Steven Hawkins updated TEIID-4900:
----------------------------------
Fix Version/s: 12.x
(was: 11.x)
Implement limit to / exclude import options
-------------------------------------------
Key: TEIID-4900
URL:
https://issues.jboss.org/browse/TEIID-4900
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors, Query Engine
Affects Versions: 9.2
Reporter: Steven Hawkins
Priority: Major
Fix For: 12.x
TEIID-4899 removed support for LIMIT TO / EXCLUDE since the semantics of LIMIT TO /
EXCLUDE does not match the regex base support in several of the translators. Also JDBC
does not support a specific include, only exclude.
There are two options:
These need to be handled at the engine level as general options instead - and leave the
import settings to be importer specific. However that requires generic logic for
repairing the metadata should a foreign key or other references be made to an excluded
table.
If they are mapped to translator options then we'll need to translate the table names
in the an appropriate regex expression.