Package org.apache.derbyTesting.functionTests.tests.lang

Class Summary

_Suite	Suite to run all JUnit tests in this package: org.apache.derbyTesting.functionTests.tests.lang All tests are run "as-is", just as if they were run individually.
AggregateClassLoadingTest	Test for ensuring the aggregate implementation classes are loaded correctly, even when the context class loader loads Derby engine classes as well.
AlterColumnTest	Test cases for altering columns.
AlterTableTest
AnsiSignatures	These are methods for testing ANSI routine resolution.
AnsiSignaturesTest	Test that Derby resolves routines according to the ANSI method resolution rules.
AnsiTrimTest	Functional test for ansi trim functionality added for DERBY-1623.
ArithmeticTest	Test case for arithmetic.sql.
BigDataTest	A test case for big.sql.
Bug4356Test	Demonstrate subselect behavior with prepared statement.
Bug5052rtsTest	testing gathering of runtime statistics for for the resultsets/statements not closed by the usee, but get closed when garbage collector collects such objects and closes them by calling the finalize.
Bug5054Test	Where current of cursorname and case sensitivity
CaseExpressionTest
CastingTest
CastingTest.TypedColumn
CharUTF8Test	Test all characters written through the UTF8 format.
CheckConstraintTest
CoalesceTest	Coalesce/Value tests for various datatypes coalesce/value function takes arguments and returns the first argument that is not null.
CollationTest
CollationTest2	Junit test targeted at testing language based Collation.
ColumnDefaultsTest
CommentTest	Test for comments.
CompressTableTest	Test cases for compressing tables.
concateTests	Concatenation tests for various datatypes
ConcurrentImplicitCreateSchema	Test for several threads creating tables in the same originally non-existing schema.
ConglomerateSharingTest	Test for situations in which Derby attempts to "share" physical conglomerates across multiple constraints.
ConnectTest	Test case for connect.sql.
ConstantExpressionTest	Test case for constantExpression.sql, which provides tests for constant expression evaluation.
CreateTableFromQueryTest	Test for creating tables using a query expression.
CurrentOfTest	This tests the current of statements, i.e.
CursorTest	Tests cursors
DatabaseClassLoadingTest	Test database class loading, executing routines from the installed jars including accessing resources.
DateTimeTest	Test the builtin date/time types assumes these builtin types exist: int, smallint, char, varchar, real other things we might test: interaction with UUID and other user defined types compatibility with dynamic parameters and JDBC getDate etc. methods.
DBInJarTest
dbjarUtil	Simple program to archive a database up in a jar file within the test harness.
dbManagerLimits	Test various data manager limits like in db2 here.
DBOperations
DeadlockModeTest	This tests for deadlock which can occur if two threads get a row lock before getting a table lock on the same table.
DeclareGlobalTempTableJavaJDBC30Test	Test for declared global temporary tables (introduced in Cloudscape 5.2) and pooled connection close and jdbc 3.0 specific features The jdbc3.0 specific featuers are holdable cursors, savepoints.
DeclareGlobalTempTableJavaTest	Test for declared global temporary tables introduced in Cloudscape 5.2 The temp table tests with holdable cursor and savepoints are in declareGlobalTempTableJavaJDBC30 class.
DistinctTest	Tests for DISTINCT.
DropTableTest
DummyBinary
DummyReader
DynamicLikeOptimizationTest	Test the dynamic like optimization.
ErrorCodeTest
ErrorMessageTest
ExistsWithSubqueriesTest	This test contains a variety of cases of EXISTS predicates with subqueries.
FloatTypesTest	Test floating point data types.
ForBitDataTest
ForUpdateTest	Tests for forupdate.
FullCollationTests
GeneratedColumnsHelper	Helper routines for testing generated columns.
GeneratedColumnsPermsTest	Test permissions on generated columns.
GeneratedColumnsTest	Test generated columns.
GetPropertyInfoTest
GrantRevokeDDLTest
GrantRevokeTest	Test SQL GRANT and REVOKE statements
GroupByExpressionTest
GroupByTest	Many of these test cases were converted from the old groupBy.sql using the DERBY-2151 SQLToJUnit conversion utility.
HoldCursorTest	Test hold cursor after commit
InbetweenTest
InListMultiProbeTest	Test to verify that Derby will perform "multi-probing" of an index when all of the following are true: 1.
InListMultiProbeTest.DataRow	Helper class: An instance of DataRow represents a single row in DATA_TABLE.
InsertTest	This class contains test cases for the INSERT statement.
IntegerArrayVTI	A VTI which returns a row of ints.
JitTest	DERBY-1327 Identity column can be created with wrong and very large start with value with "J2RE 1.5.0 IBM Windows 32 build pwi32dev-20060412 (SR2)" with JIT on
JoinTest	Test cases for JOINs.
LangHarnessJavaTest	Run a lang '.java' test from the old harness in the Junit infrastructure.
LangProcedureTest	Test the syntax for creating procedures.
LangScripts	LangScripts runs SQL scripts (.sql files) in the lang package and compares the output to a canon file in the standard master package.
largeCodeGen
LazyDefaultSchemaCreationTest	Tests the lazy creation functionality of default schema: the schema is only first created when the first database object is created in the schema.
MathTrigFunctionsTest
maxMemPerTab
MiscErrorsTest	Tests miscellaneous error situations.
MixedCaseExpressionTest	Test case for case.sql.
NestedWhereSubqueryTest	Nested WHERE subquery tests.
NullableUniqueConstraintTest	Test unique constraint
NullIfTest
NullsTest	Test case for nulls.sql.
OffsetFetchNextTest	Test and .
OLAPTest	OLAP functionality test.
OptimizerOverridesTest	Test the optimizer overrides.
OrderByAndSortAvoidance	Tests for DERBY-3926.
outparams
outparams30	outparams30 contains java procedures using java.math.BigDecimal.
PrecedenceTest	Test case for precedence.sql.It tests precedence of operators other than and, or, and not that return boolean.
PredicatePushdownTest
PrepareExecuteDDL	Test the dependency system for active statements when a DDL is executed in a separate connection after the prepare but before the execute.
Price	Sample UDT for tests.
PrimaryKeyTest
ProcedureInTriggerTest
ReferentialActionsTest	This class tests SQL referential actions.
ReleaseCompileLocksTest	Tests for forupdate.
RenameIndexTest
RenameTableTest	Various tests for RENAME TABLE
RestrictedVTITest	Test RestrictedVTIs.
ResultSetsFromPreparedStatementTest	Tests repeated instantiation of internal ResultSet types from PreparedStatements.
RolesConferredPrivilegesTest	This tests that SQL roles actually confer the correct privileges, that is, when privileges are granted to one or more roles and those roles are granted to other roles, to one or more users or to PUBLIC, sessions can make use of them correctly.
RolesTest	This JUnit tests the SQL roles feature.
RoutineSecurityTest	Set of tests that ensure SQL routines implemented in Java are correctly restricted in their actions when a security manager is in place.
RoutineTest	Set of tests for SQL routines.
ScrollCursors1Test
ScrollCursors2Test
SecurityPolicyReloadingTest	Test the dynamic reloading of the security policy file while the engine is still running.
SecurityPolicyReloadingTest.PropReadingAction
SelectivityTest
SequenceTest	Test sequences.
ShutdownDatabase
ShutdownDatabaseTest
SimpleTest
simpleThread
simpleThreadWrapper	Test of strings longer than 64K.
SpillHashTest	Test BackingStoreHashtable spilling to disk.
SQLAuthorizationPropTest
SQLSessionContextTest	SQLSessionContextTest tests the SQL session context stacking, cf.
StalePlansTest	This is the test for stale plan invalidation.
StatementPlanCacheTest	Tests statement plan caching.
StreamsTest	This tests streams, and when we should not materialize it.
StringArrayVTI	This is a concrete VTI which is prepopulated with rows which are just arrays of string columns.
StringArrayVTI.ConstructorException
StringArrayVTI.GoodVTICosting
StringArrayVTI.MissingConstructor
StringArrayVTI.ZeroArgConstructorNotPublic
StringColumnVTI	This is an abstract VTI which assumes that all columns are strings and which coerces the strings to reasonable values for various getXXX() methods.
StringColumnVTI.SimpleBlob	A crude Blob implementation for datatype testing.
StringColumnVTI.SimpleClob	A crude Clob implementation.
SubqueryFlatteningTest	This test verifies that flattening of subqueries works correctly.
SynonymTest	Synonym testing using junit
SysDiagVTIMappingTest
SystemCatalogTest	Tests concerning the system catalogs.
TableFunctionTest	Test Table Functions.
TableVTI	This class has been adapted from org.apache.derby.vti.VTITemplate because we do not want a test to depend on an engine class.
TimeHandlingTest
TimestampArithTest	Test the JDBC TIMESTAMPADD and TIMESTAMPDIFF escape functions.
TriggerTest	Test triggers.
TruncateTableTest	Tests for TRUNCATE TABLE.
UDTTest	Test user defined types.
UnaryArithmeticParameterTest	This tests unary minus and unary plus as dynamic parameters in PreparedStatements.
UngroupedAggregatesNegativeTest	Test case for ungroupedAggregatesNegative.sql.
UniqueConstraintMultiThreadedTest
UniqueConstraintSetNullTest	Test unique constraint
UpdatableResultSetTest	This tests JDBC 2.0 updateable resultset - deleteRow, updateRow, and insertRow API
UpdateCursorTest	This tests updateable cursor using index, Beetle entry 3865.
UpdateStatisticsTest	Tests for updating the statistics of one index or all the indexes on a table DERBY-269, DERBY-3788.
userDefMethods
UserLobTest	Additional tests for Blob/Clobs created from user-supplied large objects.
ViewsTest
VTITest	Add tests that use VTI
WarehouseVTI	Cooked up VTI to test SYSCS_BULK_INSERT
WISCInsert	This class is a VTI for loading data into the Wisconsin benchmark schema.
WiscMetaData	This class gives the metadata for the VTI for loading the Wisconsin benchmark schema.
wisconsin
WiscVTI	This class is a VTI for loading data into the Wisconsin benchmark schema.
XMLBindingTest	This test checks to make sure that the XML data type and the corresponding XML operations all work as expected from the JDBC side of things.
XMLBindingTest.XBindTestSetup	Helper class.
XMLMissingClassesTest	This JUnit test is only run when the test classpath does not contain the external classes required for use of the Derby XML operators--namely, JAXP and Xalan.
XMLTypeAndOpsTest	XMLTypeAndOpsTest this test is the JUnit equivalent to what used to be the "lang/xml_general.sql" test, which was canon-based.
XMLTypeAndOpsTest.XMLTestSetup	Wrapper for the tests in XMLTypeAndOpsTest.
XplainStatisticsTest	This suite contains a set of tests for the new XPLAIN style of runtime statistics capturing which was added as part of DERBY-2487.