@Test
public void testCaseSenJoinCTEWithRegTab() throws Exception {
final String query1 = "with a as ( select * from cp.\"tpch/nation.parquet\" ) select * from a, cp.\"tpch/region.parquet\" b where a.N_REGIONKEY = b.R_REGIONKEY";
int actualRecordCount = testSql(query1);
int expectedRecordCount = 25;
assertEquals(String.format("Received unexpected number of rows in output for query:\n%s\n expected=%d, received=%s",
query1, expectedRecordCount, actualRecordCount), expectedRecordCount, actualRecordCount);
final String query2 = "with a as ( select * from cp.\"tpch/nation.parquet\" ) select * from a, cp.\"tpch/region.parquet\" b where a.n_regionkey = b.r_regionkey";
actualRecordCount = testSql(query2);
expectedRecordCount = 25;
assertEquals(String.format("Received unexpected number of rows in output for query:\n%s\n expected=%d, received=%s",
query2, expectedRecordCount, actualRecordCount), expectedRecordCount, actualRecordCount);
}