cascading.lingual.jdbc
Class SimpleSqlPlatformTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          cascading.CascadingTestCase
              cascading.PlatformTestCase
                  cascading.lingual.LingualPlatformTestCase
                      cascading.lingual.jdbc.JDBCPlatformTestCase
                          cascading.lingual.jdbc.SimpleSqlPlatformTest

All Implemented Interfaces:

Serializable, junit.framework.Test

public class SimpleSqlPlatformTest
extends JDBCPlatformTestCase

This test class maintains a representative set of test statements, it is not comprehensive, which is handled by an external test suite.

Use this class to test and submit issues by forking, adding the test, and making a pull request.

See Also:

Serialized Form

Field Summary

Fields inherited from class cascading.lingual.jdbc.JDBCPlatformTestCase

DRIVER_CLASSNAME, TEST_ROOT, URI

Fields inherited from class cascading.lingual.LingualPlatformTestCase

DATA_PATH, EMPS_COLUMN_TYPES, EMPS_COLUMNS, SALES_DEPTS_TABLE, SALES_EMPS_TABLE, SALES_SALES_TABLE, SALES_SCHEMA, SALES_SCHEMA_NAME, SIMPLE_EMPLOYEE_TABLE, SIMPLE_SALES_FACT_TABLE, SIMPLE_SCHEMA, SIMPLE_SCHEMA_NAME

Fields inherited from class cascading.PlatformTestCase

name, ROOT_OUTPUT_PATH

Constructor Summary

SimpleSqlPlatformTest()

Method Summary

protected String	getDefaultSchemaPath()
void	testAnonGroupBySum()
void	testAvg()
void	testCorrelatedSubquery()
void	testCountAll()
void	testCountCity()
void	testCountDistinctCity()
void	testCountDistinctCityDistinctAge()
void	testCountDistinctCityGroupBy()
void	testCountSome()
void	testGroupByCount()
void	testInnerJoin()
void	testInnerJoinIn()
void	testInnerJoinInnerJoin()
void	testInnerJoinInnerJoinIn()
void	testInnerJoinValues()
void	testIntoSelect()
void	testIntoSelectDistinct()
void	testIntoSelectValues()
void	testIntoSelectValuesBatch()
void	testJoinedSubquery()
void	testMax()
void	testMin()
void	testMultiGroupBy()
void	testRankOver()
void	testSelect()
void	testSelectDate()
void	testSelectDateGreater()
void	testSelectDistinct()
void	testSelectDuplicateColumns()
void	testSelectDuplicateColumnsAs()
void	testSelectDuplicateColumnsAsAliasFilter()
void	testSelectDuplicateColumnsAsFilter()
void	testSelectFilterAs()
void	testSelectFilterOneInt()
void	testSelectFilterOneString()
void	testSelectFilterThree()
void	testSelectFilterTwoIntInt()
void	testSelectFilterTwoStringInt()
void	testSelectGroupOrder()
void	testSelectHaving()
void	testSelectLike()
void	testSelectOrderBy()
void	testSelectOrderByAscDesc()
void	testSelectOrderByDescNullsFirst()
void	testSelectOrderByNullsFirst()
void	testSelectOrderByNullsLast()
void	testSelectUnionOrderBy()
void	testSelfJoin()
void	testSum()
void	testSumCountDistinctCityJoinGroupBy()
void	testSumInOrderByNotSelect()
void	testSumMaxMinAvg()
void	testUnion()

Methods inherited from class cascading.lingual.jdbc.JDBCPlatformTestCase

addTable, addTable, assertExecutes, assertNamedTablesEqual, assertTablesEqual, assertTablesEqual, assertTableValuesEqual, assertTableValuesEqual, assertUpdate, assertUpdate, createTable, createTable, createTableWithRows, executeSql, executeUpdateSql, getConnection, getConnectionString, getFlowPlanPath, getPlannerDebug, getResultPath, getSQLPlanPath, getTable, getTypeFactory, setResultsTo, setUp, tearDown

Methods inherited from class cascading.lingual.LingualPlatformTestCase

enableLogging

Methods inherited from class cascading.PlatformTestCase

copyFromLocal, disableDebug, getOutputPath, getPathElements, getPlatform, getPlatformName, getProperties, getRootPath, getTestCaseName, getTestName, getTestRoot, installPlatform

Methods inherited from class cascading.CascadingTestCase

asCollection, asCollection, asCollection, asCollection, asList, asList, asSet, asSet, getSinkAsList, getSourceAsList, invokeAggregator, invokeAggregator, invokeAggregator, invokeBuffer, invokeBuffer, invokeBuffer, invokeFilter, invokeFilter, invokeFilter, invokeFilter, invokeFunction, invokeFunction, invokeFunction, invokeFunction, validateLength, validateLength, validateLength, validateLength, validateLength, validateLength, validateLength, validateLength, validateLength, validateLength

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

SimpleSqlPlatformTest

public SimpleSqlPlatformTest()

Method Detail

getDefaultSchemaPath

protected String getDefaultSchemaPath()

Specified by:

getDefaultSchemaPath in class JDBCPlatformTestCase

testSelect

public void testSelect()
                throws Exception

Throws:

Exception

testSelectFilterOneInt

public void testSelectFilterOneInt()
                            throws Exception

Throws:

Exception

testSelectFilterOneString

