[release-18.0] fix: route engine to handle column truncation for execute after lookup (#16981)

[release-18.0] fix: route engine to handle column truncation for execute after lookup (#16981) #26676