[wp-meta] [Making WordPress.org] #3295: Events API location search is case-sensitive

[Making WordPress.org]

#3295: Events API location search is case-sensitive
----------------------------+------------------
 Reporter:  SergeyBiryukov  |       Owner:
     Type:  defect          |      Status:  new
 Priority:  normal          |   Milestone:
Component:  API             |  Resolution:
 Keywords:  2nd-opinion     |
----------------------------+------------------

Comment (by iandunn):

 Replying to [comment:9 dd32]:
 > FYI I've updated the `geoname_summary_utf8mb4_test` table using those
 commands instead.

 Great! That fixed all of the tests except for `5`, and the only problems
 with the remaining ones are the missing diacritics:

 {{{
 > php tests/test-index.php

 Running 55 location tests

 * city-south-america: _FAILED_

 Expected result: Array
 (
     [description] => sao paulo
     [latitude] => -23.548
     [longitude] => -46.636
     [country] => BR
 )

 Actual result: Array
 (
     [description] => são paulo
     [latitude] => -23.548
     [longitude] => -46.636
     [country] => BR
 )

 * city-with-diacritics-in-formal-name-but-not-in-query: _FAILED_

 Expected result: Array
 (
     [description] => dona ana
     [latitude] => 32.390
     [longitude] => -106.814
     [country] => US
 )

 Actual result: Array
 (
     [description] => doña ana
     [latitude] => 32.390
     [longitude] => -106.814
     [country] => US
 )

 * city-endonym-accents-africa: _FAILED_

 Expected result: Array
 (
     [description] => yaoundé
     [latitude] => 3.867
     [longitude] => 11.517
     [country] => CM
 )

 Actual result: Array
 (
     [description] => yaounde
     [latitude] => 3.867
     [longitude] => 11.517
     [country] => CM
 )

 * city-endonym-accents-north-america: _FAILED_

 Expected result: Array
 (
     [description] => ciudad de méxico
     [latitude] => 19.428
     [longitude] => -99.128
     [country] => MX
 )

 Actual result: Array
 (
     [description] => ciudad de mexico
     [latitude] => 19.428
     [longitude] => -99.128
     [country] => MX
 )

 * 2-word-city-region: _FAILED_

 Expected result: Array
 (
     [description] => são paulo
     [latitude] => -23.548
     [longitude] => -46.636
     [country] => BR
 )

 Actual result: Array
 (
     [description] => sao
     [latitude] => -23.548
     [longitude] => -46.636
     [country] => BR
 )


 Running 2 events tests


 Running 2 add_regional_wordcamps() tests


 Running 4 build_response() tests


 Running 4 is_client_core() tests


 Finished running all tests.

 * 5 tests failed
 * 85 queries ran in 0.116151 seconds
 * Average time per query: 0.001366 seconds
 }}}

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/3295#comment:10>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org