public void nullMixedComparatorEqualJoinHelper(final String query) throws Exception { testBuilder() .sqlQuery(query) .unOrdered() .baselineColumns("key", "data", "data0", "key0") .baselineValues("A", "L_A_1", "L_A_1", "A") .baselineValues("A", null, null, "A") .baselineValues("B", null, null, "B") .baselineValues("B", "L_B_1", "L_B_1", "B") .go(); } }
public void nullEqualJoinHelper(final String query) throws Exception { testBuilder() .sqlQuery(query) .unOrdered() .baselineColumns("key", "data", "data0", "key0") .baselineValues(null, "L_null_1", "R_null_1", null) .baselineValues(null, "L_null_2", "R_null_1", null) .baselineValues("A", "L_A_1", "R_A_1", "A") .baselineValues("A", "L_A_2", "R_A_1", "A") .baselineValues(null, "L_null_1", "R_null_2", null) .baselineValues(null, "L_null_2", "R_null_2", null) .baselineValues(null, "L_null_1", "R_null_3", null) .baselineValues(null, "L_null_2", "R_null_3", null) .go(); }
@Ignore("DX-11205") @Test public void withNullEqualAdditionFilter() throws Exception { final String query = "SELECT * FROM " + "cp.\"jsoninput/nullableOrdered1.json\" t1 JOIN " + "cp.\"jsoninput/nullableOrdered2.json\" t2 " + "ON (t1.key = t2.key OR (t1.key IS NULL AND t2.key IS NULL)) AND t1.data LIKE '%1%'"; testPlanSubstrPatterns(query, new String[] { "HashJoin(condition=[IS NOT DISTINCT FROM($0, $4)], joinType=[inner])", "Filter(condition=[$2])", // 'like' is pushed into project "[LIKE($1, '%1%')]" }, null); testBuilder() .sqlQuery(query) .unOrdered() .baselineColumns("key", "data", "data0", "key0") .baselineValues(null, "L_null_1", "R_null_1", null) .baselineValues("A", "L_A_1", "R_A_1", "A") .baselineValues(null, "L_null_1", "R_null_2", null) .baselineValues(null, "L_null_1", "R_null_3", null) .go(); }
public void nullEqual3WayJoinHelper(final String query) throws Exception { testBuilder() .sqlQuery(query) .unOrdered() .baselineColumns("key", "data", "data0", "key0", "data1", "key1") .baselineValues(null, "L_null_1", "R_null_1", null, "RR_null_1", null) .baselineValues(null, "L_null_2", "R_null_1", null, "RR_null_1", null) .baselineValues("A", "L_A_1", "R_A_1", "A", "RR_A_1", "A") .baselineValues("A", "L_A_2", "R_A_1", "A", "RR_A_1", "A") .baselineValues("A", "L_A_1", "R_A_1", "A", "RR_A_2", "A") .baselineValues("A", "L_A_2", "R_A_1", "A", "RR_A_2", "A") .baselineValues(null, "L_null_1", "R_null_2", null, "RR_null_1", null) .baselineValues(null, "L_null_2", "R_null_2", null, "RR_null_1", null) .baselineValues(null, "L_null_1", "R_null_3", null, "RR_null_1", null) .baselineValues(null, "L_null_2", "R_null_3", null, "RR_null_1", null) .go(); } @Ignore("DX-11205")