3 public class CreateTempTableTest extends PgpoolTest {
4 public void do_test() throws SQLException {
8 PreparedStatement pstmt = null;
11 connection.setAutoCommit(false);
13 pstmt = connection.prepareStatement("CREATE TEMP TABLE t1(i INTEGER)");
14 pstmt.executeUpdate();
17 pstmt = connection.prepareStatement("INSERT INTO t1 SELECT ?");
19 pstmt.executeUpdate();
22 pstmt = connection.prepareStatement("UPDATE t1 SET i = ?");
24 pstmt.executeUpdate();
27 pstmt = connection.prepareStatement("SELECT sum(i) FROM t1");
28 rs = pstmt.executeQuery();
30 logwriter.println(rs.getInt(1));
42 public String getTestName() {
43 return "CreateTempTable";