MySQL 5.7 and detectServerType
Posted: 11.11.2020, 16:59
Hi All!
In TZMySQLDatabaseMetadata.detectServerType it is looking for either 'mysql' or 'mariadb' in the results of
show variables like 'version' and show variables like 'version_comment'.
However, my main test MySQL 5.7 database doesn't actually have the mysql text in the version_comment. It shows:
version: 5.7.32-0ubuntu0.18.04.1
version_comment: (Ubuntu)
I have no idea if it's something that went wrong during install or if it's just common for it not to have it. My MySQL 8 install does show 'mysql' in the comment btw.
And so I was wondering if TZMySQLDatabaseMetadata.detectServerType should default to MySQL even if it doesn't find the 'mysql' text, butI don't know anything about the various versions/forks of MySQL that need to be detected. Any thoughts on this appreciated!
-Mark
In TZMySQLDatabaseMetadata.detectServerType it is looking for either 'mysql' or 'mariadb' in the results of
show variables like 'version' and show variables like 'version_comment'.
However, my main test MySQL 5.7 database doesn't actually have the mysql text in the version_comment. It shows:
version: 5.7.32-0ubuntu0.18.04.1
version_comment: (Ubuntu)
I have no idea if it's something that went wrong during install or if it's just common for it not to have it. My MySQL 8 install does show 'mysql' in the comment btw.
And so I was wondering if TZMySQLDatabaseMetadata.detectServerType should default to MySQL even if it doesn't find the 'mysql' text, butI don't know anything about the various versions/forks of MySQL that need to be detected. Any thoughts on this appreciated!
-Mark