]
Jan Stastny commented on TEIID-5027:
------------------------------------
[~vhalbert2] Yes you're right it should, my mistake in copy paste. I will correct the
description. It applies to the 'CREATE FOREIGN TABLE' usage.
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.