Description:
When you call MySqlConnection::GetSchema("IndexColumns") on a database that has a full text index defined a SqlNullValueException is thrown. This works as expected when there are no full text indexes but the exception is thrown when a full text search index is defined.
Exception is
System.Data.SqlTypes.SqlNullValueException was caught
HResult=-2146232015
Message=Data is Null. This method or property cannot be called on Null values.
Source=MySql.Data
StackTrace:
at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull)
at MySql.Data.MySqlClient.MySqlDataReader.GetString(Int32 i)
at MySql.Data.MySqlClient.MySqlDataReader.GetString(String column)
at MySql.Data.MySqlClient.SchemaProvider.GetIndexColumns(String[] restrictions)
at MySql.Data.MySqlClient.SchemaProvider.GetSchemaInternal(String collection, String[] restrictions)
at MySql.Data.MySqlClient.ISSchemaProvider.GetSchemaInternal(String collection, String[] restrictions)
at MySql.Data.MySqlClient.SchemaProvider.GetSchema(String collection, String[] restrictions)
at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName, String[] restrictionValues)
How to repeat:
Define a full text search index on any table and then run the following code
_connection.GetSchema("IndexColumns");
Suggested fix:
It shouldn't crash.
Description: When you call MySqlConnection::GetSchema("IndexColumns") on a database that has a full text index defined a SqlNullValueException is thrown. This works as expected when there are no full text indexes but the exception is thrown when a full text search index is defined. Exception is System.Data.SqlTypes.SqlNullValueException was caught HResult=-2146232015 Message=Data is Null. This method or property cannot be called on Null values. Source=MySql.Data StackTrace: at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull) at MySql.Data.MySqlClient.MySqlDataReader.GetString(Int32 i) at MySql.Data.MySqlClient.MySqlDataReader.GetString(String column) at MySql.Data.MySqlClient.SchemaProvider.GetIndexColumns(String[] restrictions) at MySql.Data.MySqlClient.SchemaProvider.GetSchemaInternal(String collection, String[] restrictions) at MySql.Data.MySqlClient.ISSchemaProvider.GetSchemaInternal(String collection, String[] restrictions) at MySql.Data.MySqlClient.SchemaProvider.GetSchema(String collection, String[] restrictions) at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName, String[] restrictionValues) How to repeat: Define a full text search index on any table and then run the following code _connection.GetSchema("IndexColumns"); Suggested fix: It shouldn't crash.