projects / civicrm-core.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a1dad9d) | patch
Remove LOWER from street_address search, rely on mysql to handle.
authoreileen <emcnaughton@wikimedia.org>
Wed, 18 Jul 2018 00:18:38 +0000 (12:18 +1200)
committereileen <emcnaughton@wikimedia.org>
Wed, 18 Jul 2018 01:02:43 +0000 (13:02 +1200)
commitfea8ae41f29a41ca0f7335cda43044f76351d705
tree8dbbb3a8a8244f75041c5cc3ad4ae22621bd57ebtree | snapshot (zip tar.gz)
parenta1dad9d51bbadd8b4b51bec768cb519170c2677acommit | diff
Remove LOWER from street_address search, rely on mysql to handle.

Per https://github.com/civicrm/civicrm-core/pull/12494 the use of LOWER
- hurts performance
- fails to return results on some char sets
- messes with REGEX

This is part of a continued (we removed from contribution search fields last year)
staggered approach to removing this old mechanism
CRM/Contact/BAO/Query.php diff | blob | blame | history
tests/phpunit/CRM/Contact/BAO/QueryTest.php diff | blob | blame | history