Unexpected Result by BROADCAST_JOIN in TiFlash

[bajinsheng]

Bug Report

The query returns a different result under the hint BROADCAST_JOIN, which should not affect the result.

1. Minimal reproduce step (Required)

CREATE TABLE t0(c0 CHAR, PRIMARY KEY(c0));
CREATE TABLE t1(c0 BOOL);
INSERT INTO t0 VALUES ('a');
INSERT INTO t1 VALUES (true);
ANALYZE TABLE t0;
ANALYZE TABLE t1;
ALTER TABLE t0 SET TIFLASH REPLICA 1;
ALTER TABLE t1 SET TIFLASH REPLICA 1;
SELECT SLEEP(5);

SELECT t1.c0 FROM t1, t0 WHERE LOG(t0.c0); -- empyt
SELECT /*+ BROADCAST_JOIN(t0, PRIMARY)*/t1.c0 FROM t1, t0 WHERE LOG(t0.c0); -- {1}

2. What did you expect to see? (Required)

Two queries return the same result.

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

| Release Version: v7.4.0-alpha
Edition: Community
Git Commit Hash: 0ccc9e170563763f46a2c62671a56b8581f6bd5d
Git Branch: heads/refs/tags/v7.4.0-alpha
UTC Build Time: 2023-09-16 14:33:29
GoVersion: go1.21.1
Race Enabled: false
Check Table Before Drop: false
Store: tikv |

[aytrack]

releated #47019

[zanmato1984]

Duplicate of #46601

Closing. Feel free to reopen if you observe any further issue.