    @SuppressWarnings("null")
    @Test
    public void testgetStatementsGroupByFilledSQL_filterCommits() {

        final List<StatementFullyExecutedLog> logs = insert3Logs();
        final StatementFullyExecutedLog log1 = logs.get(0);
        repositoryUpdate.addTxCompletionLog(new TxCompleteLog(log1.getConnectionUuid(), System.currentTimeMillis(),
                TxCompletionType.COMMIT, 321, "mythread", null));

        final LogSearchCriteria searchCriteria = new LogSearchCriteria();
        searchCriteria.setRemoveTransactionCompletions(false);
        repositoryRead.getStatementsGroupByFilledSQL(searchCriteria, resultSet -> {
            // check only 3 grouped rows
            assertTrue(resultSet.next());
            assertTrue(resultSet.next());
            assertTrue(resultSet.next());
            assertFalse(resultSet.next());
        });

        searchCriteria.setRemoveTransactionCompletions(true);
        repositoryRead.getStatementsGroupByFilledSQL(searchCriteria, resultSet -> {
            // check only 2 grouped rows
            assertTrue(resultSet.next());
            assertTrue(resultSet.next());
            assertFalse(resultSet.next());
        });
    }