[
https://issues.jboss.org/browse/TEIIDDES-2583?page=com.atlassian.jira.plu...
]
Andrej Šmigala commented on TEIIDDES-2583:
------------------------------------------
This fix causes that all models imported through Teiid Connection from JDBC sources to
have table names that contain the schema, i. .
"<schemaname>.<tablename>".
This is the expected behaviour, since it is possible to set the importer properties
(schemaPattern and tableNamePattern) so that multiple tables with the same name are
imported. In previous versions of designer, this would result in an invalid model.
Example:
There are two schemas in the the database, BQT2 and BQT2_RO, both contain a table called
SMALLA.
We are doing a Teiid connection import and setting schemaPattern to %BQT2% and
tableNamePattern to %SMALL%.
In designer before 9.0.3, this would result in a model with two tables called SMALLA (and
a validation error).
In the current version, the tables are called "BQT2.SMALLA" and
"BQT2_RO.SMALLA".
Importing DDL with double-quoted table names removes segments of the
name of the . delimiter is in string
---------------------------------------------------------------------------------------------------------
Key: TEIIDDES-2583
URL:
https://issues.jboss.org/browse/TEIIDDES-2583
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Reporter: Barry LaFond
Assignee: Barry LaFond
Labels: release_notes, verified_jbdsis-8.0.3.CR1
Fix For: 9.0.3, 9.2
CREATE FOREIGN TABLE "products.dbo.ProductData" (......) is a valid DDL
statement and ends up setting the name for the table to *products.dbo.ProductData*
The current logic in TeiidDdlImporter.init() method will change the table name if it
includes the "." delimiter.
For: *products.dbo.ProductData*, the name will be truncated to *ProductData*
This is in error because Designer and Teiid support the . as a valid character in a table
name.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)