@Test public void testStartKeyStopKey() throws SQLException { long ts = nextTimestamp(); Properties props = new Properties(); props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts)); Connection conn = DriverManager.getConnection(getUrl(), props); conn.createStatement() .execute( "CREATE TABLE start_stop_test (pk char(2) not null primary key) SPLIT ON ('EA','EZ')"); conn.close(); String query = "select count(*) from start_stop_test where pk >= 'EA' and pk < 'EZ'"; props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts + 2)); conn = DriverManager.getConnection(getUrl(), props); Statement statement = conn.createStatement(); statement.execute(query); PhoenixStatement pstatement = statement.unwrap(PhoenixStatement.class); List<KeyRange> splits = pstatement.getQueryPlan().getSplits(); assertTrue(splits.size() > 0); }