databend icon indicating copy to clipboard operation
databend copied to clipboard

Tracking: recursive cte

Open xudong963 opened this issue 1 year ago • 2 comments

Summary

  • [x] basic implementation for recursive cte (single execution and union all) https://github.com/datafuselabs/databend/issues/15228
  • [ ] support union for recursive cte (union all was supported in 1) (low prio)
  • [x] reference recursive cte in multiple places: https://github.com/datafuselabs/databend/pull/15835
  • [ ] support distributed recursive cte

xudong963 avatar Jun 11 '24 00:06 xudong963

Add: Support window function in recusive CTE

bohutang avatar Jun 15 '24 11:06 bohutang

Add: Support window function in recusive CTE

image

FYI: https://github.com/datafuselabs/databend/blob/main/src/query/sql/src/planner/binder/util.rs#L72-L75

xudong963 avatar Jun 15 '24 15:06 xudong963