[teiid-issues] [JBoss JIRA] Commented: (TEIID-938) MySql queries pushed down to the source producing error: Invalid conversion from type class com.metamatrix.common.types.BlobType with value 'javax.sql.rowset.serial.SerialBlob at 1b1395dc' to type class java.lang.Character
Charly Clairmont (JIRA)
jira-events at lists.jboss.org
Sun Mar 14 18:32:37 EDT 2010
[ https://jira.jboss.org/jira/browse/TEIID-938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12519753#action_12519753 ]
Charly Clairmont commented on TEIID-938:
----------------------------------------
I observe the same troubles with MySql. I test different versions. The last version of the MySql JDBC connector (5.1.12) I found correct a little this kind of errors.
> MySql queries pushed down to the source producing error: Invalid conversion from type class com.metamatrix.common.types.BlobType with value 'javax.sql.rowset.serial.SerialBlob at 1b1395dc' to type class java.lang.Character
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-938
> URL: https://jira.jboss.org/jira/browse/TEIID-938
> Project: Teiid
> Issue Type: Thirdparty Change
> Components: Query Engine
> Affects Versions: 7.0
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 7.0
>
>
> Approximately 20 queries are producing unexpected results when being pushed down to MySql. One example query and resulting error is below. Per Steve H this is a defect for MySql 5.0.15 and later. We need to add compensation logic to deal with non-ASCII range values.
> SELECT intkey, CHR(CONVERT(bigintegervalue, integer)) FROM BQT1.MediumA WHERE (IntKey > 32) AND (IntKey < 127) ORDER BY intkey
> Error occurred on connector MySQL_Push<5> - Invalid conversion from type class com.metamatrix.common.types.BlobType with value 'javax.sql.rowset.serial.SerialBlob at 1b1395dc' to type class java.lang.Character
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list