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

• Submitted: 15 Jul 2005 11:46
• Modified: 18 Jul 2005 9:14
• Reporter: Paolo Saudin
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S2 (Serious)
• Version: 3.51.12
• OS: Windows (WIN-XP SP2)
• CPU Architecture: Any

[15 Jul 2005 11:46] Paolo Saudin

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.

[16 Jul 2005 7:54] Vasily Kishkin

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

[16 Jul 2005 7:55] Vasily Kishkin

screen copy

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

[16 Jul 2005 8:49] Vasily Kishkin

Could you please write what version of mysql you use ?

[18 Jul 2005 6:22] Paolo Saudin

I use Mysql 5.0.7 version.
Thanks, 
Paolo

[18 Jul 2005 9:14] Vasily Kishkin

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

[18 Jul 2005 12:13] Paolo Saudin

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

[18 Jul 2005 12:13] Paolo Saudin

Mysql odbs test

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

[18 Jul 2005 12:14] Paolo Saudin

Source code

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

[4 Aug 2005 12:26] Paolo Saudin

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.