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"