Fix query result with trivial count optimization and array join

Fix incorrect query result when trivial count optimization is in effect with array join. This fixes #39431. #41158 (Denny Crane).