Bug #40571 Add GetSByte to the list of public methods supported by MySqlDataReader

Submitted: 7 Nov 2008 3:31 Modified: 10 Nov 2008 14:58
Reporter: Christopher Jerdonek Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S4 (Feature request)
Version:5.2.3.0 OS:Windows
Assigned to: CPU Architecture:Any
Tags: DbDataReader, GetSByte, MySqlDataReader, SByte, type

[7 Nov 2008 3:31] Christopher Jerdonek
Description:
The MySqlDataReader class currently exposes a public "Get" method for nearly all .NET system types that have a corresponding representation in MySql.

For example, GetDecimal, GetDouble, GetByte, GetUInt64, etc. are all supported.

Given that some MySql columns can have a corresponding .NET system type of SByte, it would be consistent and natural also to expose GetSByte.  MySqlDataReader's GetFieldType method, for example, yields SByte for columns with a MySql data type of signed TINYINT(3).

Thanks.

How to repeat:
Try compiling the following program, and notice that it doesn't compile because of the final line:

class Program
{
	static void Main(string[] args)
	{
		MySqlCommand command = new MySqlCommand();
		
		MySqlDataReader reader = command.ExecuteReader();

		reader.GetByte(0);

		reader.GetSByte(0);
	}
}
[7 Nov 2008 18:53] Tonci Grgin
Hi Christopher and thanks for reasonable feature request. Let's see what Reggie will say.
[7 Nov 2008 19:35] 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/58229
[7 Nov 2008 19:35] Reggie Burnett
fixed in 5.2.4+
[7 Nov 2008 21:39] Christopher Jerdonek
Wow, that was amazingly fast -- thank you!
[10 Nov 2008 14:58] Tony Bedford
An entry was added to the 5.2.4 changelog:

MySqlDataReader did not feature a GetSByte method.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.054 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.