Note Testing requires low level access to the database. Upgrade test Upgrade an existing Moodle site to a patched version. TEST: Make sure the indexes were created during the upgrade. Fresh install test Install a fresh new site from the patched code. TEST: Make sure the indexes were created during the installation. Hints On MySQL, you can use   mysql> SHOW INDEX FROM mdl_search_simpledb_index;   On PostgreSQL you can use   \d mdl_search_simpledb_index;   In both case, you should confirm that you can see and index over the contextid field, another one over courseid field and another one over areaid field.