com.bigdata.bop.solutions

Class TestGroupByState

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

junit.framework.TestCase2

com.bigdata.bop.solutions.TestGroupByState

All Implemented Interfaces:

junit.framework.Test

public class TestGroupByState
extends TestCase2

Test suite for GroupByState.

Version:

$Id$

Author:

Bryan Thompson

Nested Class Summary

Nested classes/interfaces inherited from class junit.framework.TestCase2

TestCase2.MyProperties, TestCase2.RandomType

Field Summary

Fields inherited from class junit.framework.TestCase2

_randomType, log

Constructor Summary

Constructors

Constructor and Description
TestGroupByState()
TestGroupByState(String name)

Method Summary

Methods

Modifier and Type	Method and Description
protected void	setUp()
protected void	tearDown()
void	test_aggregateExpr_01() Unit test with SELECT clause having one value expression, which is a simple variable also appearing as the sole value expression in the GROUP_BY clause.
void	test_aggregateExpr_02() Unit test with SELECT clause having one value expression, which is a simple variable also appearing as the sole value expression in the GROUP_BY clause.
void	test_aggregateExpr_03() Unit test for references to aggregate declared in GROUP_BY with AS.
void	test_aggregateExpr_04() Unit test verifies that a constant within a group by clause does not cause the group by clause to be interpreted as an aggregate.
void	test_complexHavingClause() SELECT SUM(?y) as ?x GROUP BY ?z HAVING SUM(?y) > 10
void	test_correctRejection() Unit test for bad arguments.
void	test_forwardReference_not_allowed() Forward references to a variable are not allowed.
void	test_isAnyDistinct_having() Unit test for IGroupByState#isAnyDistinct()) where the DISTINCT keyword appears within an {@link IAggregate} in the SELECT clause.
void	test_isAnyDistinct_select() Unit test for IGroupByState#isAnyDistinct()) where the DISTINCT keyword appears within an {@link IAggregate} in the SELECT clause.
void	test_nestedAggregates() SELECT SUM(?x+MIN(?y)) as ?z GROUP BY ?a
void	test_reverseReference_allowed_aka_select_dependency() Verify that a reference to a variable defined by a previous select expression is allowed and that the select dependency is recognized.
void	test_simpleAggregate_noGroupBy() Unit test with simple aggregate function in SELECT clause and no GROUP BY clause (the aggregation is taken across all solutions as if they were a single group).
void	test_simpleAggregate() Unit test with simple aggregate function in SELECT clause.
void	test_simpleHavingClause() SELECT SUM(?y) as ?x GROUP BY ?z HAVING ?x > 10
void	test_with_constant() Unit test when projecting a constant

Methods inherited from class junit.framework.TestCase2

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEqualsWithinUlps, assertSameArray, assertSameArray, assertSameBigDecimal, assertSameBigDecimal, assertSameBigInteger, assertSameBigInteger, assertSameIterator, assertSameIterator, assertSameIteratorAnyOrder, assertSameIteratorAnyOrder, assertSameValue, assertSameValue, assertZeroUlps, assertZeroUlps, fail, getInnerCause, getNormalInt, getProjectBuildPath, getProperties, getRandomObject, getRandomObject, getRandomOrder, getRandomString, getTestInputStream, getTestResource, getTestResource, getUlps, getUlps, isDEBUG, isDEBUG, isINFO, isINFO, isInnerCause, logProperties

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runBare, runTest, setName, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

TestGroupByState

public TestGroupByState()

TestGroupByState

public TestGroupByState(String name)

Parameters:

name -

Method Detail

setUp

protected void setUp()
              throws Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

Exception

tearDown

protected void tearDown()
                 throws Exception

Overrides:

tearDown in class junit.framework.TestCase

Throws:

Exception

test_aggregateExpr_01

public void test_aggregateExpr_01()

Unit test with SELECT clause having one value expression, which is a simple variable also appearing as the sole value expression in the GROUP_BY clause.

 SELECT ?org
 GROUP BY ?org
 

test_aggregateExpr_02

public void test_aggregateExpr_02()

Unit test with SELECT clause having one value expression, which is a simple variable also appearing as the sole value expression in the GROUP_BY clause. However, in this case we rename the variable when it is projected out of the SELECT expression.

 SELECT ?org as ?newVar
 GROUP BY ?org
 

test_simpleAggregate

public void test_simpleAggregate()

Unit test with simple aggregate function in SELECT clause.

 SELECT ?org, SUM(?lprice) AS ?totalPrice
 GROUP BY ?org
 

test_simpleAggregate_noGroupBy

public void test_simpleAggregate_noGroupBy()

Unit test with simple aggregate function in SELECT clause and no GROUP BY clause (the aggregation is taken across all solutions as if they were a single group).

 SELECT SUM(?lprice) AS ?totalPrice
 

test_aggregateExpr_03

public void test_aggregateExpr_03()

Unit test for references to aggregate declared in GROUP_BY with AS.

 SELECT ?org2
 GROUP BY UCASE(?org) as ?org2
 

test_aggregateExpr_04

public void test_aggregateExpr_04()

Unit test verifies that a constant within a group by clause does not cause the group by clause to be interpreted as an aggregate.

 select ?index
 group by (?o + 1 AS ?index)
 

test_simpleHavingClause

public void test_simpleHavingClause()

 SELECT SUM(?y) as ?x
 GROUP BY ?z
 HAVING ?x > 10
 

test_complexHavingClause

public void test_complexHavingClause()

 SELECT SUM(?y) as ?x
 GROUP BY ?z
 HAVING SUM(?y) > 10
 

test_nestedAggregates

public void test_nestedAggregates()

 SELECT SUM(?x+MIN(?y)) as ?z
 GROUP BY ?a
 

test_reverseReference_allowed_aka_select_dependency

public void test_reverseReference_allowed_aka_select_dependency()

Verify that a reference to a variable defined by a previous select expression is allowed and that the select dependency is recognized.

 SELECT SUM(?y) as ?z, SUM(?x)+?z as ?a 
 GROUP BY ?b
 

test_forwardReference_not_allowed

public void test_forwardReference_not_allowed()

Forward references to a variable are not allowed.

 SELECT SUM(?x)+?z as ?a, SUM(?y) as ?z ... (forward reference to z)
 

test_isAnyDistinct_select

public void test_isAnyDistinct_select()

Unit test for IGroupByState#isAnyDistinct()) where the DISTINCT keyword appears within an {@link IAggregate} in the SELECT clause.

 SELECT SUM(DISTINCT ?y) as ?x
 GROUP BY ?z
 HAVING ?x > 10
 

test_isAnyDistinct_having

public void test_isAnyDistinct_having()

Unit test for IGroupByState#isAnyDistinct()) where the DISTINCT keyword appears within an {@link IAggregate} in the SELECT clause.

 SELECT SUM(?y) as ?x
 GROUP BY ?z
 HAVING SUM(DISTINCT ?y) > 10
 

test_with_constant

public void test_with_constant()

Unit test when projecting a constant

 SELECT 12 as ?x
 

test_correctRejection

public void test_correctRejection()

Unit test for bad arguments.