MySQL Bugs: #44455: insert and update error with entity framework

Bug #44455	insert and update error with entity framework
Submitted:	24 Apr 14:50	Modified:	11 Aug 12:30
Reporter:	Gert Brigsted
Status:	Closed
Category:	Connector/Net	Severity:	S1 (Critical)
Version:	6.0.4	OS:	Microsoft Windows (XP Pro)
Assigned to:	Vladislav Vaintroub	Target Version:
Tags:	entity framework, decimal
Triage:	D2 (Serious)

Description:
Same as this one: http://bugs.mysql.com/bug.php?id=43574

Except that I'm from Denmark. The generated sql (grabbed from the query log) looks like
this:

		    3 Query	INSERT INTO `product`(
`Name`, 
`Price`) VALUES (
'A new product', 
13,37);

How to repeat:
DROP TABLE IF EXISTS `blah`.`product`;
CREATE TABLE  `blah`.`product` (
  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) NOT NULL,
  `Price` double NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

Suggested fix:
Make decimal values always use dot instead of comma, as the comma is always used to
separate multiple values.

Hi Gert and thanks for your report. I was about to test it but I hit Bug#44460... Will see
how to test this next week.

Hi Gert. I would like you to attach small but complete test case demonstrating this
behavior. In the meantime, I'll look for localized version of Windows with comma as
decimal separator.

Hi again. I was just wondering if you can see the example project I submitted? I set it to
only be visible to developers, although I can't remember why... :)

Yes Gert, I see it :-). So far I simply had no time to check on your report. Will do after
vacation.

True, verified as described using test case attached.

I changed my locale to use decimal comma, modified AssemblyInfo.cs, [assembly:
AssemblyCulture("")] to "sl" and "de" (both using decimal comma) and added MySQL
assemblies to Web.config:
	<add assembly="MySql.Data.Entity, Version=6.0.4.0, Culture=neutral,
PublicKeyToken=C5687FC88969C44D"/> (instead of System.Data.EntityClient)
	<add assembly="MySql.Data, Version=6.0.4.0, Culture=neutral,
PublicKeyToken=C5687FC88969C44D"/>
but to no avail...

Server Error in '/' Application.
Column count doesn't match value count at row 1
Description: An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and where it
originated in the code.

Exception Details: MySql.Data.MySqlClient.MySqlException: Column count doesn't match
value count at row 1

Source Error:

Line 20: 			{
Line 21: 				Product product = Product.CreateProduct(0, "False teeth", 13.37);
Line 22: 				database.AddToProducts(product);
Line 23: 				database.SaveChanges(); // This line fails.
Line 24: 			}

Source File: F:\PublicShare\temp\Bug44455\MysqlBug\MysqlBug.Test\Default.aspx.cs    Line:
22

Stack Trace:

[MySqlException (0x80004005): Column count doesn't match value count at row 1]
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +216
   MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64&
lastInsertId) +60
   MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +49
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +722
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +936
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator
translator, EntityConnection connection, Dictionary`2 identifierValues, List`1
generatedValues) +209
   System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager
stateManager, IEntityAdapter adapter) +281

This differs from Bug#43574 in that DOUBLE and not decimal is used. As I can not access
the patch right now I guess only decimal was handled in it.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/80462

744 Reggie Burnett	2009-08-10
      - fixed formatting of single, double, and decimal values when used with entity
framework
        in cultures that use the comma as a decimal separator (bug #44455)

fixed in 6.0.5 and 6.1.1

An entry was added to the 6.0.5 and 6.1.1 changelog:

Errors occurred when using the Entity Framework with cultures that used a comma as the
decimal separator. This was because the formatting for SINGLE, DOUBLE and DECIMAL values
was not handled correctly.