In Designer, the default data type length could cause issues when accessing EDS via ODBC

Customers that are building VDB's to be accessed via ODBC will be wrong when the MAX_INT default is used. The following exception will be seen in the server log when this occurs:

1 [FunctionExecutionException] ERR.015.001.0033: Error Code:ERR.015.001.0033 Message:Error converting [2,097,152] of type integer to type short
2 [TransformationException]The Integer value '2,097,152' is outside the of range for Short
at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:259)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:969)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:633)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:603)
... 39 more