[wp-meta] [Making WordPress.org] #7080: Odd data for the MySQL/MariaDB versions on WordPress.org stats

[Making WordPress.org]

#7080: Odd data for the MySQL/MariaDB versions on WordPress.org stats
--------------------------+---------------------
 Reporter:  l1nuxjedi     |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:
Component:  API           |  Resolution:
 Keywords:                |
--------------------------+---------------------

Comment (by dd32):

 These stats are a bit ambiguous, WordPress reports the Database version
 but doesn't actually identify the Database Engine / Server. So installs of
 MySQL/MariaDB/MsSQL/Sqlite/Percona Server/etc all report as a "MySQL
 version".

 This is what is sent to WordPress.org:
 https://github.com/WordPress/wordpress-develop/blob/trunk/src/wp-
 includes/update.php#L76-L82
 which is generated from this:
 https://github.com/WordPress/wordpress-develop/blob/trunk/src/wp-includes
 /class-wpdb.php#L4101-L4111


 > There are no 10.10 / 10.11 versions listed.

 Thanks, it looks like it was being treated as a decimal version, so
 10.10/10.11 were being counted in 10.1. This will be fixed shortly (and
 retroactively where possible)

 > There is an 11.5 listed. There is no MySQL / MariaDB 11.5

 The most common version identifier for 11.5 that is reported is `11.5.30`,
 which google only seems to suggest a Plesk version. I'm guessing there's a
 MySQL-like server instance included on a popular host that is showing the
 OS/Plesk version identifier rather than the actual SQL server version.

 > In the UI frontend it appears that 12.0 is filtered out, this will be a
 real version in the coming years

 It looks safe to remove this line now. Between 2016 -> 2019 version
 `12.0.200` was being reported as a DB version, which I believe was a
 truncated Microsoft SQL version identifier of `12.0.2000.8`.

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/7080#comment:4>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org