[wp-trac] [WordPress Trac] #44384: InnoDB doesn't support SPATIAL indexes for query CREATE TEMPORARY TABLE

[WordPress Trac]

#44384: InnoDB doesn't support SPATIAL indexes for query CREATE TEMPORARY TABLE
--------------------------+-----------------------------
 Reporter:  ottok         |       Owner:  SergeyBiryukov
     Type:  defect (bug)  |      Status:  reviewing
 Priority:  normal        |   Milestone:  5.4
Component:  Database      |     Version:  5.1
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+-----------------------------
Changes (by SergeyBiryukov):

 * owner:  (none) => SergeyBiryukov
 * status:  new => reviewing
 * milestone:  Future Release => 5.4


Comment:

 As noted in comment:1, the failure in `test_spatial_indices()` (also
 reported in #49344) 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.

 See comment:3:ticket:49344 and the patch on #49344 for more details.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/44384#comment:5>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform