QueryBuilder fails to return data with an array parameter #7413

New Issue

Open

opened 2026-01-22 15:51:25 +01:00 by admin · 2 comments

admin commented 2026-01-22 15:51:25 +01:00

Owner

Copy Link

Originally created by @duzenko on GitHub (Sep 2, 2024).

Bug Report

Q	A
BC Break	no
Version	2.11

Summary

The QueryBuilder returns no records when using an array parameter

Current behavior

getOneOrNullResult returns null

How to reproduce

	$pdo = $em->getConnection();

	$qe = $pdo->executeQuery( 'SELECT * FROM Edata_payment e0_ WHERE e0_.contract = ? AND e0_.a_status NOT IN (?)', [ $contractId, '0,1' ] );
	$la = $qe->fetchAssociative();

	$qe = $pdo->executeQuery( 'SELECT * FROM Edata_payment e0_ WHERE e0_.contract = ? AND e0_.a_status NOT IN (?)', [ $contractId, [ 0, 1 ] ], [ 'integer', \Doctrine\DBAL\ArrayParameterType::INTEGER ] );
	$lb = $qe->fetchAssociative();

	/** @var LoanInstalment $li */
	$li = LoanInstalmentRepository::instance()->createQueryBuilder( 'LCI' )
		->where( 'LCI.contract = :contract and LCI.status NOT IN ( :status )' )
		->setParameter( 'contract', $contractId )
		->setParameter( 'status', [ \C_Loan_Contract_Instalment::STATUS_PAID_OFF, \C_Loan_Contract_Instalment::STATUS_RECEIVED ] )
//		->setParameter( 'status', implode( ',', [ \C_Loan_Contract_Instalment::STATUS_PAID_OFF, \C_Loan_Contract_Instalment::STATUS_RECEIVED ] ) )
		->setMaxResults( 1 )
		->orderBy( 'LCI.id', 'ASC' )
		->getQuery()->getOneOrNullResult();

Case 1 ($la): simply works, when parameter is a string
Case 2 ($lb): what's happening inside the DBAL/Connection code when passing the array parameter into a Query Builder
Case 3 ($lb): is the actual Query Builder usage that fails

Expected behavior

Either $li is not null
Or Doctrine throws when/if it cannot handle array parameters

Originally created by @duzenko on GitHub (Sep 2, 2024). ### Bug Report | Q | A |------------ | ------ | BC Break | no | Version | 2.11 #### Summary The QueryBuilder returns no records when using an array parameter #### Current behavior `getOneOrNullResult` returns null #### How to reproduce ``` $pdo = $em->getConnection(); $qe = $pdo->executeQuery( 'SELECT * FROM Edata_payment e0_ WHERE e0_.contract = ? AND e0_.a_status NOT IN (?)', [ $contractId, '0,1' ] ); $la = $qe->fetchAssociative(); $qe = $pdo->executeQuery( 'SELECT * FROM Edata_payment e0_ WHERE e0_.contract = ? AND e0_.a_status NOT IN (?)', [ $contractId, [ 0, 1 ] ], [ 'integer', \Doctrine\DBAL\ArrayParameterType::INTEGER ] ); $lb = $qe->fetchAssociative(); /** @var LoanInstalment $li */ $li = LoanInstalmentRepository::instance()->createQueryBuilder( 'LCI' ) ->where( 'LCI.contract = :contract and LCI.status NOT IN ( :status )' ) ->setParameter( 'contract', $contractId ) ->setParameter( 'status', [ \C_Loan_Contract_Instalment::STATUS_PAID_OFF, \C_Loan_Contract_Instalment::STATUS_RECEIVED ] ) // ->setParameter( 'status', implode( ',', [ \C_Loan_Contract_Instalment::STATUS_PAID_OFF, \C_Loan_Contract_Instalment::STATUS_RECEIVED ] ) ) ->setMaxResults( 1 ) ->orderBy( 'LCI.id', 'ASC' ) ->getQuery()->getOneOrNullResult(); ```  Case 1 ($la): simply works, when parameter is a string Case 2 ($lb): what's happening inside the `DBAL/Connection` code when passing the array parameter into a Query Builder Case 3 ($lb): is the actual Query Builder usage that fails #### Expected behavior Either `$li` is not null Or Doctrine throws when/if it cannot handle array parameters

