[Bug] Enable deletion vector may lead to the wrong result

[Aitozi]

Search before asking

• [x] I searched in the issues and found nothing similar.

Paimon version

1.2

Compute Engine

all

Minimal reproduce step

    @Test
    public void testEnableDV() {
        sql(
                "CREATE TABLE T (a INT, b INT, PRIMARY KEY (a) NOT ENFORCED) WITH ("
                        + "'changelog-producer' = 'lookup', "
                        + "'bucket' = '1')");
        sql("INSERT INTO T VALUES (1, 2), (2, 2), (3, 3)");
        sql("INSERT INTO T VALUES (1, 3)");
        sql("INSERT INTO T VALUES (1, 4)");
        sql("INSERT INTO T VALUES (1, 5)");
        sql("INSERT INTO T VALUES (1, 6)");
        sql("INSERT INTO T VALUES (1, 7)");
        sql("ALTER TABLE T SET ('deletion-vectors.enabled' = 'true')");
        List<Row> rows = sql("SELECT * FROM T");
        System.out.println(rows);
    }

The result is

[+I[1, 6], +I[2, 2], +I[3, 3], +I[1, 7]]

What doesn't meet your expectations?

.

Anything else?

No response

Are you willing to submit a PR?

• [ ] I'm willing to submit a PR!

[Stefanietry]

may i task this issue

[Aitozi]

Sure, thanks for you help