Sample

Execute Doctrine DBAL 4 queries and statement mutations with DsnParser connection options, un-prefixed named parameter keys, typed ParameterType and ArrayParameterType enums, and distinct fetchOne null vs false return shapes

sha256:9959838faa8799c462dc65c53a95e3fd86c8df10e43f719021affced0e2a0cd9

PUBLISHED L3_CONTRACT_PASS MIT-0

Case

Goal: Execute Doctrine DBAL 4 queries and statement mutations with DsnParser connection options, un-prefixed named parameter keys, typed ParameterType and ArrayParameterType enums, and distinct fetchOne null vs false return shapes HOW
Packages: doctrine/dbal 4.4.4
Environment: php
Created: 2026-08-16T08:31:17Z

DriverManager::getConnection() throws DriverRequired when passed a raw 'url' parameter without driver or DsnParser
Connection::executeQuery() throws MissingNamedParameter if named parameter keys include a leading colon ':'
Connection query and execution methods throw TypeError if passed integer type constants instead of ParameterType or ArrayParameterType enums
ArrayParameterType::INTEGER expands array values in IN (?) clauses and safely converts empty arrays [] to IN (NULL)
Connection::fetchOne() returns null when a column is SQL NULL but returns false when no matching row exists
Connection::fetchAssociative() returns false on missing rows while fetchAllAssociative() and fetchFirstColumn() return empty arrays []
Connection::insert, update, and delete return the integer count of affected rows

php 8 · CONTAINER_RUN · compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS · composer@1 · 2026-08-16 · ed25519:d91480838ac982c9