[teiid-issues] [JBoss JIRA] Commented: (TEIID-806) JDBC connector handling of convert is inconsistent

[Steven Hawkins (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12483137#action_12483137 ] 

Steven Hawkins commented on TEIID-806:
--------------------------------------

Boolean handling also currently typically only accounts to 0 and 1.  however to and from string operations should also account for TRUE and FALSE and allow for null values.

Based upon  TEIID-800 char should also consistently be treated as char(1).

> JDBC connector handling of convert is inconsistent
> --------------------------------------------------
>
>                 Key: TEIID-806
>                 URL: https://jira.jboss.org/jira/browse/TEIID-806
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: JDBC Connector
>    Affects Versions: 6.0.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 6.3.0
>
>
> If a source lacks the exact representation of a Teiid type we approximate it with the closest source type.  Pushed converts will typically not have the same affect as if they are evaluated in the engine.  For example sources lacking byte or tinyint types are having conversions dropped rather, but the actual effect should be modulo the max byte value.  We also are not ensuring that the truncation or rounding behavior is the same for all conversions - such as from a floating point number to a fixed point.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira