issue #23086: normalize join tests