/*
* Copyright 2004-2014 H2 Group. Multiple-Licensed under the MPL 2.0,
* and the EPL 1.0 (http://h2database.com/html/license.html).
* Initial Developer: H2 Group
*/
package org.h2.test.db;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import org.h2.api.ErrorCode;
import org.h2.test.TestBase;
/**
* Tests the query cache.
*/
public class TestQueryCache extends TestBase {
/**
* Run just this test.
*
* @param a ignored
*/
public static void main(String... a) throws Exception {
TestBase.createCaller().init().test();
}
@Override
public void test() throws Exception {
deleteDb("queryCache");
test1();
testClearingCacheWithTableStructureChanges();
deleteDb("queryCache");
}
private void test1() throws Exception {
Connection conn = getConnection("queryCache;QUERY_CACHE_SIZE=10");
Statement stat = conn.createStatement();
stat.execute("create table test(id int, name varchar) " +
"as select x, space(100) from system_range(1, 1000)");
PreparedStatement prep;
conn.prepareStatement("select count(*) from test t1, test t2");
long time;
ResultSet rs;
long first = 0;
for (int i = 0; i < 4; i++) {
// this should both ensure results are not re-used
// stat.execute("set mode regular");
// stat.execute("create table x()");
// stat.execute("drop table x");
time = System.currentTimeMillis();
prep = conn.prepareStatement("select count(*) from test t1, test t2");
prep.executeQuery();
rs = stat.executeQuery("select count(*) from test t1, test t2");
rs.next();
int c = rs.getInt(1);
assertEquals(1000000, c);
time = System.currentTimeMillis() - time;
if (first == 0) {
first = time;
} else {
assertSmaller(time, first);
}
}
stat.execute("drop table test");
conn.close();
}
private void testClearingCacheWithTableStructureChanges() throws Exception {
Connection conn = getConnection("queryCache;QUERY_CACHE_SIZE=10");
assertThrows(ErrorCode.TABLE_OR_VIEW_NOT_FOUND_1, conn).
prepareStatement("SELECT * FROM TEST");
Statement stat = conn.createStatement();
stat.executeUpdate("CREATE TABLE TEST(col1 bigint, col2 varchar(255))");
PreparedStatement prep = conn.prepareStatement("SELECT * FROM TEST");
prep.close();
stat.executeUpdate("DROP TABLE TEST");
assertThrows(ErrorCode.TABLE_OR_VIEW_NOT_FOUND_1, conn).
prepareStatement("SELECT * FROM TEST");
conn.close();
}
}