[release-18.0] Direct PR. Fix regression where reference tables with a different name on sharded keyspaces were not routed correctly.

[release-18.0] Direct PR. Fix regression where reference tables with a different name on sharded keyspaces were not routed correctly. #23897