exec: tracking issue for TPC-H queries

[jordanlewis]

This issue tracks missing experimental_vectorize features by TPC-H query.

• Q2
  • LIKE
  • MIN
• Q3 inner 1 col mergejoin
• Q4 semi hashjoin
• Q7
  • OR expr
  • ComparisonExpr on char and string (exec: handle some mixed type comparison expressions #39464)
  • AND expr projection
• Q8
  • case expression
• Q11
  • float * int
• Q12
  • sum on integer types (exec: some aggregations should promote the return type #38845)
  • case
• Q13
  • NOT LIKE
  • COUNT(col)
• Q15 max
• Q16
  • LIKE
  • anti merge join
  • p_size IN (49, 14, 23, 45, 19, 3, 36, 9)
  • ComparisonExpr on varchar/char and string (exec: handle some mixed type comparison expressions #39464)
  • distinct aggregation (exec: add distinct aggregation support #39242)
• Q18 semi merge join
• Q19
  • tuple cmp
  • OR expr
  • AND expr projection
• Q20
  • LIKE
  • int/float comparison in selection (exec: handle some mixed type comparison expressions #39464)
• Q21
  • ComparisonExpr on char and string (exec: handle some mixed type comparison expressions #39464)
    - [ ] LEFT ANTI merge join with ON expression (exec: add support for ON expression for the joiners #38018)
    - [ ] LEFT SEMI hash join with ON expression (exec: add support for ON expression for the joiners #38018)
• Q22 substring

[yuzefovich]

The only remaining query is Q21, but the plan for it changed in July, and the ON conditions of joiners aren't used anymore, so I'll close this issue. cc @asubiotto @jordanlewis 🎉

[jordanlewis]

Wow, another great milestone!