stat.execute("CREATE TABLE TEST(ID INT, NAME VARCHAR)");
rs = stat.executeQuery("SELECT * FROM TEST");
assertEquals(1, rs.findColumn("ID"));
assertEquals(2, rs.findColumn("NAME"));
assertEquals(1, rs.findColumn("id"));
assertEquals(2, rs.findColumn("name"));
assertEquals(1, rs.findColumn("Id"));
assertEquals(2, rs.findColumn("Name"));
assertEquals(1, rs.findColumn("TEST.ID"));
assertEquals(2, rs.findColumn("TEST.NAME"));
assertEquals(1, rs.findColumn("Test.Id"));