title: @Transactional annotation and @Sql annotation doesn't work together in spring test
body: <p>I'm trying to write some tests for my default dao class and I want to execute SQL script on a test method via @sql annotation and use @Transactional annotation together, my script is executed but transaction is not rolled back:</p>
  <pre><code>@ExtendWith(SpringExtension.class)
  @ContextConfiguration(classes = TestDaoConfig.class)
  class DefaultDaoImplTest {
  
      @Transactional()
      @Sql(&quot;/dropAllobjects.sql&quot;)
      @Test
      void findAll_ShouldThrowDaoException_WhenTablesNotExist() {
          assertThrows(DaoException.class, () -&gt; defaultDaoImpl.findAll());
      }
  }
  </code></pre>