Package org.h2.test.db

Database tests. Most tests are on the SQL level.

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.
TestAlterTableNotFound
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.
TestClearCacheAfterDdl	Tests for clearing query ache after DDL execution: After executing DDL that invalidates previously cached queries, re-executing the same SQL should fail.
TestCluster	Test the cluster feature.
TestCompatibility	Tests the compatibility with other databases.
TestCompatibilityOracle	Test Oracle compatibility mode.
TestCompatibilitySQLServer	Test MSSQLServer compatibility mode.
TestCompoundIndexParamSearch	Test various queries with hardcoded, and prepared statement parameters.
TestCompoundIndexSearch	Test various queries against compound indexes.
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.
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.
TestIgnoreCatalogs
TestIndex	Index tests.
TestIndexHints	Tests the index hints feature of this database.
TestIssue_3040
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.
TestMaterializedView	Tests for MATERIALIZED VIEW.
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(..)).
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.
TestRights.TestTrigger
TestRunscript	Tests the RUNSCRIPT SQL statement.
TestSelectTableNotFound
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.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.ConcurrentTrigger
TestTriggersConstraints.DeleteTrigger	A trigger that deletes all rows in the test table.
TestTriggersConstraints.NullTrigger	Trigger that sets null value.
TestTriggersConstraints.NullTriggerAdapter	Trigger that sets null value.
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
TestTriggersConstraints.WrongTrigger	Trigger that sets value of the wrong data type.
TestTriggersConstraints.WrongTriggerAdapter	Trigger that sets value of the wrong data type.
TestTwoPhaseCommit	Tests for the two-phase-commit feature.
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.