Before %PARENT_PLAN SUBPLAN{ AGGREGATE($v2, sequence(%expression($v1)) ) UNNEST($v1, iterate($v0) ) NESTEDTUPLESOURCE } %CHILD_PLAN Where |$v0| == 1 After %PARENT_PLAN ASSIGN($v2, %expression($v0) ) %CHILD_PLAN
120121122123124125126127
// Adds child steps to the data source scan. normalization.add(new ConsolidateUnnestsRule()); normalization.add(new PushChildIntoDataScanRule()); // Improvement for scalar child expressions normalization.add(new EliminateSubplanForSingleItemsRule()); return normalization; }