Switch to truncation for non_transactional specs

[#72461888]
Use a dynamic list of tables to detect pollution

[#72455546]