/core/admin/modules/dashboard/update/default.php
It does do a few ALTER queries between RC2 and 4.0.2
]]>The query being generated is something like the this:
SELECT * FROM bigtree_module_view_cache WHERE view = '29' AND (column1 LIKE '%home%' OR column2 LIKE '%home%' OR column3 LIKE '%home%')This query is generating by converting all the search parts to lowercase but then does not return any results that contain the word 'Home' in uppercase, even though that is what the search query was.
Hope this helps, let me know if you need any more info.
-Michael
]]>