[teiid-issues] [JBoss JIRA] (TEIID-1885) Teiid is handling MySQL5.0 returning DAYNAME as a blob
Johnathon Lee (Assigned) (JIRA)
jira-events at lists.jboss.org
Tue Jan 3 13:55:09 EST 2012
[ https://issues.jboss.org/browse/TEIID-1885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Johnathon Lee reassigned TEIID-1885:
------------------------------------
Assignee: Johnathon Lee (was: Steven Hawkins)
> Teiid is handling MySQL5.0 returning DAYNAME as a blob
> ------------------------------------------------------
>
> Key: TEIID-1885
> URL: https://issues.jboss.org/browse/TEIID-1885
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.6
> Reporter: Johnathon Lee
> Assignee: Johnathon Lee
> 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
More information about the teiid-issues
mailing list