public static Test suite() {
Test suite = TestConfiguration.defaultSuite(OptimizerOverridesTest.class, false);
suite =
new CleanDatabaseTestSetup(suite) {
/* Create tables, indices and views.
* @see org.apache.derbyTesting.junit.CleanDatabaseTestSetup#decorateSQL(java.sql.Statement)
*/
protected void decorateSQL(Statement st) throws SQLException {
st.getConnection().setAutoCommit(false);
st.addBatch(
"create table t1 (c1 int, "
+ "c2 int, c3 int,"
+ " constraint cons1 primary key(c1, c2))");
st.addBatch(
"create table t2 (c1 int not null, "
+ "c2 int not null, c3 int, "
+ "constraint cons2 unique(c1, c2))");
st.addBatch("insert into t1 values (1, 1, 1), " + "(2, 2, 2), (3, 3, 3), (4, 4, 4)");
;
st.addBatch("insert into t2 values (1, 1, 1), " + "(2, 2, 2), (3, 3, 3), (4, 4, 4)");
st.addBatch("create index t1_c1c2c3 on t1(c1, c2, c3)");
st.addBatch("create index t1_c3c2c1 on t1(c3, c2, c1)");
st.addBatch("create index t1_c1 on t1(c1)");
st.addBatch("create index t1_c2 on t1(c2)");
st.addBatch("create index t1_c3 on t1(c3)");
st.addBatch("create index \"t1_c2c1\" on t1(c2, c1)");
st.addBatch("create index t2_c1c2c3 on t2(c1, c2, c3)");
st.addBatch("create index t2_c3c2c1 on t2(c3, c2, c1)");
st.addBatch("create index t2_c1 on t2(c1)");
st.addBatch("create index t2_c2 on t2(c2)");
st.addBatch("create index t2_c3 on t2(c3)");
st.addBatch("create view v1 as select * from t1 " + "--derby-properties index = t1_c1");
st.addBatch("create view v2 as select t1.* from t1, t2");
st.addBatch("create view v3 as select * from v1");
st.addBatch(
"create view neg_v1 as select * from t1" + " --derby-properties asdf = fdsa");
st.executeBatch();
}
};
return suite;
}
public static Test suite() {
return TestConfiguration.defaultSuite(FloatTypesTest.class);
}
/** Construct top level suite in this JUnit test */
public static Test suite() {
TestSuite suite = (TestSuite) TestConfiguration.defaultSuite(AnsiSignaturesTest.class);
return new CleanDatabaseTestSetup(suite);
}
/** Create test suite for this test. */
public static Test suite() {
return new BlobClobTestSetup(
// Reduce lock timeouts so lock test case does not take too long
DatabasePropertyTestSetup.setLockTimeouts(
TestConfiguration.defaultSuite(ClobTest.class, false), 2, 4));
}
public static Test suite() {
return TestConfiguration.defaultSuite(UnsupportedVetter.class);
}
public static Test suite() {
return TestConfiguration.defaultSuite(InternationalConnectTest.class);
}