WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #49344, comment 3


Ignore:
Timestamp:
02/04/2020 02:13:58 AM (6 years ago)
Author:
SergeyBiryukov
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #49344, comment 3

    initial v1  
    1212 Replacing `ONLY_FULL_GROUP_BY` with `STRICT_TRANS_TABLES`, however, seems unnecessary in my testing, since `ONLY_FULL_GROUP_BY` is also available on both MySQL 5.7 and 8.0.
    1313
    14 2. The failure in `test_spatial_indices()` (also reported in #44384) is caused by changing the `GeometryCollection` data type name to `GeomCollection` in [https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html#mysqld-8-0-11-spatial-support MySQL 8.0.11], which the latter being the preferred name.[[BR]][[BR]]
     142. The failure in `test_spatial_indices()` (also reported in #44384) is caused by changing the `GeometryCollection` data type name to `GeomCollection` in [https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html#mysqld-8-0-11-spatial-support MySQL 8.0.11], with the latter being the preferred name.[[BR]][[BR]]
    1515 Adding `SRID 0` did not fix the issue in my testing. Checking the database version and changing the data type accordingly in [attachment:49344.diff] did the trick.
    1616