[Bug] When using a reverse join table as a condition in an update statement under a postgresql database, there is sometimes an extra comma at the end of the from table list in the generated sql

[ClearPlume]

Using reverse join in a project

Generated sql statements

[babyfish-ct]

I cannot reproduce it because there is not enough information, so I guessed the reason and modify some code.

Try 0.8.81

[ClearPlume]

Same... I'll put together a minimal reproduction project afterward

[babyfish-ct]

OK，only this method can reproduce it

[Enaium]

0.9.23复现不了

@Test
public void testReverseJoinByPostgres() {
    NativeDatabases.assumeNativeDatabase();
    BookTable book = BookTable.$;
    executeAndExpectRowCount(
            NativeDatabases.POSTGRES_DATA_SOURCE,
            getSqlClient(it -> {
                it.setDialect(new PostgresDialect());
            }).createUpdate(book).set(book.name(), "TEST").where(
                    book.asTableEx().inverseJoin(BookStoreTableEx.class, BookStoreTableEx::books).name().eq("MANNING"),
                    book.asTableEx().inverseJoin(BookStoreTableEx.class, BookStoreTableEx::books).version().eq(0),
                    Expression.tuple(book.id(), book.price()).in(
                            getSqlClient().createSubQuery(book)
                                    .groupBy(book.id())
                                    .select(book.id(), book.price().max())
                    )
            ),
            ctx -> {
                ctx.statement(it -> {
                    it.sql(
                            "update BOOK tb_1_ " +
                                    "set NAME = ? " +
                                    "from BOOK_STORE tb_2_ " +
                                    "where tb_1_.STORE_ID = tb_2_.ID" +
                                    " and tb_2_.NAME = ?" +
                                    " and tb_2_.VERSION = ?" +
                                    " and (tb_1_.ID, tb_1_.PRICE) in (select tb_3_.ID, max(tb_3_.PRICE) from BOOK tb_3_ group by tb_3_.ID)"
                    );
                });
                ctx.rowCount(3);
            }
    );
}