> but the teiid treat integer to long in loading the metadata
This is likely due to the MariaDB integer being unsigned by default and the importer defaults to widening unsigned types - as a general rule the imported types are as wide or wider than the source types.
> a exception thew in vdb deploying
If you have a view that is expecting an integer and instead the expression is a long, then yes that should be an exception.
> Should this be a expected behavior? or it should be a defects?
You should either use a signed MariaDB integer, or set the importer to not widen unsigned types.