developed to cover the case of mdev-13389: "Optimization for equi-joins
of derived tables with window functions".