Support planning of TPC-DS query 41

[Dandandan]

Is your feature request related to a problem or challenge?

This query fails with the following error:

Error: Context("check_analyzed_plan", Plan("Correlated column is not allowed in predicate: item.i_manufact = outer_ref(i1.i_manufact) AND (item.i_category = Utf8(\"Women\") AND (item.i_color = Utf8(\"orchid\") OR item.i_color = Utf8(\"papaya\")) AND (item.i_units = Utf8(\"Pound\") OR item.i_units = Utf8(\"Lb\")) AND (item.i_size = Utf8(\"petite\") OR item.i_size = Utf8(\"medium\")) OR item.i_category = Utf8(\"Women\") AND (item.i_color = Utf8(\"burlywood\") OR item.i_color = Utf8(\"navy\")) AND (item.i_units = Utf8(\"Bundle\") OR item.i_units = Utf8(\"Each\")) AND (item.i_size = Utf8(\"N/A\") OR item.i_size = Utf8(\"extra large\")) OR item.i_category = Utf8(\"Men\") AND (item.i_color = Utf8(\"bisque\") OR item.i_color = Utf8(\"azure\")) AND (item.i_units = Utf8(\"N/A\") OR item.i_units = Utf8(\"Tsp\")) AND (item.i_size = Utf8(\"small\") OR item.i_size = Utf8(\"large\")) OR item.i_category = Utf8(\"Men\") AND (item.i_color = Utf8(\"chocolate\") OR item.i_color = Utf8(\"cornflower\")) AND (item.i_units = Utf8(\"Bunch\") OR item.i_units = Utf8(\"Gross\")) AND (item.i_size = Utf8(\"petite\") OR item.i_size = Utf8(\"medium\"))) OR item.i_manufact = outer_ref(i1.i_manufact) AND (item.i_category = Utf8(\"Women\") AND (item.i_color = Utf8(\"salmon\") OR item.i_color = Utf8(\"midnight\")) AND (item.i_units = Utf8(\"Oz\") OR item.i_units = Utf8(\"Box\")) AND (item.i_size = Utf8(\"petite\") OR item.i_size = Utf8(\"medium\")) OR item.i_category = Utf8(\"Women\") AND (item.i_color = Utf8(\"snow\") OR item.i_color = Utf8(\"steel\")) AND (item.i_units = Utf8(\"Carton\") OR item.i_units = Utf8(\"Tbl\")) AND (item.i_size = Utf8(\"N/A\") OR item.i_size = Utf8(\"extra large\")) OR item.i_category = Utf8(\"Men\") AND (item.i_color = Utf8(\"purple\") OR item.i_color = Utf8(\"gainsboro\")) AND (item.i_units = Utf8(\"Dram\") OR item.i_units = Utf8(\"Unknown\")) AND (item.i_size = Utf8(\"small\") OR item.i_size = Utf8(\"large\")) OR item.i_category = Utf8(\"Men\") AND (item.i_color = Utf8(\"metallic\") OR item.i_color = Utf8(\"forest\")) AND (item.i_units = Utf8(\"Gram\") OR item.i_units = Utf8(\"Ounce\")) AND (item.i_size = Utf8(\"petite\") OR item.i_size = Utf8(\"medium\")))"))

Describe the solution you'd like

As the error suggests, the column should probably be decorrelated.

Describe alternatives you've considered

No response

Additional context

No response