[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-907) In Designer, the default data type length could cause issues when accessing EDS via ODBC
[
https://issues.jboss.org/browse/TEIIDDES-907?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-907:
-----------------------------------------
Yes this issue should have been fixed on the Teiid side. The lengths reported in pg odbc
metadata are the appropriate byte or variable length result expected from the pg_type
table rather than our length metadata value.
In Designer, the default data type length could cause issues when
accessing EDS via ODBC
----------------------------------------------------------------------------------------
Key: TEIIDDES-907
URL: https://issues.jboss.org/browse/TEIIDDES-907
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Critical
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira