@Override public Double visit(AggregatePlan plan) { try { Long b = plan.getEstimatedRowsToScan(); if (b != null) { return limit( filter( aggregate( filter( b.doubleValue(), stripSkipScanFilter( plan.getContext().getScan().getFilter())), plan.getGroupBy()), plan.getHaving()), plan.getLimit()); } } catch (SQLException e) { } return null; }
assertTrue(orderBy.getOrderByExpressions().size() == 1); assertTrue(orderBy.getOrderByExpressions().get(0).toString().equals("SUM(AGE)")); assertTrue(innerAggregatePlan.getLimit().intValue() == 3); assertTrue(orderBy.getOrderByExpressions().size() == 1); assertTrue(orderBy.getOrderByExpressions().get(0).toString().equals("SUM(CODE)")); assertTrue(innerAggregatePlan.getLimit().intValue() == 1); assertTrue(orderBy.getOrderByExpressions().size() == 1); assertTrue(orderBy.getOrderByExpressions().get(0).toString().equals("SUM(B.CODE)")); assertTrue(innerAggregatePlan.getLimit().intValue() == 3); assertTrue(orderBy.getOrderByExpressions().size() == 1); assertTrue(orderBy.getOrderByExpressions().get(0).toString().equals("SUM(C.REGION) DESC")); assertTrue(innerAggregatePlan.getLimit().intValue() == 2); assertTrue(orderBy.getOrderByExpressions().get(0).toString().equals("A.AID")); assertTrue(orderBy.getOrderByExpressions().get(1).toString().equals("SUM(B.CODE)")); assertTrue(innerAggregatePlan.getLimit().intValue() == 3); assertTrue(orderBy.getOrderByExpressions().get(0).toString().equals("A.AID DESC")); assertTrue(orderBy.getOrderByExpressions().get(1).toString().equals("SUM(C.REGION) DESC")); assertTrue(innerAggregatePlan.getLimit().intValue() == 2); } finally { if(conn!=null) {
@Override public Double visit(AggregatePlan plan) { try { Long b = plan.getEstimatedRowsToScan(); if (b != null) { return limit( filter( aggregate( filter( b.doubleValue(), stripSkipScanFilter( plan.getContext().getScan().getFilter())), plan.getGroupBy()), plan.getHaving()), plan.getLimit()); } } catch (SQLException e) { } return null; }
@Override public Double visit(AggregatePlan plan) { try { Long b = plan.getEstimatedRowsToScan(); if (b != null) { return limit( filter( aggregate( filter( b.doubleValue(), stripSkipScanFilter( plan.getContext().getScan().getFilter())), plan.getGroupBy()), plan.getHaving()), plan.getLimit()); } } catch (SQLException e) { } return null; }