[teiid-issues] [JBoss JIRA] (TEIID-5027) Translator infinispan-hotrod incorrect data type import

[Jan Stastny (JIRA)]

Jan Stastny created TEIID-5027:
----------------------------------

             Summary: Translator infinispan-hotrod incorrect data type import
                 Key: TEIID-5027
                 URL: https://issues.jboss.org/browse/TEIID-5027
             Project: Teiid
          Issue Type: Bug
          Components: JDG Connector, Misc. Connectors
    Affects Versions: 8.12.x-6.4
            Reporter: Jan Stastny
            Assignee: Steven Hawkins
            Priority: Blocker


I have a vdb:
{code:xml|title=jdg71_crud-vdb.xml}
<vdb name="jdg71_crud" version="1">
    <model name="Source" type="PHYSICAL" visible="true">
        <source name="jdg7-source" translator-name="infinispan-hotrod" connection-jndi-name="java:/jdg71HotrodDS" />
        <metadata type="DDL"><![CDATA[
             CREATE VIEW SmallA (
               IntKey integer,
               IntNum integer,
               DoubleNum double,
               ObjectValue object,
               BigDecimalValue bigdecimal,
               BigIntegerValue biginteger,
               CharValue char,
               StringNum string,
               StringKey string PRIMARY KEY,
               FloatNum float,
               LongNum long,
               TimeValue time,
               ShortValue short,
               ByteNum byte,
               TimeStampValue timestamp,
               BooleanValue boolean,
               DateValue date) OPTIONS(UPDATABLE true, "teiid_ispn:cache" '${jdg.cache.name}');
            ]]>
        </metadata>
        <metadata type = "NATIVE"/>
    </model>
</vdb>
{code}

But the resulting metadata are:
|| column_name | column_type ||
|| IntKey | integer ||
|| IntNum | integer ||
|| DoubleNum | double ||
|| ObjectValue | string ||
|| BigDecimalValue | varbinary ||
|| BigIntegerValue | varbinary ||
|| CharValue | string ||
|| StringNum | string ||
|| StringKey | string ||
|| FloatNum | float ||
|| LongNum | long ||
|| TimeValue | varbinary ||
|| ShortValue | integer ||
|| ByteNum | integer ||
|| TimeStampValue | varbinary ||
|| BooleanValue | boolean ||
|| DateValue | varbinary ||

All the columns should be replaced by appropriate data type as defined in the vdb.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)