public class GroupByExpressionTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String[] |
FUNCTIONS |
private static java.lang.String[] |
TABLES |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
GroupByExpressionTest(java.lang.String name) |
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) |
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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
private static java.lang.String[] TABLES
private static java.lang.String[] FUNCTIONS
public void testSimpleExpressions() throws java.lang.Exception
java.lang.Exception
public void testDerby4402AggregateInGroupBy() throws java.lang.Exception
java.lang.Exception
public void testDerby3094Expressions() throws java.lang.Exception
java.lang.Exception
public void testSubSelect() throws java.lang.Exception
java.lang.Exception
public void testMiscExpressions() throws java.lang.Exception
java.lang.Exception
public void testExtractOperator() throws java.lang.Exception
java.lang.Exception
public void testDuplicateColumns() throws java.lang.Exception
java.lang.Exception
public void testNegative()
private java.lang.Object[] intRow(int[] expected)
private void verifyQueryResults(java.lang.String assertString, java.lang.String query, java.lang.Object[][] golden) throws java.lang.Exception
java.lang.Exception
private void verifyQueryResults(java.lang.String assertString, java.lang.String query, int[][] golden) throws java.lang.Exception
java.lang.Exception
public void assertRow(java.lang.String assertString, java.sql.ResultSet rs, java.lang.Object[] expectedRow) throws java.lang.Exception
java.lang.Exception
public static junit.framework.Test suite()
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.