@Test
public void testAssociationStateIsCaseInsensitive() throws Exception {

    Session session = cassandraCQLUnit.getSession();
    PreparedStatement insertStmt = session.prepare("INSERT INTO load_balancer_jobs(job_id, load_balancer_id, state) VALUES(?, ?, ?);");
    ResultSet rs1 = session.execute(insertStmt.bind("job-1", "lb-1", "Associated"));
    assertThat(rs1.isExhausted()).isTrue();
    assertThat(rs1.wasApplied()).isTrue();
    ResultSet rs2 = session.execute(insertStmt.bind("job-2", "lb-2", "Dissociated"));
    assertThat(rs2.isExhausted()).isTrue();
    assertThat(rs2.wasApplied()).isTrue();
    ResultSet rs3 = session.execute(insertStmt.bind("job-3", "lb-3", "aSsOcIaTeD"));
    assertThat(rs3.isExhausted()).isTrue();
    assertThat(rs3.wasApplied()).isTrue();
    CassandraLoadBalancerStore store = getInitdStore();
    assertThat(store.getAssociations()).containsExactlyInAnyOrder(
            new JobLoadBalancerState(new JobLoadBalancer("job-1", "lb-1"), ASSOCIATED),
            new JobLoadBalancerState(new JobLoadBalancer("job-2", "lb-2"), DISSOCIATED),
            new JobLoadBalancerState(new JobLoadBalancer("job-3", "lb-3"), ASSOCIATED)
    );
}