org.apache.derbyTesting.functionTests.tests.lang

Class GroupByExpressionTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.GroupByExpressionTest

All Implemented Interfaces:

junit.framework.Test

public class GroupByExpressionTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String[]	FUNCTIONS
private static java.lang.String[]	TABLES

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
GroupByExpressionTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
void	assertRow(java.lang.String assertString, java.sql.ResultSet rs, java.lang.Object[] expectedRow)
private java.lang.Object[]	intRow(int[] expected)
static junit.framework.Test	suite()
void	testDerby3094Expressions() queries which combine compound expressions and simple column refs.
void	testDerby4402AggregateInGroupBy() DERBY-4202 Aggregates not allowed in group by
void	testDuplicateColumns() Check that duplicate columns are now allowed in group by's.
void	testExtractOperator()
void	testMiscExpressions()
void	testNegative() Negative tests.
void	testSimpleExpressions() Basic test case.
void	testSubSelect()
private void	verifyQueryResults(java.lang.String assertString, java.lang.String query, int[][] golden)
private void	verifyQueryResults(java.lang.String assertString, java.lang.String query, java.lang.Object[][] golden)

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

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, runTest, setName, setUp, toString

Methods inherited from class java.lang.Object

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

Field Detail

TABLES

private static java.lang.String[] TABLES

FUNCTIONS

private static java.lang.String[] FUNCTIONS

Constructor Detail

GroupByExpressionTest

public GroupByExpressionTest(java.lang.String name)

Method Detail

testSimpleExpressions

public void testSimpleExpressions()
                           throws java.lang.Exception

Basic test case. Checks functionality with simple arithmetic expressions

Throws:

java.lang.Exception

testDerby4402AggregateInGroupBy

public void testDerby4402AggregateInGroupBy()
                                     throws java.lang.Exception

DERBY-4202 Aggregates not allowed in group by

Throws:

java.lang.Exception

testDerby3094Expressions

public void testDerby3094Expressions()
                              throws java.lang.Exception

queries which combine compound expressions and simple column refs.

Throws:

java.lang.Exception

testSubSelect

public void testSubSelect()
                   throws java.lang.Exception

Throws:

java.lang.Exception

testMiscExpressions

public void testMiscExpressions()
                         throws java.lang.Exception

Throws:

java.lang.Exception

testExtractOperator

public void testExtractOperator()
                         throws java.lang.Exception

Throws:

java.lang.Exception

testDuplicateColumns

public void testDuplicateColumns()
                          throws java.lang.Exception

Check that duplicate columns are now allowed in group by's. Earlier (pre 883), derby would flag an error.

Throws:

java.lang.Exception

testNegative

public void testNegative()

Negative tests. These queries should not compile at all.

intRow

private java.lang.Object[] intRow(int[] expected)

verifyQueryResults

private void verifyQueryResults(java.lang.String assertString,
                                java.lang.String query,
                                java.lang.Object[][] golden)
                         throws java.lang.Exception

Throws:

java.lang.Exception

verifyQueryResults

private void verifyQueryResults(java.lang.String assertString,
                                java.lang.String query,
                                int[][] golden)
                         throws java.lang.Exception

Throws:

java.lang.Exception

assertRow

public void assertRow(java.lang.String assertString,
                      java.sql.ResultSet rs,
                      java.lang.Object[] expectedRow)
               throws java.lang.Exception

Throws:

java.lang.Exception

suite

public static junit.framework.Test suite()