x being longitude and y being latitude doesn't seem to match my results. Is this a change in Mysql 8.4 ?
At least for points with srid 4326, x seems to be latitude and y a longitude.