Example 1 with TestFunctions
use of org.h2.test.db.TestFunctions in project h2database by h2database.
the class TestFunctions method testFunctions.
private void testFunctions() throws SQLException {
deleteDb("functions");
Connection conn = getConnection("functions");
Statement stat = conn.createStatement();
assertCallResult(null, stat, "abs(null)");
assertCallResult("1", stat, "abs(1)");
assertCallResult("1", stat, "abs(1)");
stat.execute("CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR)");
stat.execute("CREATE ALIAS ADD_ROW FOR \"" + getClass().getName() + ".addRow\"");
ResultSet rs;
rs = stat.executeQuery("CALL ADD_ROW(1, 'Hello')");
rs.next();
assertEquals(1, rs.getInt(1));
rs = stat.executeQuery("SELECT * FROM TEST");
rs.next();
assertEquals(1, rs.getInt(1));
assertEquals("Hello", rs.getString(2));
assertFalse(rs.next());
DatabaseMetaData meta = conn.getMetaData();
rs = meta.getProcedureColumns(null, null, "ADD_ROW", null);
assertTrue(rs.next());
assertEquals("P0", rs.getString("COLUMN_NAME"));
assertTrue(rs.next());
assertEquals("FUNCTIONS", rs.getString("PROCEDURE_CAT"));
assertEquals("PUBLIC", rs.getString("PROCEDURE_SCHEM"));
assertEquals("ADD_ROW", rs.getString("PROCEDURE_NAME"));
assertEquals("P2", rs.getString("COLUMN_NAME"));
assertEquals(DatabaseMetaData.procedureColumnIn, rs.getInt("COLUMN_TYPE"));
assertEquals("INTEGER", rs.getString("TYPE_NAME"));
assertEquals(10, rs.getInt("PRECISION"));
assertEquals(10, rs.getInt("LENGTH"));
assertEquals(0, rs.getInt("SCALE"));
assertEquals(DatabaseMetaData.columnNoNulls, rs.getInt("NULLABLE"));
assertEquals("", rs.getString("REMARKS"));
assertEquals(null, rs.getString("COLUMN_DEF"));
assertEquals(0, rs.getInt("SQL_DATA_TYPE"));
assertEquals(0, rs.getInt("SQL_DATETIME_SUB"));
assertEquals(0, rs.getInt("CHAR_OCTET_LENGTH"));
assertEquals(1, rs.getInt("ORDINAL_POSITION"));
assertEquals("YES", rs.getString("IS_NULLABLE"));
assertEquals("ADD_ROW", rs.getString("SPECIFIC_NAME"));
assertTrue(rs.next());
assertEquals("P3", rs.getString("COLUMN_NAME"));
assertEquals("VARCHAR", rs.getString("TYPE_NAME"));
assertFalse(rs.next());
stat.executeQuery("CALL ADD_ROW(2, 'World')");
stat.execute("CREATE ALIAS SELECT_F FOR \"" + getClass().getName() + ".select\"");
rs = stat.executeQuery("CALL SELECT_F('SELECT * " + "FROM TEST ORDER BY ID')");
assertEquals(2, rs.getMetaData().getColumnCount());
rs.next();
assertEquals(1, rs.getInt(1));
assertEquals("Hello", rs.getString(2));
rs.next();
assertEquals(2, rs.getInt(1));
assertEquals("World", rs.getString(2));
assertFalse(rs.next());
rs = stat.executeQuery("SELECT NAME FROM SELECT_F('SELECT * " + "FROM TEST ORDER BY NAME') ORDER BY NAME DESC");
assertEquals(1, rs.getMetaData().getColumnCount());
rs.next();
assertEquals("World", rs.getString(1));
rs.next();
assertEquals("Hello", rs.getString(1));
assertFalse(rs.next());
rs = stat.executeQuery("SELECT SELECT_F('SELECT * " + "FROM TEST WHERE ID=' || ID) FROM TEST ORDER BY ID");
assertEquals(1, rs.getMetaData().getColumnCount());
rs.next();
assertEquals("((1, Hello))", rs.getString(1));
rs.next();
assertEquals("((2, World))", rs.getString(1));
assertFalse(rs.next());
rs = stat.executeQuery("SELECT SELECT_F('SELECT * " + "FROM TEST ORDER BY ID') FROM DUAL");
assertEquals(1, rs.getMetaData().getColumnCount());
rs.next();
assertEquals("((1, Hello), (2, World))", rs.getString(1));
assertFalse(rs.next());
assertThrows(ErrorCode.SYNTAX_ERROR_2, stat).executeQuery("CALL SELECT_F('ERROR')");
stat.execute("CREATE ALIAS SIMPLE FOR \"" + getClass().getName() + ".simpleResultSet\"");
rs = stat.executeQuery("CALL SIMPLE(2, 1, 1, 1, 1, 1, 1, 1)");
assertEquals(2, rs.getMetaData().getColumnCount());
rs.next();
assertEquals(0, rs.getInt(1));
assertEquals("Hello", rs.getString(2));
rs.next();
assertEquals(1, rs.getInt(1));
assertEquals("World", rs.getString(2));
assertFalse(rs.next());
rs = stat.executeQuery("SELECT * FROM SIMPLE(1, 1, 1, 1, 1, 1, 1, 1)");
assertEquals(2, rs.getMetaData().getColumnCount());
rs.next();
assertEquals(0, rs.getInt(1));
assertEquals("Hello", rs.getString(2));
assertFalse(rs.next());
stat.execute("CREATE ALIAS ARRAY FOR \"" + getClass().getName() + ".getArray\"");
rs = stat.executeQuery("CALL ARRAY()");
assertEquals(1, rs.getMetaData().getColumnCount());
rs.next();
Array a = rs.getArray(1);
Object[] array = (Object[]) a.getArray();
assertEquals(2, array.length);
assertEquals(0, ((Integer) array[0]).intValue());
assertEquals("Hello", (String) array[1]);
assertThrows(ErrorCode.INVALID_VALUE_2, a).getArray(1, -1);
assertThrows(ErrorCode.INVALID_VALUE_2, a).getArray(1, 3);
assertEquals(0, ((Object[]) a.getArray(1, 0)).length);
assertEquals(0, ((Object[]) a.getArray(2, 0)).length);
assertThrows(ErrorCode.INVALID_VALUE_2, a).getArray(0, 0);
assertThrows(ErrorCode.INVALID_VALUE_2, a).getArray(3, 0);
HashMap<String, Class<?>> map = new HashMap<>();
assertEquals(0, ((Object[]) a.getArray(1, 0, map)).length);
assertEquals(2, ((Object[]) a.getArray(map)).length);
assertEquals(2, ((Object[]) a.getArray(null)).length);
map.put("x", Object.class);
assertThrows(ErrorCode.FEATURE_NOT_SUPPORTED_1, a).getArray(1, 0, map);
assertThrows(ErrorCode.FEATURE_NOT_SUPPORTED_1, a).getArray(map);
ResultSet rs2;
rs2 = a.getResultSet();
rs2.next();
assertEquals(1, rs2.getInt(1));
assertEquals(0, rs2.getInt(2));
rs2.next();
assertEquals(2, rs2.getInt(1));
assertEquals("Hello", rs2.getString(2));
assertFalse(rs.next());
map.clear();
rs2 = a.getResultSet(map);
rs2.next();
assertEquals(1, rs2.getInt(1));
assertEquals(0, rs2.getInt(2));
rs2.next();
assertEquals(2, rs2.getInt(1));
assertEquals("Hello", rs2.getString(2));
assertFalse(rs.next());
rs2 = a.getResultSet(2, 1);
rs2.next();
assertEquals(2, rs2.getInt(1));
assertEquals("Hello", rs2.getString(2));
assertFalse(rs.next());
rs2 = a.getResultSet(1, 1, map);
rs2.next();
assertEquals(1, rs2.getInt(1));
assertEquals(0, rs2.getInt(2));
assertFalse(rs.next());
map.put("x", Object.class);
assertThrows(ErrorCode.FEATURE_NOT_SUPPORTED_1, a).getResultSet(map);
assertThrows(ErrorCode.FEATURE_NOT_SUPPORTED_1, a).getResultSet(0, 1, map);
a.free();
assertThrows(ErrorCode.OBJECT_CLOSED, a).getArray();
assertThrows(ErrorCode.OBJECT_CLOSED, a).getResultSet();
stat.execute("CREATE ALIAS ROOT FOR \"" + getClass().getName() + ".root\"");
rs = stat.executeQuery("CALL ROOT(9)");
rs.next();
assertEquals(3, rs.getInt(1));
assertFalse(rs.next());
stat.execute("CREATE ALIAS MAX_ID FOR \"" + getClass().getName() + ".selectMaxId\"");
rs = stat.executeQuery("CALL MAX_ID()");
rs.next();
assertEquals(2, rs.getInt(1));
assertFalse(rs.next());
rs = stat.executeQuery("SELECT * FROM MAX_ID()");
rs.next();
assertEquals(2, rs.getInt(1));
assertFalse(rs.next());
rs = stat.executeQuery("CALL CASE WHEN -9 < 0 THEN 0 ELSE ROOT(-9) END");
rs.next();
assertEquals(0, rs.getInt(1));
assertFalse(rs.next());
stat.execute("CREATE ALIAS blob FOR \"" + getClass().getName() + ".blob\"");
rs = stat.executeQuery("SELECT blob(CAST('0102' AS BLOB)) FROM DUAL");
while (rs.next()) {
// ignore
}
rs.close();
stat.execute("CREATE ALIAS clob FOR \"" + getClass().getName() + ".clob\"");
rs = stat.executeQuery("SELECT clob(CAST('Hello' AS CLOB)) FROM DUAL");
while (rs.next()) {
// ignore
}
rs.close();
stat.execute("create alias sql as " + "'ResultSet sql(Connection conn, String sql) " + "throws SQLException { return conn.createStatement().executeQuery(sql); }'");
rs = stat.executeQuery("select * from sql('select cast(''Hello'' as clob)')");
assertTrue(rs.next());
assertEquals("Hello", rs.getString(1));
rs = stat.executeQuery("select * from sql('select cast(''4869'' as blob)')");
assertTrue(rs.next());
assertEquals("Hi", new String(rs.getBytes(1)));
rs = stat.executeQuery("select sql('select 1 a, ''Hello'' b')");
assertTrue(rs.next());
rs2 = (ResultSet) rs.getObject(1);
rs2.next();
assertEquals(1, rs2.getInt(1));
assertEquals("Hello", rs2.getString(2));
ResultSetMetaData meta2 = rs2.getMetaData();
assertEquals(Types.INTEGER, meta2.getColumnType(1));
assertEquals("INTEGER", meta2.getColumnTypeName(1));
assertEquals("java.lang.Integer", meta2.getColumnClassName(1));
assertEquals(Types.VARCHAR, meta2.getColumnType(2));
assertEquals("VARCHAR", meta2.getColumnTypeName(2));
assertEquals("java.lang.String", meta2.getColumnClassName(2));
stat.execute("CREATE ALIAS blob2stream FOR \"" + getClass().getName() + ".blob2stream\"");
stat.execute("CREATE ALIAS stream2stream FOR \"" + getClass().getName() + ".stream2stream\"");
stat.execute("CREATE TABLE TEST_BLOB(ID INT PRIMARY KEY, VALUE BLOB)");
stat.execute("INSERT INTO TEST_BLOB VALUES(0, null)");
stat.execute("INSERT INTO TEST_BLOB VALUES(1, 'edd1f011edd1f011edd1f011')");
rs = stat.executeQuery("SELECT blob2stream(VALUE) FROM TEST_BLOB");
while (rs.next()) {
// ignore
}
rs.close();
rs = stat.executeQuery("SELECT stream2stream(VALUE) FROM TEST_BLOB");
while (rs.next()) {
// ignore
}
stat.execute("CREATE ALIAS NULL_RESULT FOR \"" + getClass().getName() + ".nullResultSet\"");
rs = stat.executeQuery("CALL NULL_RESULT()");
assertEquals(1, rs.getMetaData().getColumnCount());
rs.next();
assertEquals(null, rs.getString(1));
assertFalse(rs.next());
rs = meta.getProcedures(null, null, "NULL_RESULT");
rs.next();
assertEquals("FUNCTIONS", rs.getString("PROCEDURE_CAT"));
assertEquals("PUBLIC", rs.getString("PROCEDURE_SCHEM"));
assertEquals("NULL_RESULT", rs.getString("PROCEDURE_NAME"));
assertEquals(0, rs.getInt("NUM_INPUT_PARAMS"));
assertEquals(0, rs.getInt("NUM_OUTPUT_PARAMS"));
assertEquals(0, rs.getInt("NUM_RESULT_SETS"));
assertEquals("", rs.getString("REMARKS"));
assertEquals(DatabaseMetaData.procedureReturnsResult, rs.getInt("PROCEDURE_TYPE"));
assertEquals("NULL_RESULT", rs.getString("SPECIFIC_NAME"));
rs = meta.getProcedureColumns(null, null, "NULL_RESULT", null);
assertTrue(rs.next());
assertEquals("P0", rs.getString("COLUMN_NAME"));
assertFalse(rs.next());
stat.execute("CREATE ALIAS RESULT_WITH_NULL FOR \"" + getClass().getName() + ".resultSetWithNull\"");
rs = stat.executeQuery("CALL RESULT_WITH_NULL()");
assertEquals(1, rs.getMetaData().getColumnCount());
rs.next();
assertEquals(null, rs.getString(1));
assertFalse(rs.next());
conn.close();
}
Also used :
Array(java.sql.Array)
ResultSetMetaData(java.sql.ResultSetMetaData)
HashMap(java.util.HashMap)
PreparedStatement(java.sql.PreparedStatement)
CallableStatement(java.sql.CallableStatement)
Statement(java.sql.Statement)
Connection(java.sql.Connection)
ResultSet(java.sql.ResultSet)
SimpleResultSet(org.h2.tools.SimpleResultSet)
DatabaseMetaData(java.sql.DatabaseMetaData)
Example 2 with TestFunctions
use of org.h2.test.db.TestFunctions in project h2database by h2database.
the class TestAll method test.
/**
* Run all tests with the current settings.
*/
private void test() throws SQLException {
System.out.println();
System.out.println("Test " + toString() + " (" + Utils.getMemoryUsed() + " KB used)");
beforeTest();
// db
addTest(new TestScriptSimple());
addTest(new TestScript());
addTest(new TestAlter());
addTest(new TestAlterSchemaRename());
addTest(new TestAutoRecompile());
addTest(new TestBackup());
addTest(new TestBigDb());
addTest(new TestBigResult());
addTest(new TestCases());
addTest(new TestCheckpoint());
addTest(new TestCompatibility());
addTest(new TestCompatibilityOracle());
addTest(new TestCsv());
addTest(new TestDeadlock());
if (vmlens) {
return;
}
addTest(new TestDrop());
addTest(new TestDuplicateKeyUpdate());
addTest(new TestEncryptedDb());
addTest(new TestExclusive());
addTest(new TestFullText());
addTest(new TestFunctionOverload());
addTest(new TestFunctions());
addTest(new TestInit());
addTest(new TestIndex());
addTest(new TestIndexHints());
addTest(new TestLargeBlob());
addTest(new TestLinkedTable());
addTest(new TestListener());
addTest(new TestLob());
addTest(new TestMergeUsing());
addTest(new TestMultiConn());
addTest(new TestMultiDimension());
addTest(new TestMultiThreadedKernel());
addTest(new TestOpenClose());
addTest(new TestOptimizations());
addTest(new TestOptimizerHints());
addTest(new TestOutOfMemory());
addTest(new TestReadOnly());
addTest(new TestRecursiveQueries());
addTest(new TestGeneralCommonTableQueries());
if (!memory) {
// requires persistent store for reconnection tests
addTest(new TestPersistentCommonTableExpressions());
}
addTest(new TestRights());
addTest(new TestRunscript());
addTest(new TestSQLInjection());
addTest(new TestSessionsLocks());
addTest(new TestSelectCountNonNullColumn());
addTest(new TestSequence());
addTest(new TestShow());
addTest(new TestSpaceReuse());
addTest(new TestSpatial());
addTest(new TestSpeed());
addTest(new TestTableEngines());
addTest(new TestRowFactory());
addTest(new TestTempTables());
addTest(new TestTransaction());
addTest(new TestTriggersConstraints());
addTest(new TestTwoPhaseCommit());
addTest(new TestView());
addTest(new TestViewAlterTable());
addTest(new TestViewDropView());
addTest(new TestReplace());
addTest(new TestSynonymForTable());
addTest(new TestColumnNamer());
// jaqu
addTest(new AliasMapTest());
addTest(new AnnotationsTest());
addTest(new ClobTest());
addTest(new ModelsTest());
addTest(new SamplesTest());
addTest(new UpdateTest());
// jdbc
addTest(new TestBatchUpdates());
addTest(new TestCallableStatement());
addTest(new TestCancel());
addTest(new TestConcurrentConnectionUsage());
addTest(new TestConnection());
addTest(new TestDatabaseEventListener());
addTest(new TestJavaObject());
addTest(new TestLimitUpdates());
addTest(new TestLobApi());
addTest(new TestManyJdbcObjects());
addTest(new TestMetaData());
addTest(new TestNativeSQL());
addTest(new TestPreparedStatement());
addTest(new TestResultSet());
addTest(new TestStatement());
addTest(new TestGetGeneratedKeys());
addTest(new TestTransactionIsolation());
addTest(new TestUpdatableResultSet());
addTest(new TestZloty());
addTest(new TestCustomDataTypesHandler());
addTest(new TestSetCollation());
// jdbcx
addTest(new TestConnectionPool());
addTest(new TestDataSource());
addTest(new TestXA());
addTest(new TestXASimple());
// server
addTest(new TestAutoServer());
addTest(new TestNestedLoop());
// mvcc & row level locking
addTest(new TestMvcc1());
addTest(new TestMvcc2());
addTest(new TestMvcc3());
addTest(new TestMvcc4());
addTest(new TestMvccMultiThreaded());
addTest(new TestMvccMultiThreaded2());
addTest(new TestRowLocks());
// synth
addTest(new TestBtreeIndex());
addTest(new TestConcurrentUpdate());
addTest(new TestDiskFull());
addTest(new TestCrashAPI());
addTest(new TestFuzzOptimizations());
addTest(new TestLimit());
addTest(new TestRandomCompare());
addTest(new TestKillRestart());
addTest(new TestKillRestartMulti());
addTest(new TestMultiThreaded());
addTest(new TestOuterJoins());
addTest(new TestNestedJoins());
addTest(new TestStringAggCompatibility());
runAddedTests();
// serial
addTest(new TestDateStorage());
addTest(new TestDriver());
addTest(new TestJavaObjectSerializer());
addTest(new TestLocale());
addTest(new TestMemoryUsage());
addTest(new TestMultiThread());
addTest(new TestPowerOff());
addTest(new TestReorderWrites());
addTest(new TestRandomSQL());
addTest(new TestQueryCache());
addTest(new TestUrlJavaObjectSerializer());
addTest(new TestWeb());
runAddedTests(1);
afterTest();
}
Also used :
TestDuplicateKeyUpdate(org.h2.test.db.TestDuplicateKeyUpdate)
TestDeadlock(org.h2.test.db.TestDeadlock)
TestPreparedStatement(org.h2.test.jdbc.TestPreparedStatement)
TestXA(org.h2.test.jdbcx.TestXA)
TestTransactionIsolation(org.h2.test.jdbc.TestTransactionIsolation)
TestViewDropView(org.h2.test.db.TestViewDropView)
TestRandomCompare(org.h2.test.synth.TestRandomCompare)
TestSetCollation(org.h2.test.db.TestSetCollation)
TestSelectCountNonNullColumn(org.h2.test.db.TestSelectCountNonNullColumn)
TestConcurrentConnectionUsage(org.h2.test.jdbc.TestConcurrentConnectionUsage)
TestCompatibility(org.h2.test.db.TestCompatibility)
TestUpdatableResultSet(org.h2.test.jdbc.TestUpdatableResultSet)
TestMvccMultiThreaded(org.h2.test.mvcc.TestMvccMultiThreaded)
TestDatabaseEventListener(org.h2.test.jdbc.TestDatabaseEventListener)
TestCheckpoint(org.h2.test.db.TestCheckpoint)
TestListener(org.h2.test.db.TestListener)
TestCustomDataTypesHandler(org.h2.test.jdbc.TestCustomDataTypesHandler)
TestOpenClose(org.h2.test.db.TestOpenClose)
TestEncryptedDb(org.h2.test.db.TestEncryptedDb)
TestExclusive(org.h2.test.db.TestExclusive)
TestViewAlterTable(org.h2.test.db.TestViewAlterTable)
TestGetGeneratedKeys(org.h2.test.jdbc.TestGetGeneratedKeys)
TestFunctions(org.h2.test.db.TestFunctions)
TestManyJdbcObjects(org.h2.test.jdbc.TestManyJdbcObjects)
TestLobApi(org.h2.test.jdbc.TestLobApi)
TestLocale(org.h2.test.unit.TestLocale)
TestLimit(org.h2.test.synth.TestLimit)
TestDataSource(org.h2.test.jdbcx.TestDataSource)
TestTransaction(org.h2.test.db.TestTransaction)
TestJavaObject(org.h2.test.jdbc.TestJavaObject)
TestRowLocks(org.h2.test.rowlock.TestRowLocks)
TestWeb(org.h2.test.server.TestWeb)
TestAutoServer(org.h2.test.server.TestAutoServer)
TestNestedLoop(org.h2.test.server.TestNestedLoop)
TestMultiDimension(org.h2.test.db.TestMultiDimension)
UpdateTest(org.h2.test.jaqu.UpdateTest)
TestCases(org.h2.test.db.TestCases)
TestJavaObjectSerializer(org.h2.test.jdbc.TestJavaObjectSerializer)
TestUrlJavaObjectSerializer(org.h2.test.jdbc.TestUrlJavaObjectSerializer)
TestMultiThread(org.h2.test.db.TestMultiThread)
TestLob(org.h2.test.db.TestLob)
TestFuzzOptimizations(org.h2.test.synth.TestFuzzOptimizations)
TestRunscript(org.h2.test.db.TestRunscript)
TestTableEngines(org.h2.test.db.TestTableEngines)
TestMemoryUsage(org.h2.test.db.TestMemoryUsage)
TestConnection(org.h2.test.jdbc.TestConnection)
TestRandomSQL(org.h2.test.synth.TestRandomSQL)
TestRights(org.h2.test.db.TestRights)
TestXASimple(org.h2.test.jdbcx.TestXASimple)
TestLargeBlob(org.h2.test.db.TestLargeBlob)
TestBatchUpdates(org.h2.test.jdbc.TestBatchUpdates)
TestStringAggCompatibility(org.h2.test.synth.TestStringAggCompatibility)
TestMvccMultiThreaded2(org.h2.test.mvcc.TestMvccMultiThreaded2)
TestSequence(org.h2.test.db.TestSequence)
AliasMapTest(org.h2.test.jaqu.AliasMapTest)
TestMergeUsing(org.h2.test.db.TestMergeUsing)
TestMetaData(org.h2.test.jdbc.TestMetaData)
TestMultiThreadedKernel(org.h2.test.db.TestMultiThreadedKernel)
TestConcurrentUpdate(org.h2.test.synth.TestConcurrentUpdate)
TestResultSet(org.h2.test.jdbc.TestResultSet)
ModelsTest(org.h2.test.jaqu.ModelsTest)
TestSpaceReuse(org.h2.test.db.TestSpaceReuse)
TestDriver(org.h2.test.jdbc.TestDriver)
TestGeneralCommonTableQueries(org.h2.test.db.TestGeneralCommonTableQueries)
TestBigDb(org.h2.test.db.TestBigDb)
TestOutOfMemory(org.h2.test.db.TestOutOfMemory)
TestFunctionOverload(org.h2.test.db.TestFunctionOverload)
TestPowerOff(org.h2.test.db.TestPowerOff)
TestPersistentCommonTableExpressions(org.h2.test.db.TestPersistentCommonTableExpressions)
TestKillRestartMulti(org.h2.test.synth.TestKillRestartMulti)
TestBtreeIndex(org.h2.test.synth.TestBtreeIndex)
TestOptimizations(org.h2.test.db.TestOptimizations)
TestMultiThreaded(org.h2.test.synth.TestMultiThreaded)
TestLinkedTable(org.h2.test.db.TestLinkedTable)
TestTriggersConstraints(org.h2.test.db.TestTriggersConstraints)
SamplesTest(org.h2.test.jaqu.SamplesTest)
TestSynonymForTable(org.h2.test.db.TestSynonymForTable)
TestReadOnly(org.h2.test.db.TestReadOnly)
TestCompatibilityOracle(org.h2.test.db.TestCompatibilityOracle)
TestInit(org.h2.test.server.TestInit)
TestCsv(org.h2.test.db.TestCsv)
TestFullText(org.h2.test.db.TestFullText)
TestIndexHints(org.h2.test.db.TestIndexHints)
AnnotationsTest(org.h2.test.jaqu.AnnotationsTest)
TestDiskFull(org.h2.test.synth.TestDiskFull)
TestStatement(org.h2.test.jdbc.TestStatement)
TestReplace(org.h2.test.db.TestReplace)
TestScriptSimple(org.h2.test.scripts.TestScriptSimple)
TestTwoPhaseCommit(org.h2.test.db.TestTwoPhaseCommit)
TestSessionsLocks(org.h2.test.db.TestSessionsLocks)
TestIndex(org.h2.test.db.TestIndex)
TestOuterJoins(org.h2.test.synth.TestOuterJoins)
TestAlterSchemaRename(org.h2.test.db.TestAlterSchemaRename)
TestBackup(org.h2.test.db.TestBackup)
TestAutoRecompile(org.h2.test.db.TestAutoRecompile)
TestShow(org.h2.test.db.TestShow)
TestSQLInjection(org.h2.test.db.TestSQLInjection)
TestDrop(org.h2.test.db.TestDrop)
TestConnectionPool(org.h2.test.jdbcx.TestConnectionPool)
TestCancel(org.h2.test.jdbc.TestCancel)
TestScript(org.h2.test.scripts.TestScript)
TestCrashAPI(org.h2.test.synth.TestCrashAPI)
TestRecursiveQueries(org.h2.test.db.TestRecursiveQueries)
TestKillRestart(org.h2.test.synth.TestKillRestart)
TestBigResult(org.h2.test.db.TestBigResult)
ClobTest(org.h2.test.jaqu.ClobTest)
TestNestedJoins(org.h2.test.synth.TestNestedJoins)
TestRowFactory(org.h2.test.db.TestRowFactory)
TestCallableStatement(org.h2.test.jdbc.TestCallableStatement)
TestNativeSQL(org.h2.test.jdbc.TestNativeSQL)
TestSpeed(org.h2.test.db.TestSpeed)
TestTempTables(org.h2.test.db.TestTempTables)
TestZloty(org.h2.test.jdbc.TestZloty)
TestMultiConn(org.h2.test.db.TestMultiConn)
TestMvcc3(org.h2.test.mvcc.TestMvcc3)
TestMvcc4(org.h2.test.mvcc.TestMvcc4)
TestMvcc1(org.h2.test.mvcc.TestMvcc1)
TestSpatial(org.h2.test.db.TestSpatial)
TestMvcc2(org.h2.test.mvcc.TestMvcc2)
TestQueryCache(org.h2.test.db.TestQueryCache)
TestAlter(org.h2.test.db.TestAlter)
TestDateStorage(org.h2.test.db.TestDateStorage)
TestColumnNamer(org.h2.test.utils.TestColumnNamer)
TestLimitUpdates(org.h2.test.jdbc.TestLimitUpdates)
TestReorderWrites(org.h2.test.poweroff.TestReorderWrites)
TestView(org.h2.test.db.TestView)
TestOptimizerHints(org.h2.test.db.TestOptimizerHints)
Aggregations
Array (java.sql.Array)1
CallableStatement (java.sql.CallableStatement)1
Connection (java.sql.Connection)1
DatabaseMetaData (java.sql.DatabaseMetaData)1
PreparedStatement (java.sql.PreparedStatement)1
ResultSet (java.sql.ResultSet)1
ResultSetMetaData (java.sql.ResultSetMetaData)1
Statement (java.sql.Statement)1
HashMap (java.util.HashMap)1
TestAlter (org.h2.test.db.TestAlter)1
TestAlterSchemaRename (org.h2.test.db.TestAlterSchemaRename)1
TestAutoRecompile (org.h2.test.db.TestAutoRecompile)1
TestBackup (org.h2.test.db.TestBackup)1
TestBigDb (org.h2.test.db.TestBigDb)1
TestBigResult (org.h2.test.db.TestBigResult)1
TestCases (org.h2.test.db.TestCases)1
TestCheckpoint (org.h2.test.db.TestCheckpoint)1
TestCompatibility (org.h2.test.db.TestCompatibility)1
TestCompatibilityOracle (org.h2.test.db.TestCompatibilityOracle)1
TestCsv (org.h2.test.db.TestCsv)1
