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);
 }