package test.h2npe;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class H2NpeTest {

    public static void main(String[] args) throws Throwable {
        String jdbcConnectionString = "jdbc:h2:mem:xxx";
        Properties properties = new Properties();
        properties.setProperty("MV_STORE", "FALSE"); // Comment this line and you get a different NPE!
        Connection conn = DriverManager.getConnection(jdbcConnectionString, properties);
        Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
        String s = "CREATE TABLE TblA (AField DOUBLE);\n" +
                "CREATE INDEX TblAIndex ON TblA(AField);\n" +
                "ALTER TABLE TblA ADD (PrevDate DOUBLE);\n" +
                "CREATE TABLE TblB(AField DOUBLE) AS SELECT AField FROM TblA;";
        stmt.execute(s);
        stmt.close();
        conn.close();
    }

}