• Fujii Masao's avatar
    Fix bug in COMMIT AND CHAIN command. · 8a55cb5b
    Fujii Masao authored
    This commit fixes COMMIT AND CHAIN command so that it starts new transaction
    immediately even if savepoints are defined within the transaction to commit.
    Previously COMMIT AND CHAIN command did not in that case because
    commit 280a408b forgot to make CommitTransactionCommand() handle
    a transaction chaining when the transaction state was TBLOCK_SUBCOMMIT.
    
    Also this commit adds the regression test for COMMIT AND CHAIN command
    when savepoints are defined.
    
    Back-patch to v12 where transaction chaining was added.
    
    Reported-by: Arthur Nascimento
    Author: Fujii Masao
    Reviewed-by: Arthur Nascimento, Vik Fearing
    Discussion: https://postgr.es/m/16867-3475744069228158@postgresql.org
    8a55cb5b
transactions.sql 16.1 KB