I noticed that the code which lowers an ABT to an SBE plan in the common query framework code path doesn't correctly set up the SBE plan to yield. For yielding to happen correctly, the scan and ixscan leaf nodes need to have access to the PlanYieldPolicySBE object. This object is responsible for tracking the duration since the last yield, and triggering another yield if necessary. The ABT lowering code does set up a PlanYieldPolicySBE object here, but it doesn't ensure that the scan stages which can actually trigger a yield have access to it.

Fixing this will be required before we ship the optimizer, though I believe it will only affect performance characteristics, not correctness. So the work can be deferred. I imagine that this should be scheduled as part of the "SBE Lowering" project.