assertEquals("[5, susie, 18, 4, 4, trying harder, try]", Arrays.toString(objectArrays.get(4)));
assertEquals(5, objectArrays.size());
}
public void testRightJoin() throws Exception {
SelectItem si1 = new SelectItem(new MutableColumn("person_id", ColumnType.INTEGER));
SelectItem si2 = new SelectItem(new MutableColumn("person_name", ColumnType.VARCHAR));
SelectItem si3 = new SelectItem(new MutableColumn("person_age", ColumnType.INTEGER));
SelectItem si4 = new SelectItem(new MutableColumn("person_role_id", ColumnType.INTEGER));
SelectItem si5 = new SelectItem(new MutableColumn("role_id", ColumnType.INTEGER));
SelectItem si6 = new SelectItem(new MutableColumn("role_name", ColumnType.VARCHAR));
SelectItem si7 = new SelectItem(new MutableColumn("role_code", ColumnType.VARCHAR));
List<Object[]> data1 = new ArrayList<Object[]>();
data1.add(new Object[] { 1, "peter", 18, 1 });
data1.add(new Object[] { 2, "tom", 19, 2 });
data1.add(new Object[] { 3, "betty", 19, null });
data1.add(new Object[] { 4, "barbara", 17, 3 });