[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1886) Automatically modify a column name at creating view model from XML schema
[
https://issues.jboss.org/browse/TEIIDDES-1886?page=com.atlassian.jira.plu...
]
hisao furuichi commented on TEIIDDES-1886:
------------------------------------------
Hi.
This is the reproduction step.
1. Create two xsd file.
test1.xsd
====
<?xml version="1.0" encoding="UTF-8"
standalone="no"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema"
xmlns:tns="http://www.example.org/dictionary_b"
elementFormDefault="qualified"
targetNamespace="http://www.example.org/dictionary_b">
<element name="column_a" type="string" />
<element name="column_b" type="string" />
<complexType name="table_a">
<sequence>
<element ref="tns:column_a" />
<element ref="tns:column_b" />
</sequence>
</complexType>
<complexType name="table_b">
<sequence>
<element ref="tns:column_a" />
<element ref="tns:column_b" />
</sequence>
</complexType>
</schema>
====
test2.xsd
====
<?xml version="1.0" encoding="UTF-8"
standalone="no"?>
<schema xmlns="http://www.w3.org/2001/XMLSchema"
xmlns:tns="http://www.example.org/dictionay_a"
elementFormDefault="qualified"
targetNamespace="http://www.example.org/dictionay_a">
<element name="column_a" type="string"/>
<element name="column_b" type="string"/>
<element name="table_a">
<complexType>
<sequence>
<element ref="tns:column_a"/>
<element ref="tns:column_b"/>
</sequence>
</complexType>
</element>
<element name="table_b">
<complexType>
<sequence>
<element ref="tns:column_a"/>
<element ref="tns:column_b"/>
</sequence>
</complexType>
</element>
</schema>
====
2. Import schema files using teiid designer.
Teiid designer project -> Right click -> import -> Teiid designer -> XML
Schemas
3. Create view model from schemas
XSD -> Right click -> Modeling -> Create Relational View Model from Schema
action
Thx
Automatically modify a column name at creating view model from XML
schema
-------------------------------------------------------------------------
Key: TEIIDDES-1886
URL: https://issues.jboss.org/browse/TEIIDDES-1886
Project: Teiid Designer
Issue Type: Bug
Components: Views
Affects Versions: 7.7.2
Environment: Fedora 18
JBoss Developer Studio 5
Reporter: hisao furuichi
Teiid designer modify column names automatically even if it's not necessary. I'll
write 2 examples to describe this issue.
1. In the case of the view model from following schema, even if there are the same column
names on the different table, it is numbered automatically.
(I think that the nameValidator object should be created as new instance every table or
table's columns in GenerateVirtualFromXsdHelper.java.)
<complexType name="table_a">
<sequence>
<element ref="tns:column_a" />
<element ref="tns:column_b" />
</sequence>
</complexType>
<complexType name="table_b">
<sequence>
<element ref="tns:column_a" />
<element ref="tns:column_b" />
</sequence>
</complexType>
2. If there is a parent element to a column like the following schema, the parent element
name is added before column names.
(See GenerateVirtualFromXsdHelper.java line 213 [2].)
<element name="table_a">
<complexType>
<sequence>
<element ref="tns:column_a"/>
<element ref="tns:column_b"/>
</sequence>
</complexType>
</element>
<element name="table_b">
<complexType>
<sequence>
<element ref="tns:column_a"/>
<element ref="tns:column_b"/>
</sequence>
</complexType>
</element>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira