public void testIntersect()
{
assertStatement("SELECT 123 INTERSECT DISTINCT SELECT 123 INTERSECT ALL SELECT 123",
new Query(
Optional.<With>absent(),
new Intersect(ImmutableList.<Relation>of(
new Intersect(ImmutableList.<Relation>of(createSelect123(), createSelect123()), true),
createSelect123()
), false),
ImmutableList.<SortItem>of(),
Optional.<String>absent(),
Optional.<Approximate>absent()));