Folks, looks like both version 4.0.1 and version 4.0.0 has planner issues as compared to 3.5.3 on CTE-heavy expressions. The expression that runs fine on 3.5.3 gets

no executable plan for this sql. group: ->  Group: 132
{root group 132 root operator: LogicalCTEAnchorOperator{cteId='1'} child: 2, 131}. required property: EMPTY SORT, EMPTY DISTRIBUTION, EMPTY CTE

on both 4.0.0 and 4.0.1. Opened a bugfix request on GitHub: https://github.com/StarRocks/starrocks/issues/66169