Error When executing Query contains MONTHNAME()

[jchidiac]

I tried to execute the following query :

SELECT  MONTHNAME(  OrderDate  ) FROM tbOrders  

i got the following erros : TEIID10076 Invalid conversion from type class org.teiid.core.types.BinaryType with value '4D6179' to type class java.lang.String

08:56:59,258 WARN  [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue31)

8CRH1TD+GCK/ TEIID30020 Processing exception for request 8CRH1TD+GCK/.0 'TEIID10076

Invalid conversion from type class org.teiid.core.types.BinaryType with value '4D6179' to type class java.lang.String'.

Originally TransformationException DataTypeManager.java:924. Enable more detailed logging to see the entire stacktrace.

if i replace MONTHNAME by MONTH()  i got  a result.

[shawkins]

This is an oddity of the mysql driver - [TEIID-1871] Teiid is handling MySQL5.0 returning DAYNAME as a blob - JBoss Issue Tracker  This was resolved for the MySQL 5 translator, but if you are using the MySQL translator vs. a 5+ instance then that would explain why you are seeing it.  It's been a while since I looked at this, but there may be some localization/charset configuration options for MySQL that could help avoid this.

Steve