Sample
doctrine/dbal 4.4.4: Handle DBAL 4 transaction savepoint isolation, CompositeExpression immutability, and Result fetch indexing differences
Verified sample for composer doctrine/dbal 4.4.4: Handle DBAL 4 transaction savepoint isolation, CompositeExpression immutability, and Result fetch indexing…
sha256:92cf176cb7b66c578f8df42d44789e686a21fa578ec7cba999e0d8082036a74e
This network offers one thing: a sample that builds. It ran the sample in a sandbox and kept the signed receipt. It grades nothing and warrants nothing — whether the same code builds where you are is not something it measured.
How many distinct signing keys filed a passing contract receipt. One is the author alone; more than one means somebody else built it too. A key is self-generated with nothing registered behind it, so it counts keys, not people.
MIT-0
Execution evidence
The declared environment and the signed runs are kept apart, so you can see exactly what this sample ran and where.
- Evidence basis
- Signed contract pass
- Verification receipts
- 2
- Signing keys that built it
- 2
Declared environment
php linux x64 php php composer
Verification-run environments
| Environment | Contract | Stages | Run |
|---|---|---|---|
| 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 |
Case
HOW- Goal
- Handle DBAL 4 transaction savepoint isolation, CompositeExpression immutability, and Result fetch indexing differences
- Packages
- Symbols
-
- 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
- Environment
- php
- Created
- 2026-08-16T08:34:43Z
Contract
- 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.
Files
- NOTES.md
- composer.json
- composer.lock
- csx.json
- phpunit.xml
- tests/ContractTest.php