Wrong MariaDB version detected over MySQL libs.

[vholer]

Description
When database client is connecting with MySQL client libs to the MariaDB server, the database version detection for the FTS can catch the wrong version here:

one/src/sql/MySqlDB.cc

Lines 367 to 373 in 6db6c3f

	bool MySqlDB::fts_available()
	{
	unsigned long version;
	version = mysql_get_server_version(db_escape_connect);
	if (version >= 50600)

because the MariaDB server can be (or is always?) identified to the MySQL client as composition of 2 versions (5.5.5-10.3.11-MariaDB). Example of full text identification:

Server version: 5.5.5-10.3.11-MariaDB MariaDB Server

The function mysql_get_server_version returns the first part with value 50505. Then the FTS indexes are not created and FTS search doesn't work. Strange thing is that it doesn't apply to Ruby MySQL connector (the DB upgrades) where @db.server_version gets 100311 as expected.

Tasks:

• fts_available should deal with MariaDB versioning when connected w/ MySQL libs.
• NICE TO HAVE: dump server identification on connect into oned.log + incl. state of various optional features (FTS for now)

Details

• Affected Component: Core
• Version: 5.9.90

Progress Status

• Branch created
• Code committed to development branch
• Testing - QA
• Documentation
• Release notes - resolved issues, compatibility, known issues
• Code committed to upstream release/hotfix branches
• Documentation committed to upstream release/hotfix branches