admin commented 2026-01-22 15:51:26 +01:00

Author

Owner

Copy Link

@duzenko commented on GitHub (Sep 2, 2024):

If this was fixed in a later version, please point me to the change log entry

@duzenko commented on GitHub (Sep 2, 2024): If this was fixed in a later version, please point me to the change log entry

admin commented 2026-01-22 15:51:26 +01:00

Author

Owner

Copy Link

@duzenko commented on GitHub (Sep 2, 2024):

FWIW my composer versions are

doctrine/annotations               1.14.3             Docblock Annotations Parser

doctrine/cache                     1.13.0             PHP Doctrine Cache library is a popular cache implementation that supports many diff...

doctrine/collections               1.8.0              PHP Doctrine Collections library that adds additional functionality on top of PHP ar...

doctrine/common                    3.4.4              PHP Doctrine Common project is a library that provides additional functionality that...

doctrine/dbal                      3.9.0              Powerful PHP database abstraction layer (DBAL) with many features for database schem...

doctrine/deprecations              0.5.3              A small layer on top of trigger_error(E_USER_DEPRECATED) or PSR-3 logging with optio...

doctrine/event-manager             1.2.0              The Doctrine Event Manager is a simple PHP event system that was built to be used wi...

doctrine/inflector                 2.0.10             PHP Doctrine Inflector is a small library that can perform string manipulations with...

doctrine/instantiator              1.5.0              A small, lightweight utility to instantiate objects in PHP without invoking their co...

doctrine/lexer                     1.2.3              PHP Doctrine Lexer parser library that can be used in Top-Down, Recursive Descent Pa...

doctrine/orm                       2.11.3             Object-Relational-Mapper for PHP

doctrine/persistence               2.5.7              The Doctrine Persistence project is a set of shared interfaces and functionality tha...

And the DB server is

mysql  Ver 15.1 Distrib 10.6.19-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper

@duzenko commented on GitHub (Sep 2, 2024): FWIW my composer versions are ``` doctrine/annotations 1.14.3 Docblock Annotations Parser doctrine/cache 1.13.0 PHP Doctrine Cache library is a popular cache implementation that supports many diff... doctrine/collections 1.8.0 PHP Doctrine Collections library that adds additional functionality on top of PHP ar... doctrine/common 3.4.4 PHP Doctrine Common project is a library that provides additional functionality that... doctrine/dbal 3.9.0 Powerful PHP database abstraction layer (DBAL) with many features for database schem... doctrine/deprecations 0.5.3 A small layer on top of trigger_error(E_USER_DEPRECATED) or PSR-3 logging with optio... doctrine/event-manager 1.2.0 The Doctrine Event Manager is a simple PHP event system that was built to be used wi... doctrine/inflector 2.0.10 PHP Doctrine Inflector is a small library that can perform string manipulations with... doctrine/instantiator 1.5.0 A small, lightweight utility to instantiate objects in PHP without invoking their co... doctrine/lexer 1.2.3 PHP Doctrine Lexer parser library that can be used in Top-Down, Recursive Descent Pa... doctrine/orm 2.11.3 Object-Relational-Mapper for PHP doctrine/persistence 2.5.7 The Doctrine Persistence project is a set of shared interfaces and functionality tha... ``` And the DB server is ``` mysql Ver 15.1 Distrib 10.6.19-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper ```

admin referenced this issue 2026-01-22 16:07:40 +01:00

[PR #7413] Apply Doctrine CS 5.0 #10480

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#7413