When we create canonical query for the subquery optimization we use filter, projection and sort from the base query, but do not use eventual limit/skip.

However, when we cost the plans with CBR, the presence of limit stage and its value also has an effect on the cost and the choice of the best plan.