예제 #1
0
 @Test
 public final void testGroupByStatement() {
   ParseTree tree = analyzer.parse(GROUP_BY[0]).getParseTree();
   assertEquals(StatementType.SELECT, tree.getType());
   QueryBlock block = (QueryBlock) tree;
   assertTrue(block.hasGroupbyClause());
   assertEquals(1, block.getGroupByClause().getGroupSet().size());
   assertEquals(
       "age", block.getGroupByClause().getGroupSet().get(0).getColumns()[0].getColumnName());
   assertTrue(block.hasHavingCond());
   assertEquals(Type.GTH, block.getHavingCond().getType());
 }