Bug #17736 Selecting a row with with empty date '0000-00-00' results in Read() hanging.
| Submitted: | 27 Feb 2006 11:31 | Modified: | 4 Sep 2006 14:06 |
|---|---|---|---|
| Reporter: | Matthew Cheale | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / NET | Severity: | S2 (Serious) |
| Version: | 1.07 | OS: | Windows (Win32) |
| Assigned to: | CPU Architecture: | Any |
[27 Feb 2006 13:49]
Shane Bester
verified that a hang occurs with date field of '0000-00-00'. Testcase attached (internal only).
[1 Jun 2006 21:41]
Bugs System
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/7185
[30 Aug 2006 19:36]
Reggie Burnett
pushed to 1.0.8
[4 Sep 2006 14:06]
MC Brown
A note has been added to the 1.0.8 changelog.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: C# Web Service so using .Net 2.0. How to repeat: Create a row in the database with a blank date '0000-00-00'. try { MySqlConnection oDbConn = new MySqlConnection(); oDbConn.ConnectionString = "Server=<server>;Uid=<uid>;Pwd=<pwd>;Database=<db>;"; oDbConn.Open(); MySqlCommand oDbCmd = new MySqlCommand( "SELECT `date` FROM `table` WHERE `id` = ?id", oDbConn ); oDbCmd.Prepare(); oDbCmd.Parameters.Add( "id", 1 ); MySqlDataReader oDbRes = oDbCmd.ExecuteReader(); oDbRes.Read(); oDbRes.Close(); oDbCmd.Dispose(); oDbConn.Close(); oDbConn.Dispose(); return true; } catch( Exception e ) { return false; } Suggested fix: Anything other than a hang, throw an Exception or create an uninitialised DateTime object.