Sample 0 [from 180 instances]

Class440.testPayload(){
    Statement s = conn.createStatement();
    assertFalse(s.execute("SET PAYLOAD x y"));
    assertTrue(s.execute("SELECT commandpayload('x')"));
    ResultSet rs = s.getResultSet();
    assertTrue(rs.next());
    String str = rs.getString(1);
    assertEquals("y", str);
}


Sample 1 [from 82 instances]

Class520.tearDown()#0{
        Statement stmt = con.createStatement();
        stmt.execute("drop function myif(a INOUT int, b IN int)");
        stmt.close();
}


Sample 2 [from 77 instances]

Class470.doConnStmtNoRS(String text){
    Connection conn = DriverManager.getConnection("jdbc:default:connection");
    Statement stmt = conn.createStatement();
    stmt.execute(text);
}


Sample 3 [from 60 instances]

Class560.executeScript(String dataSourceName,String query)#0{
    Connection connection = DriverManager.getConnection(dataSourceName, USER, PASSWORD);
    Statement stmt = connection.createStatement();
    stmt.execute(query);
    stmt.close();
}


Sample 4 [from 23 instances]

Class260.exportTableGeometryCollection(){
        Statement stat = connection.createStatement();
        stat.execute("CALL SHPWrite('target/geomcoll_export.shp', 'GEOM_COLL')");
}


Sample 5 [from 21 instances]

Class220.tearDown(SQLExecutor sqlExec){
            stmt = conn.createStatement();
            stmt.execute(dropTableSql);
            JdbcUtils.close(stmt);
        conn.close();
}


Sample 6 [from 10 instances]

Class680.setUp()#2{
        for (int i = 0; i < TABLES.length; i++) {
            s.execute("DELETE FROM " + TABLES[i][0]);
        }
}


Sample 7 [from 9 instances]

Class280.testCaseCS4595B_NonUniqueIndex(){
        Statement st = createStatement();
        st.executeUpdate("set ISOLATION to RR");
        st.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
        st.executeUpdate("insert into foo values (1, 1)");
        doTestCaseCS4595B(st, "Index");
}


Sample 8 [from 8 instances]

Class330.testMultibatchSelect()#1{
    Statement s = conn.createStatement();
    assertTrue(s.execute("select * from tables, columns limit 7000"));
    ResultSet rs = s.getResultSet();
    while (rs.next()) {
      i++;
      rs.getString(1);
    }
}


Sample 9 [from 7 instances]

Class110.testNoTablePrivileges()#1{
        Statement stmt = con.createStatement();
        stmt.execute("REVOKE ALL ON metadatatest FROM PUBLIC");
}


Sample 10 [from 5 instances]

Class30.testLog(double expected,Statement stat)#0{
        stat.execute("insert into log values(1)");
        ResultSet rs = stat.executeQuery("select log(10) from log");
        rs.next();
        assertEquals((int) (expected * 100), (int) (rs.getDouble(1) * 100));
}