[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           |   Keywords:
--------------------------+--------------------
 On the WordPress.org stats page (https://en-gb.wordpress.org/about/stats/)
 the data seems incorrect for the following reasons:

 1. There are no 10.10 / 10.11 versions listed. MariaDB 10.11 is an LTS and
 the default in Debian Bookworm. So, I would expect at least 1 user.

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

 3. In the UI frontend it appears that 12.0 is filtered out, this will be a
 real version in the coming years
 (https://github.com/WordPress/wordpress.org/blob/caf9d36e647382c6ea83e7cc6444a0a23a98c5e7/wordpress.org/public_html
 /wp-content/themes/pub/wporg-main/js/page-stats.js#L41)

 The regex filter in WordPress used to send this data to the API appears to
 be correct, so I think this is a bug in the API side. Either data
 collection or when rendering the JSON for the pie chart.

 Ideally, in addition, it would be nice if there was a separation or
 indication between MySQL and MariaDB since 5.x could mean either. Or at
 least the title change to MySQL / MariaDB versions.

 Ideally there should be a separation of MariaDB and MySQL here, or at
 least the title changed to MySQL / MariaDB.

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