ydb icon indicating copy to clipboard operation
ydb copied to clipboard

Canonize tree branch order (Grace Joins etc)

Open Hor911 opened this issue 1 year ago • 1 comments

In plan tree view some branched (i.e. Grace Join inputs) are fully equivalent. Currently they are printed in random order, so the same plane can be rendered differently. It complicates plan comparison.

For such branches a "canonical" form with fixed (i.a. alphabetical) order should be implemented.

Some other nodes are already rendered with fixed order, no changes are required there

Hor911 avatar Feb 22 '24 09:02 Hor911

I will need to double check if Grace Join inputs are really equivalent. We don't output them in random order right now, this order is defined by the cost function, and its currently not symmetric

pavelvelikhov avatar Feb 26 '24 08:02 pavelvelikhov