issue #23108: joins should be left joins