• Resolved awilliams500

    (@awilliams500)


    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!

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Small change to SQL after update to 8.1.9’ is closed to new replies.