Bugs in Datetime data type column in MyODBC

Hi,

I am not sure whether this is related to bugs #8363, as most that experience
that bug is using Access, while I am connecting to MySql in .NET using .NET
ODBC Connector and MyODBC.

It seems that when I issue a SQL query with DateTime column, it is return as
a String type. I had include several SQL queries that cause the problem
These are a simplified version and might not make logical sense, as I am
attempting to isolate the problem.

These causes problem:

SELECT callrecord.call_date + interval '08:00' hour_minute AS call_date FROM
callcenter_user user, callcenter_callrecord callrecord ORDER BY
callrecord.call_date


But the problem dissappear when I removed the ORDER BY clause, such as

SELECT callrecord.call_date + interval '08:00' hour_minute AS call_date FROM
callcenter_user user, callcenter_callrecord callrecord


The problem does not exist when I remove the table join, like

SELECT callrecord.call_date + interval '08:00' hour_minute AS call_date FROM
callcenter_callrecord callrecord ORDER BY callrecord.call_date


And lastly, the problem does not occurs if I remove the date calculation,

SELECT callrecord.call_date FROM callcenter_user user, callcenter_callrecord
callrecord ORDER BY callrecord.call_date


Any ideas? Thanks!

Regards,

Thomas Cheah
Independent Consultant & Software Developer
TCCS SoftWorkx
Phone: +60 (12) 451 9174
WWW: http://surf.to/thomascheah

"Empowering business through technology."



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org