public void testSelectFilterOneString()
                               throws Exception

Throws:

Exception

testSelectLike

public void testSelectLike()
                    throws Exception

Throws:

Exception

testSelectFilterTwoIntInt

public void testSelectFilterTwoIntInt()
                               throws Exception

Throws:

Exception

testSelectFilterTwoStringInt

public void testSelectFilterTwoStringInt()
                                  throws Exception

Throws:

Exception

testSelectFilterThree

public void testSelectFilterThree()
                           throws Exception

Throws:

Exception

testSelectHaving

public void testSelectHaving()
                      throws Exception

Throws:

Exception

testSelectOrderBy

public void testSelectOrderBy()
                       throws Exception

Throws:

Exception

testSelectOrderByAscDesc

public void testSelectOrderByAscDesc()
                              throws Exception

Throws:

Exception

testSelectOrderByNullsFirst

public void testSelectOrderByNullsFirst()
                                 throws Exception

Throws:

Exception

testSelectOrderByDescNullsFirst

public void testSelectOrderByDescNullsFirst()
                                     throws Exception

Throws:

Exception

testSelectOrderByNullsLast

public void testSelectOrderByNullsLast()
                                throws Exception

Throws:

Exception

testSelectDistinct

public void testSelectDistinct()
                        throws Exception

Throws:

Exception

testUnion

public void testUnion()
               throws Exception

Throws:

Exception

testInnerJoin

public void testInnerJoin()
                   throws Exception

Throws:

Exception

testCountAll

public void testCountAll()
                  throws Exception

Throws:

Exception

testCountCity

public void testCountCity()
                   throws Exception

Throws:

Exception

testCountDistinctCity

public void testCountDistinctCity()
                           throws Exception

Throws:

Exception

testCountDistinctCityDistinctAge

public void testCountDistinctCityDistinctAge()
                                      throws Exception

Throws:

Exception

testCountDistinctCityGroupBy

public void testCountDistinctCityGroupBy()
                                  throws Exception

Throws:

Exception

testSum

public void testSum()
             throws Exception

Throws:

Exception

testSumInOrderByNotSelect

public void testSumInOrderByNotSelect()
                               throws Exception

Throws:

Exception

testMax

public void testMax()
             throws Exception

Throws:

Exception

testMin

public void testMin()
             throws Exception

Throws:

Exception

testAvg

public void testAvg()
             throws Exception

Throws:

Exception

testSumMaxMinAvg

public void testSumMaxMinAvg()
                      throws Exception

Throws:

Exception

testGroupByCount

public void testGroupByCount()
                      throws Exception

Throws:

Exception

testAnonGroupBySum

public void testAnonGroupBySum()
                        throws Exception

Throws:

Exception

testMultiGroupBy

public void testMultiGroupBy()
                      throws Exception

Throws:

Exception

testSelectUnionOrderBy

public void testSelectUnionOrderBy()
                            throws Exception

Throws:

Exception

testIntoSelect

public void testIntoSelect()
                    throws Exception

Throws:

Exception

testIntoSelectDistinct

public void testIntoSelectDistinct()
                            throws Exception

Throws:

Exception

testIntoSelectValues

public void testIntoSelectValues()
                          throws Exception

Throws:

Exception

testIntoSelectValuesBatch

public void testIntoSelectValuesBatch()
                               throws Exception

Throws:

Exception

testSelectDate

public void testSelectDate()
                    throws Exception

Throws:

Exception

testSelectDateGreater

public void testSelectDateGreater()
                           throws Exception

Throws:

Exception

testSelectGroupOrder

public void testSelectGroupOrder()
                          throws Exception

Throws:

Exception

testCountSome

public void testCountSome()
                   throws Exception

Throws:

Exception

testSelectFilterAs

public void testSelectFilterAs()
                        throws Exception

Throws:

Exception

testInnerJoinIn

public void testInnerJoinIn()
                     throws Exception

Throws:

Exception

testInnerJoinInnerJoin

public void testInnerJoinInnerJoin()
                            throws Exception

Throws:

Exception

testInnerJoinInnerJoinIn

public void testInnerJoinInnerJoinIn()
                              throws Exception

Throws:

Exception

testSumCountDistinctCityJoinGroupBy

public void testSumCountDistinctCityJoinGroupBy()
                                         throws Exception

Throws:

Exception

testSelectDuplicateColumns

public void testSelectDuplicateColumns()
                                throws Exception

Throws:

Exception

testSelectDuplicateColumnsAs

public void testSelectDuplicateColumnsAs()
                                  throws Exception

Throws:

Exception

testSelectDuplicateColumnsAsFilter

public void testSelectDuplicateColumnsAsFilter()
                                        throws Exception

Throws:

Exception

testSelectDuplicateColumnsAsAliasFilter

public void testSelectDuplicateColumnsAsAliasFilter()
                                             throws Exception

Throws:

Exception

testInnerJoinValues

public void testInnerJoinValues()
                         throws Exception

Throws:

Exception

testSelfJoin

public void testSelfJoin()
                  throws Exception

Throws:

Exception

testJoinedSubquery

public void testJoinedSubquery()
                        throws Exception

Throws:

Exception

testCorrelatedSubquery

public void testCorrelatedSubquery()
                            throws Exception

Throws:

Exception

testRankOver

public void testRankOver()
                  throws Exception

Throws:

Exception