Bug #11965 Formatting 'datetime' field return a wrong field type using ADO + VB6

Description:
When I retrieve data from a table with a datetime column using aggregate functions along with the GROUP BY satatement, the filed type change to adVarChar (200) instead of adDBTimeStamp (135). As consquence when I pass the recordset to a grid I get the 'Not a valid floating point value' error (bug #10705)

XP-SP2
ADO 2.8
MyODBC 3.51.12
VB6 SP5

Regards,
Paolo Saudin

How to repeat:
Load data from a table with a 'Datetime' field using aggregate functions.

I was not able to reproduce the bug. I used your test case from bug #10705. I attached screen copy of my results.

screen copy

Attachment: screencopy.GIF (image/gif, text), 65.87 KiB.

Could you please write what version of mysql you use ?

I use Mysql 5.0.7 version.
Thanks, 
Paolo

Sorry...but I was not able to reproduce the bug on 5.0.8. Probably this bug was fixed.

I updated to Mysql 5.0.9 and the resulting field is adVarChar. I attached the test program along with the db structure and the test result as well.

Thanks,
Paolo

Mysql odbs test

Attachment: Test.GIF (image/gif, text), 19.44 KiB.

Source code

Attachment: test_mysql.zip (application/zip, text), 2.94 KiB.

New test with MySql Server 5.0.10 and MyODBC 3.51.12

Attachment: Test-5.0.10.gif (image/gif, text), 19.81 KiB.