[teiid-issues] [JBoss JIRA] (TEIID-4693) mysql "booleans" translation issues

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4693.
-----------------------------------
    Resolution: Done


This will be fixed automatically when using the native importer, but for Designer or existing DDL will require setting the native type of the affected boolean columns to tinyint(1) rather than bit that is reported by mysql.  I'll make a note of this in the docs.

> mysql "booleans" translation issues 
> ------------------------------------
>
>                 Key: TEIID-4693
>                 URL: https://issues.jboss.org/browse/TEIID-4693
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 9.x
>            Reporter: Marco Ardito
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 9.2, 9.1.3
>
>
> Fields defined as tinyint(1) in MySQL are reported as a bit type in JDBC, which is then mappeed in Teiid to boolean.  However tinyint(1) does not behave as you would expect with bit. (see forum reference below for more details) at least, for instance, when it contains 0 as false and -1 as true (typical by vb/msaccess usage)



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)