Resetting dashboards does not fully on oracle - it deletes the records in my_pages table but does not delete block instances, leaving them orphaned

We found it in Workplace by writing proper unittest for tenant dashboard reset and then they failed. We realised that the tests for resetting user dashboard in LMS are not testing functionality (only events), so they did not detect this problem.

There is no method to cast int to char in our DML, the code uses $DB->sql_concat("''", 'p.id') that apparently does not work in oracle