[teiid-issues] [JBoss JIRA] (TEIID-1871) Teiid is handling MySQL5.0 returning DAYNAME as a blob
Steven Hawkins (Updated) (JIRA)
jira-events at lists.jboss.org
Wed Dec 14 11:08:10 EST 2011
[ https://issues.jboss.org/browse/TEIID-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-1871:
----------------------------------
Attachment: (was: mysql-connector-java-5.0.8-bin.jar)
> 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
> 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