@Test
public void getDistinctKeysAndCounts(){

    Connection connection = null;
    ResultSet resultSet = null;
    try {
        ConnectionManager connectionManager = temporaryFileDatabase.getConnectionManager(true);
        initWithTestData(connectionManager);
        connection = connectionManager.getConnection(null, noQueryOptions());
        resultSet = DBQueries.getDistinctKeysAndCounts(false, NAME, connection);
        Map<String, Integer> resultSetToMap = resultSetToMap(resultSet);
        assertEquals(3, resultSetToMap.size());
        assertEquals(new Integer(2), resultSetToMap.get("abs"));
        assertEquals(new Integer(1), resultSetToMap.get("airbags"));
        assertEquals(new Integer(1), resultSetToMap.get("gps"));
    }finally {
        DBUtils.closeQuietly(resultSet);
        DBUtils.closeQuietly(connection);
    }
}