サンプル

doctrine/dbal 4.4.4: Handle DBAL 4 transaction savepoint isolation, CompositeExpression immutability, and Result fetch indexing differences

検証済みサンプル — composer doctrine/dbal 4.4.4: Handle DBAL 4 transaction savepoint isolation, CompositeExpression immutability, and Result fetch indexing…

sha256:92cf176cb7b66c578f8df42d44789e686a21fa578ec7cba999e0d8082036a74e

MIT-0

実行証拠

宣言された環境と署名済みの実行を分けてあります。このサンプルが何をどこで実行したかをそのまま確認できます。

宣言された環境 php linux x64 php php composer

環境	コントラクト	ステージ	実行日
php 8 · linux alpine/x64 · docker ed25519:d91480838ac982c9	PASS	compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · composer@1	2026-08-16
php 8 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1	PASS	compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · composer@1	2026-08-18

HOW

ゴール: Handle DBAL 4 transaction savepoint isolation, CompositeExpression immutability, and Result fetch indexing differences
パッケージ: doctrine/dbal 4.4.4
シンボル: Doctrine\DBAL\Connection::beginTransaction
Doctrine\DBAL\Connection::rollBack
Doctrine\DBAL\Connection::commit
Doctrine\DBAL\Connection::setAutoCommit
Doctrine\DBAL\Connection::setNestTransactionsWithSavepoints
Doctrine\DBAL\Query\Expression\CompositeExpression::and
Doctrine\DBAL\Query\Expression\CompositeExpression::with
Doctrine\DBAL\Result::fetchAllAssociativeIndexed
Doctrine\DBAL\Result::fetchAllKeyValue
環境: php
作成日: 2026-08-16T08:34:43Z

In DBAL 4 nested transactions always create SQL savepoints, so an inner rollBack() reverts only to the savepoint and does not mark the outer transaction rollback-only.
Attempting to disable savepoints via setNestTransactionsWithSavepoints(false) throws InvalidArgumentException because nesting without savepoints was removed in DBAL 4.
With autoCommit=false, executing queries starts a Level 1 transaction, a manual beginTransaction() increments to Level 2 (savepoint), and commit() immediately restarts Level 1 so the nesting level never drops to 0.
Calling commit() with autoCommit=true and no active transaction throws Doctrine\DBAL\Exception\NoActiveTransaction.
CompositeExpression is immutable: calling with() returns a new clone without mutating the caller in place, meaning unassigned calls silently drop filter conditions.
Result::fetchAllAssociativeIndexed() keys the result by the first column and shifts that column out of the row dictionary values.
Result::fetchAllKeyValue() requires at least two columns and silently ignores any columns beyond the first two.