Bug #96500 MySqlDataReader.GetFieldValue<MySqlGeometry> throws InvalidCastException
Submitted: 10 Aug 2019 13:39 Modified: 11 Aug 2019 11:43
Reporter: Bradley Grainger (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:8.0.17 OS:Microsoft Windows (10)
Assigned to: CPU Architecture:Other (x64)

[10 Aug 2019 13:39] Bradley Grainger
Description:
Calling MySqlDataReader.GetFieldValue<MySqlGeometry>() for a GEOMETRY column will throw InvalidCastException. The expected behaviour is that this method would succeed whenever MySqlDataReader.GetMySqlGeometry() is supported.

How to repeat:
Run the following SQL:

DROP TABLE IF EXISTS geometries;
CREATE TABLE geometries(id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, data GEOMETRY);
INSERT INTO geometries(data) VALUES (POINT(1, 1)), (POINT(1, 2));

Run the following C# code:

using (var connection = new MySqlConnection("..."))
{
	connection.Open();
	using (var command = new MySqlCommand("SELECT data FROM geometries WHERE id = 1", connection))
	using (var reader = command.ExecuteReader())
	{
		reader.Read();

		// works
		reader.GetMySqlGeometry(0);

		// throws InvalidCastException; expected to return same value
		reader.GetFieldValue<MySqlGeometry>(0);
	}
}
[11 Aug 2019 11:43] Umesh Shastry
Hello Bradley,

Thank you for the report and test case.

regards,
Umesh