client.callProcedure("InsertC", 4, 3); // only in C,D union. Eliminated by EXCEPT
client.callProcedure("InsertD", 0, 2); // in A,B and C,D unions. Eliminated by EXCEPT
VoltTable result = client.callProcedure("@AdHoc", "(SELECT I FROM A UNION SELECT I FROM B) EXCEPT (SELECT I FROM C UNION SELECT I FROM D);")
.getResults()[0];
assertEquals(1, result.getRowCount());
result.advanceToRow(0);
assertEquals(4, result.getLong(0));
}
/**
* A.I intersect all (B.I except all C.I)