@Test
public void testGetIncrementer_MySQL() throws Exception {

    DataFieldMaxValueIncrementer incrementer = MaxValueIncrementerFactory.getIncrementer(mysql, "MY_SEQUENCE");
    assertTrue(incrementer instanceof MaxValueIncrementerFactory.EnhancedMySQLMaxValueIncrementer);
    MaxValueIncrementerFactory.EnhancedMySQLMaxValueIncrementer mysqlIncrementer =
            (MaxValueIncrementerFactory.EnhancedMySQLMaxValueIncrementer)incrementer;
    assertEquals("MY_SEQUENCE", mysqlIncrementer.getIncrementerName());
    assertEquals("ID", mysqlIncrementer.getColumnName());
    // ensure that it's caching the incrementer
    assertSame(incrementer, MaxValueIncrementerFactory.getIncrementer(mysql, "MY_SEQUENCE"));
    // ensure that different sequence gives a different incrementer
    assertNotSame(incrementer, MaxValueIncrementerFactory.getIncrementer(mysql, "MY_SEQUENCE_2"));
}