MySQL Bugs: #10152: syntax error using decimal parameter in where clause

Bug #10152	syntax error using decimal parameter in where clause
Submitted:	25 Apr 2005 17:37	Modified:	25 Jun 2005 18:48
Reporter:	Thiago Aburaya	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	5.0.3	OS:	Windows (Windows XP)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
 A syntax error (#42000) is returned when trying to use a decimal parameter
in a select query.

I looked at the Serialize method of MySqlDecimal class and it
writes one byte to inform the server the length of the decimal value
followed by the value itself.

I'm new to MySQL but I believe the error is either caused by this serialization format or by a server error when parsing the query.

How to repeat:
create a table (t1) with 2 fields : f1 (int) and f2 (decimal).
create a .NET application and try to open a datareader
using the following statement : "select * from t1 where f2 = ?f2 "
and of course using a parameter of type MySqlDecimal.

Tested on Win 2000 Sp4, Microsoft Visual C# .NET , Connector .NET 1.0.4 Test case is attached.

test program

Attachment: 10152.zip (application/x-zip-compressed, text), 6.51 KiB.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

This was fixed as a result of fixing a different bug.  The fix is in 1.0.5

Documented in 1.0.5 changelog.