Bug #89639 Connection.GetSchema("ReservedWords") returns incorrect result
Submitted: 13 Feb 2018 1:56 Modified: 30 Jul 2020 20:23
Reporter: Alexander Zaytsev Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.10.4, 6.10.5, 6.10.6 OS:Any
Assigned to: CPU Architecture:Any

[13 Feb 2018 1:56] Alexander Zaytsev 
Description:
In 6.10 connector incorrectly reads the MySql.Data.Properties.ReservedWords.txt assembly resource. The file contains approximately 3 reserved keywords per line which were separated by spaces. In version 6.9.10 the code was correctly handling this situation. But in the commit 
 https://github.com/mysql/mysql-connector-net/commit/f02c48123f6c959ec4c32a3b5d40f516b87e76... it was changed to only the lines from the file into the collection as is. But the ReservedWords.txt file was not updated.

How to repeat:
Introspect DataTable returned by Connection.GetSchema("ReservedWords") 

Suggested fix:
Either revert code changes in https://github.com/mysql/mysql-connector-net/commit/f02c48123f6c959ec4c32a3b5d40f516b87e76... or update the ReservedWords.txt file
[13 Feb 2018 6:09] Chiranjeevi Battula 
Hello Alexander,

Thank you for the bug report.

Thanks,
Chiranjeevi.
[30 Jul 2020 20:23] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL Connector/NET 8.0.22 release, and here's the proposed changelog entry from the documentation team:

Connector/NET code did not read from the
MySql.Data.Properties.ReservedWords.txt assembly resource consistently,
and in some cases, used a version of the ReservedWords.txt file that
returned an incomplete set of reserved keywords.

Thank you for the bug report.