[teiid-issues] [JBoss JIRA] (TEIID-1871) Teiid is handling MySQL5.0 returning DAYNAME as a blob
RH Bugzilla Integration (JIRA)
jira-events at lists.jboss.org
Mon Apr 9 09:18:50 EDT 2012
[ https://issues.jboss.org/browse/TEIID-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12682450#comment-12682450 ]
RH Bugzilla Integration commented on TEIID-1871:
------------------------------------------------
jolee at redhat.com changed the Status of [bug 781181|https://bugzilla.redhat.com/show_bug.cgi?id=781181] from ON_QA to CLOSED
> 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.7, 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
More information about the teiid-issues
mailing list