[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:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  trunk
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+-----------------------------
Changes (by jeremyfelt):

 * keywords:   => needs-patch
 * milestone:  Awaiting Review => Future Release


Comment:

 I'm seeing the same thing in the `test_spacial_indices` test after
 installing MySQL 8.0.11 via Homebrew in OSX. When I look at that
 `$updates` array, the message returned is `Changed type of
 wptests_spatial_index_test.spatial_value from geomcollection to
 geometrycollection`.

 The addition of the now preferred "geomcollection" name is listed as an
 incompatible change in the 8.0.11 release notes.
 https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

 I'm guessing we may need to do some version detection in this test.

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