"cnt2", new FieldDef(new AggregateFunction("COUNT", false, new FieldValue(null, "partyId")), "cnt2"),
"cnt3", new FieldDef(new AggregateFunction("COUNT", true, new FieldValue("a", "partyId")), "cnt3")
),
new Table(
new TableName("Party", "a"),
new Joined(true, new TableName("Person", "b"), list(new KeyMap("partyId", "partyId")),
new Joined(true, new TableName("PartyGroup", "c"), list(new KeyMap("partyId", "partyId")),
new Joined(false, new TableName("PartyRole", "d"), list(new KeyMap("partyId", "partyId"), new KeyMap("partyId", "partyId")))
)
)
),
GenericTestCaseBase.<String, Relation>map(
"MainAPerson", new Relation("one", "MainA", "Person", list(new KeyMap("partyId", "partyId"))),
"MainBPerson", new Relation(null, "MainB", "Person", list(new KeyMap("partyId", "partyId"))),
"Person", new Relation("one", null, "Person", list(new KeyMap("partyId", "partyId"))),
"PartyGroup", new Relation(null, null, "PartyGroup", list(new KeyMap("partyId", "partyId")))
),
new ConditionList(
Joiner.OR,
GenericTestCaseBase.<Condition>list(
new ConditionList(