number(1), null, null));
assertParser(parser, "select 1 as id from t group by 2, 3",
new Select(false,
Arrays.asList(new Projection(number(1), "id")),
Arrays.asList(table("t")),
null, new GroupBy(Arrays.asList(number(2), number(3)), null), null));
assertParser(parser, "select 1 as id from t group by 2, 3 having 4",
new Select(false,
Arrays.asList(new Projection(number(1), "id")),
Arrays.asList(table("t")),
null, new GroupBy(Arrays.asList(number(2), number(3)), number(4)), null));
assertParser(parser, "select 1 as id from t order by 2 asc, 3 desc",
new Select(false,
Arrays.asList(new Projection(number(1), "id")),
Arrays.asList(table("t")),
null, null, new OrderBy(Arrays.asList(