]
Matus Makovy commented on TEIIDDES-3026:
----------------------------------------
Changed to blocker, since I don't see a workaround.
Name in source not included when doing preview
----------------------------------------------
Key: TEIIDDES-3026
URL:
https://issues.jboss.org/browse/TEIIDDES-3026
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 11.0.1
Reporter: Matus Makovy
Priority: Blocker
Attachments: project.zip
Prieview VDB doesn't include name in source for column. When you try to do a preview
for SHIP_VIA table from partsSourceSQLServer model that is in attached project, the
generated dynamic VDB looks like this:
{code:xml}
<?xml version="1.0" encoding="UTF-8"
standalone="yes"?>
<vdb name="PREVIEW-21b09376-8753-42ac-a874-34d47820fc30"
version="1">
<description>Importer VDB</description>
<property name="UseConnectorMetadata" value="true" />
<property name="deployment-name"
value="PREVIEW-21b09376-8753-42ac-a874-34d47820fc30-vdb.xml" />
<model name="partsSourceSQLServer" type="PHYSICAL"
visible="true">
<source name="partsSourceSQLServer" translator-name="sqlserver"
connection-jndi-name="java:/partsSourceSQLServer" />
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE SHIP_VIA (
SHIPPER_ID bigdecimal NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'),
SHIPPER_NAME string(30),
AVERAGE_TIME_DELIVERY bigdecimal OPTIONS(FIXED_LENGTH 'TRUE'),
CONSTRAINT PK_SHIP_VIA PRIMARY KEY(SHIPPER_ID)
) OPTIONS(UPDATABLE 'TRUE');
]]></metadata>
</model>
</vdb>
{code}
It is missing name in source for AVERAGE_TIME_DELIVERY (which is "AVERAGE TIME
DELIVERY" at it is defined in the XMI model). Preview cannot be done.