# Package org.h2.test.db

Database tests.

See: Description

Class Summary
Class | Description
--- | ---
AbstractBaseForCommonTableExpressions | Base class for common table expression tests
Db | A simple wrapper around the JDBC API.
Db.Prepared | This class represents a prepared statement.
TaskDef | A task that can be run as a separate process.
TaskProcess | A task that is run as an external process.
TestAlter | Test ALTER statements.
TestAlterSchemaRename | Test ALTER SCHEMA RENAME statements.
TestAnalyzeTableTx |
TestAutoRecompile | Tests if prepared statements are re-compiled when required.
TestBackup | Test for the BACKUP SQL statement.
TestBackup.BackupListener | A backup listener to test concurrent backup.
TestBigDb | Test for big databases.
TestBigResult | Test for big result sets.
TestCases | Various test cases.
TestCheckpoint | Tests the CHECKPOINT SQL statement.
TestCluster | Test the cluster feature.
TestCompatibility | Tests the compatibility with other databases.
TestCompatibilityOracle | Test Oracle compatibility mode.
TestCompatibilitySQLServer | Test MSSQLServer compatibility mode.
TestCsv | CSVREAD and CSVWRITE tests.
TestDateStorage | Tests the date transfer and storage.
TestDeadlock | Test for deadlocks in the code, and test the deadlock detection mechanism.
TestDrop | Test DROP statement
TestDuplicateKeyUpdate | Tests for the ON DUPLICATE KEY UPDATE in the Insert class.
TestEncryptedDb | Test using an encrypted database.
TestExclusive | Test for the exclusive mode.
TestFullText | Fulltext search tests.
TestFunctionOverload | Tests for overloaded user defined functions.
TestFunctions | Tests for user defined functions and aggregates.
TestFunctions.MedianString | This median implementation keeps all objects in memory.
TestFunctions.MedianStringType | This median implementation keeps all objects in memory.
TestGeneralCommonTableQueries | Test non-recursive queries using WITH, but more than one common table defined.
TestIndex | Index tests.
TestIndexHints | Tests the index hints feature of this database.
TestLargeBlob | Test a BLOB larger than Integer.MAX_VALUE
TestLinkedTable | Tests the linked table feature (CREATE LINKED TABLE).
TestLIRSMemoryConsumption | Class TestLIRSMemoryConsumption.
TestListener | Tests the DatabaseEventListener.
TestLob | Tests LOB and CLOB data types.
TestMemoryUsage | Tests the memory usage of the cache.
TestMergeUsing | Test merge using syntax.
TestMultiConn | Multi-connection tests.
TestMultiConn.MyDatabaseEventListener | A database event listener used in this test.
TestMultiDimension | Tests the multi-dimension index tool.
TestMultiThread | Multi-threaded tests.
TestMultiThreadedKernel | A multi-threaded test case.
TestOpenClose | Tests opening and closing a database.
TestOpenClose.MyDatabaseEventListener | A database event listener used in this test.
TestOptimizations | Test various optimizations (query cache, optimization for MIN(..), and MAX(..)).
TestOptimizerHints | Test for optimizer hint SET FORCE_JOIN_ORDER.
TestOutOfMemory | Tests out of memory situations.
TestOutOfMemory.MyChild |
TestPersistentCommonTableExpressions | Test persistent common table expressions queries using WITH.
TestPowerOff | Tests simulated power off conditions.
TestQueryCache | Tests the query cache.
TestReadOnly | Test for the read-only database feature.
TestRecursiveQueries | Test recursive queries using WITH.
TestRights | Access rights tests.
TestRowFactory | Test `RowFactory` setting.
TestRowFactory.MyTestRowFactory | Test row factory.
TestRunscript | Tests the RUNSCRIPT SQL statement.
TestSelectCountNonNullColumn | Test that count(column) is converted to count(*) if the column is not nullable.
TestSequence | Tests the sequence feature of this database.
TestSequence.TriggerTest | A test trigger.
TestSessionsLocks | Tests the meta data tables information_schema.locks and sessions.
TestSetCollation |
TestSpaceReuse | Tests if disk space is reused after deleting many rows.
TestSpatial | Spatial datatype and index tests.
TestSpatial.TableEnvelope | An aggregate function that calculates the envelope.
TestSpeed | Various small performance tests.
TestSQLInjection | Tests the ALLOW_LITERALS feature (protection against SQL injection).
TestSubqueryPerformanceOnLazyExecutionMode | Test subquery performance with lazy query execution mode `SetTypes.LAZY_QUERY_EXECUTION`.
TestSynonymForTable | Tests for table synonyms.
TestTableEngines | The class for external table engines mechanism testing.
TestTableEngines.AffinityTableEngine | A test table factory producing affinity aware tables.
TestTableEngines.EndlessTableEngine | A test table factory.
TestTableEngines.OneRowTableEngine | A test table factory.
TestTableEngines.TreeSetIndexTableEngine | A table engine that internally uses a tree set.
TestTempTables | Temporary table tests.
TestTransaction | Transactional tests, including transaction isolation tests, and tests related to savepoints.
TestTriggersConstraints | Tests for trigger and constraints.
TestTriggersConstraints.DeleteTrigger | A trigger that deletes all rows in the test table.
TestTriggersConstraints.TestSelect | A test trigger implementation.
TestTriggersConstraints.TestTriggerAdapter | A test trigger adapter implementation.
TestTriggersConstraints.TestTriggerAlterTable | A test trigger implementation.
TestTriggersConstraints.TestView | A test trigger implementation.
TestTriggersConstraints.TestViewGeneratedKeys |
TestTwoPhaseCommit | Tests for the two-phase-commit feature.
TestUpgrade | Automatic upgrade test cases.
TestUsingIndex | Tests the "create index ...
TestView | Test for views.
TestViewAlterTable | Test the impact of ALTER TABLE statements on views.
TestViewDropView | Test the impact of DROP VIEW statements on dependent views.

## Package org.h2.test.db Description

Database tests. Most tests are on the SQL level.