[teiid-issues] [JBoss JIRA] Resolved: (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

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-938.
----------------------------------

    Fix Version/s: 7.0
       Resolution: Done


Added the using clause to the char function specify the ascii charset.  

I'll also add a note to the documentation that the usage of char/chr/ascii may lead to inconsistent results in pushdown/non-pushdown scenarios with non-ascii range values.  i.e. Teiid will handle valid utf16 values, mysql may throw an exception or return the null character, etc.

> 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