[JBoss JIRA] (TEIIDDES-2583) Importing DDL with double-quoted table names removes segments of the name of the . delimiter is in string
by Andrej Šmigala (JIRA)
[ 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)
10 years, 9 months