Bug #22543 DATE_FORMAT error in Connector Net 1.0.7/mono
Submitted: 21 Sep 2006 9:51 Modified: 22 Nov 2006 11:08
Reporter: Martin Staael Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:1.0.7 OS:Linux (Linux)
Assigned to: CPU Architecture:Any
Tags: Mono

[21 Sep 2006 9:51] Martin Staael 
Description:
The following will fail in C# using mono under linux using ExecuteCommand

SELECT date_format(now(), '%e %b %Y')

Error:

MySql.Data.MySqlClient.MySqlException: Connection unexpectedly terminated in <0x00187> MySql.Data.MySqlClient.PacketReader:ReadHeader () in <0x000b0> MySql.Data.MySqlClient.PacketReader:OpenPacket () in <0x00025> MySql.Data.MySqlClient.NativeDriver:ReadResult (System.Int64 affectedRows, System.Int64 lastInsertId) in <0x00046> MySql.Data.MySqlClient.CommandResult:ReadNextResult (Boolean isFirst) in <0x00029> MySql.Data.MySqlClient.CommandResult:.ctor (MySql.Data.MySqlClient.Driver d, Boolean isBinary) in <0x00076> MySql.Data.MySqlClient.NativeDriver:SendQuery (System.Byte[] bytes, Int32 length, Boolean consume) in <0x00245> MySql.Data.MySqlClient.MySqlCommand:GetNextResultSet (MySql.Data.MySqlClient.MySqlDataReader reader) in (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:GetNextResultSet (MySql.Data.MySqlClient.MySqlDataReader) in <0x0004e> MySql.Data.MySqlClient.MySqlDataReader:NextResult ()

How to repeat:
By executing command using Connector/Net
[22 Oct 2006 11:08] Valeriy Kravchuk 
Thank you for a problem report. Please, try to repeat with a newr version, Connector/Net 1.0.8 rc, and inform about the results.
[23 Nov 2006 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".