conn.createStatement().execute("CREATE TABLE t (k INTEGER NOT NULL PRIMARY KEY, v1 VARCHAR, v2 VARCHAR) IMMUTABLE_ROWS=true");
nextConnection();
conn.createStatement().execute("CREATE INDEX idx ON t(v1) INCLUDE (v2)");
nextConnection();
PhoenixStatement stmt = conn.createStatement().unwrap(PhoenixStatement.class);
stmt.optimizeQuery("SELECT k, NEXT VALUE FOR seq.perf FROM t WHERE v1 = 'bar'");
}
@Test
public void testSelectRowAndSequence() throws Exception {
nextConnection();