Bug #37266 arithmetic operation error
Submitted: 7 Jun 2008 23:30 Modified: 11 Jun 2008 11:47
Reporter: Neoh Royo Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version: OS:Windows
Assigned to: CPU Architecture:Any

[7 Jun 2008 23:30] Neoh Royo 
Description:
Arithmetic operation error in MySQL Server 6.0, with ODBC Connector 5.1 and ADO Recordset using VB.

example: select 337 * 9.1 
result: 306600

How to repeat:
Private Sub Form_Load()
    Dim con As New ADODB.Connection
    con.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;PORT=3306;DATABASE=test;UID=root;PWD="
    Dim rs As New ADODB.Recordset
    con.Open
    rs.ActiveConnection = con
    rs.Source = "select 337 * 9.1"
    rs.Open
    MsgBox rs.Fields(0)
    rs.Close
End Sub
[8 Jun 2008 17:42] Valeriy Kravchuk 
Thank you for a problem report. What exact versions of MySQL server, 6.0.x, and Connector/ODBC 5.1.x, do you use?
[11 Jun 2008 7:33] Neoh Royo 
It was a bug in Connector 5.1.1, and I downloaded Connector 5.1.4 recently (I'm not aware of its existence before), and the problem has been resolved. Thanks...
[11 Jun 2008 11:47] Tonci Grgin 
Closed as per last remark: "Fixed in 5.1.4GA".