# Package org.h2.test.db

package org.h2.test.db
Database tests. Most tests are on the SQL level.

Classes
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.