[DBAL-196] The function fetchAll(PDO::FETCH_ALL, 'MyClass') doesn't create object of MyClass Created: 06/Jan/12  Updated: 21/Jan/12  Resolved: 21/Jan/12

Status: Resolved
Project: Doctrine DBAL
Component/s: None
Affects Version/s: None
Fix Version/s: 2.2
Security Level: All

Type: Bug Priority: Major
Reporter: Antoine Froger Assignee: Fabio B. Silva
Resolution: Fixed Votes: 0
Labels: None


The code below doesn't create objects of MyClass when it has to.
Instead it create StdClass objects

$stmt = $db->prepare($sql);

$results = $stmt->fetchAll(

The problem comes from the file Doctrine/DBAL/Statement.php

     * Returns an array containing all of the result set rows.
     * @param integer $fetchStyle
     * @param integer $columnIndex
     * @return array An array containing all of the remaining rows in the result set.
    public function fetchAll($fetchStyle = PDO::FETCH_BOTH, $columnIndex = 0)
	if ($columnIndex != 0) {
            return $this->_stmt->fetchAll($fetchStyle, $columnIndex);
        return $this->_stmt->fetchAll($fetchStyle);

The line

if ($columnIndex != 0) {

must be replace by

if ($columnIndex !== 0) {

because the parameter $columnIndex is not always an integer and could be a name of a class : see the example n°4 in php doc http://www.php.net/manual/en/pdostatement.fetchall.php

Comment by Benjamin Eberlei [ 21/Jan/12 ]

Fixed and merged into 2.2

Generated at Mon Nov 30 08:27:54 EST 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.