[
https://issues.jboss.org/browse/TEIIDDES-2018?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2018:
----------------------------------------
TEIID DDL from BQT2 (SqlServer) ALL_TYPES table:
CREATE FOREIGN TABLE "bqt2.BQT2.ALL_TYPES" (
type_int integer OPTIONS (NAMEINSOURCE '"type_int"', NATIVE_TYPE
'int'),
type_integer integer OPTIONS (NAMEINSOURCE '"type_integer"',
NATIVE_TYPE 'int'),
type_smallint short OPTIONS (NAMEINSOURCE '"type_smallint"',
NATIVE_TYPE 'smallint'),
type_tinyint short OPTIONS (NAMEINSOURCE '"type_tinyint"', NATIVE_TYPE
'tinyint'),
type_decimal bigdecimal(18,2147483647) OPTIONS (NAMEINSOURCE
'"type_decimal"', NATIVE_TYPE 'decimal'),
type_decimal_5 bigdecimal(5,2147483647) OPTIONS (NAMEINSOURCE
'"type_decimal_5"', NATIVE_TYPE 'decimal'),
type_decimal_5_5 bigdecimal(5,2147483647) OPTIONS (NAMEINSOURCE
'"type_decimal_5_5"', NATIVE_TYPE 'decimal'),
type_double_precision double OPTIONS (NAMEINSOURCE
'"type_double_precision"', RADIX 2, NATIVE_TYPE 'float'),
type_float double OPTIONS (NAMEINSOURCE '"type_float"', RADIX 2,
NATIVE_TYPE 'float'),
type_float_10 float OPTIONS (NAMEINSOURCE '"type_float_10"', RADIX 2,
NATIVE_TYPE 'real'),
type_numeric bigdecimal(18,2147483647) OPTIONS (NAMEINSOURCE
'"type_numeric"', NATIVE_TYPE 'numeric'),
type_numeric_5 bigdecimal(5,2147483647) OPTIONS (NAMEINSOURCE
'"type_numeric_5"', NATIVE_TYPE 'numeric'),
type_numeric_5_5 bigdecimal(5,2147483647) OPTIONS (NAMEINSOURCE
'"type_numeric_5_5"', NATIVE_TYPE 'numeric'),
type_real float OPTIONS (NAMEINSOURCE '"type_real"', RADIX 2,
NATIVE_TYPE 'real'),
type_bit boolean OPTIONS (NAMEINSOURCE '"type_bit"', RADIX 0,
NATIVE_TYPE 'bit'),
type_character string(1) OPTIONS (NAMEINSOURCE '"type_character"',
NATIVE_TYPE 'char'),
type_character_10 string(10) OPTIONS (NAMEINSOURCE
'"type_character_10"', NATIVE_TYPE 'char'),
type_char string(1) OPTIONS (NAMEINSOURCE '"type_char"', NATIVE_TYPE
'char'),
type_char_10 string(10) OPTIONS (NAMEINSOURCE '"type_char_10"',
NATIVE_TYPE 'char'),
type_nchar string(1) OPTIONS (NAMEINSOURCE '"type_nchar"',
CHAR_OCTET_LENGTH 2, NATIVE_TYPE 'nchar'),
type_nchar_10 string(10) OPTIONS (NAMEINSOURCE '"type_nchar_10"',
CHAR_OCTET_LENGTH 20, NATIVE_TYPE 'nchar'),
type_varchar string(1) OPTIONS (NAMEINSOURCE '"type_varchar"',
NATIVE_TYPE 'varchar'),
type_varchar_10 string(10) OPTIONS (NAMEINSOURCE '"type_varchar_10"',
NATIVE_TYPE 'varchar'),
type_long_nvarchar string(1) OPTIONS (NAMEINSOURCE
'"type_long_nvarchar"', CHAR_OCTET_LENGTH 2, NATIVE_TYPE
'nvarchar'),
type_long_nvarchar_10 string(10) OPTIONS (NAMEINSOURCE
'"type_long_nvarchar_10"', CHAR_OCTET_LENGTH 20, NATIVE_TYPE
'nvarchar'),
type_text clob OPTIONS (NAMEINSOURCE '"type_text"', NATIVE_TYPE
'text'),
type_money bigdecimal(19,2147483647) OPTIONS (NAMEINSOURCE
'"type_money"', NATIVE_TYPE 'money'),
type_smallmoney bigdecimal(10,2147483647) OPTIONS (NAMEINSOURCE
'"type_smallmoney"', NATIVE_TYPE 'smallmoney'),
type_datetime timestamp OPTIONS (NAMEINSOURCE '"type_datetime"',
NATIVE_TYPE 'datetime'),
type_binary varbinary(1) OPTIONS (NAMEINSOURCE '"type_binary"',
NATIVE_TYPE 'binary'),
type_binary_2 varbinary(2) OPTIONS (NAMEINSOURCE '"type_binary_2"',
NATIVE_TYPE 'binary'),
type_image blob OPTIONS (NAMEINSOURCE '"type_image"', NATIVE_TYPE
'image'),
type_varbinary varbinary(1) OPTIONS (NAMEINSOURCE '"type_varbinary"',
NATIVE_TYPE 'varbinary')
) OPTIONS (NAMEINSOURCE '"bqt2"."BQT2"."ALL_TYPES"',
UPDATABLE TRUE, CARDINALITY 0);
DDL importer creates wrong data type for "integer"
--------------------------------------------------
Key: TEIIDDES-2018
URL:
https://issues.jboss.org/browse/TEIIDDES-2018
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.3
Reporter: Ramesh Reddy
Assignee: Barry LaFond
Fix For: 8.4
When using the Teiid Designer's "DDL importer" or "Teiid Connection
>> Source Model",
* if the DDL supplied is "Teiid" dialect
* if the data type supplied is "integer"
Then the resulting data type of the column/parameter is mapped "xs:decimal"
which is aliased as "integer", which results in "big integer" at run
time.
This should be mapped to "xs:long" which is aliased as "int". The
confusing thing is there is also "xs:integer" which is aliased to
"long"
--
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