[teiid-issues] [JBoss JIRA] (TEIID-1871) Teiid is handling MySQL5.0 returning DAYNAME as a blob

[RH Bugzilla Integration (JIRA)]

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

RH Bugzilla Integration commented on TEIID-1871:
------------------------------------------------

Larry O'Leary <loleary at redhat.com> changed the Status of [bug 781181|https://bugzilla.redhat.com/show_bug.cgi?id=781181] from ASSIGNED to ON_DEV
                
> Teiid is handling MySQL5.0 returning DAYNAME as a blob
> ------------------------------------------------------
>
>                 Key: TEIID-1871
>                 URL: https://issues.jboss.org/browse/TEIID-1871
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.6
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>             Fix For: 7.6.1, 8.0
>
>         Attachments: QT_MySql50_Push.vdb
>
>
> SELECT IntKey, DAYNAME(datevalue) FROM BQT1.SmallA ORDER BY IntKey LIMIT 10
> Fails with:
> Caught SQLException:
> Invalid conversion from type class org.teiid.core.types.BlobType with value 'javax.sql.rowset.serial.SerialBlob at 6482112e' to type class java.lang.String
> Dev indicaters, "The driver returns the bytes, which we treat as a blob.  We have an explicit workaround in the translator for the char function, but I've never seen this outside of the char function.  There may be an issue with the http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_lc_time_names setting also that could influence how the value is returned."
> The server setting is en_US.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira