MySQL Bugs: #40571: Add GetSByte to the list of public methods supported by MySqlDataReader

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

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);
	}
}

Hi Christopher and thanks for reasonable feature request. Let's see what Reggie will say.

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

fixed in 5.2.4+

Wow, that was amazingly fast -- thank you!

An entry was added to the 5.2.4 changelog:

MySqlDataReader did not feature a GetSByte method.