Small change to SQL after update to 8.1.9
-
This is a very minor issue – more of a question, actually.
Since upgrading to 8.1.9 I’ve noticed that the SQL generated for a search is slightly different from how it was in 8.1.6. If I run a search for jane smith, with 8.1.6 the meta_value part of the SQL was:
(((m.meta_value LIKE ‘%jane%’) AND (m.meta_value LIKE ‘%smith%’)) OR (m.meta_value LIKE ‘%jane smith%’))
Now it’s:
(((m.meta_value LIKE ‘%jane%’) AND (m.meta_value LIKE ‘%smith%’)) OR (m.meta_value LIKE ‘jane smith’))
i.e. there are no wildcard percent signs with the final ‘jane smith’.
I can’t see that this makes any difference at all to the results returned. So, it’s not causing any problems in my site. But I thought I would mention it in case there are any implications I haven’t been able to think of.
Many thanks!
- The topic ‘Small change to SQL after update to 8.1.9’ is closed to new replies.