DDC-370: CTI Retrieval of Scalar fields does not use correct table alias #459

New Issue

admin · 2026-01-22T12:39:00+01:00

admin commented

2026-01-22 12:39:00 +01:00

Originally created by @doctrinebot on GitHub (Feb 24, 2010).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @beberlei:

    public function testGroupByMultipleFields()
    {
        $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p '.
               'GROUP BY p.department, p.name';
        $result = $this->_em->createQuery($dql)->getResult();
    }

Error:

Doctrine\Tests\ORM\Functional\AdvancedDqlQueryTest::testGroupByMultipleFields()
Exception: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c0_.name' in 'field list'
With queries:
21. SQL: 'SELECT c0*.department AS department0, c0_.name AS name1, count(c1_.id) AS sclr2 FROM company_employees c0_ INNER JOIN company_persons c1_ ON c0_.id = c1_.id LEFT JOIN company_managers c2_ ON c0_.id = c2_.id GROUP BY c0_.department, c1*.name' Params:
20. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '15', '14'
19. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '15', '13'
18. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '15', '16'
17. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '14', '15'
16. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '14', '13'
15. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '13', '15'
14. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '13', '14'
13. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '16', '15'
12. SQL: 'UPDATE company*persons SET spouse*id = ? WHERE id = ?' Params: '13', '14'
11. SQL: 'UPDATE company*persons SET spouse*id = ? WHERE id = ?' Params: '14', '13'
10. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '16', '100000', 'IT'
9. SQL: 'INSERT INTO company*managers (id, title, car*id) VALUES (?, ?, ?)' Params: '16', 'Foo', '4'
8. SQL: 'INSERT INTO company*persons (name, spouse*id, discr) VALUES (?, ?, ?)' Params: 'Roman B.', '', 'manager'
7. SQL: 'INSERT INTO company_cars (brand) VALUES (?)' Params: 'BMW'
6. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '15', '800000', 'IT2'
5. SQL: 'INSERT INTO company*persons (name, spouse*id, discr) VALUES (?, ?, ?)' Params: 'Jonathan W.', '', 'employee'
4. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '14', '400000', 'IT2'
3. SQL: 'INSERT INTO company*persons (name, spouse*id, discr) VALUES (?, ?, ?)' Params: 'Guilherme B.', '', 'employee'
2. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '13', '200000', 'IT'
Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:575
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:198
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:511
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:349
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/AdvancedDqlQueryTest.php:84
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:253

Originally created by @doctrinebot on GitHub (Feb 24, 2010). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @beberlei: ``` public function testGroupByMultipleFields() { $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. 'GROUP BY p.department, p.name'; $result = $this->_em->createQuery($dql)->getResult(); } ``` Error: ``` Doctrine\Tests\ORM\Functional\AdvancedDqlQueryTest::testGroupByMultipleFields() Exception: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c0_.name' in 'field list' With queries: 21. SQL: 'SELECT c0*.department AS department0, c0_.name AS name1, count(c1_.id) AS sclr2 FROM company_employees c0_ INNER JOIN company_persons c1_ ON c0_.id = c1_.id LEFT JOIN company_managers c2_ ON c0_.id = c2_.id GROUP BY c0_.department, c1*.name' Params: 20. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '15', '14' 19. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '15', '13' 18. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '15', '16' 17. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '14', '15' 16. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '14', '13' 15. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '13', '15' 14. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '13', '14' 13. SQL: 'INSERT INTO company*persons_friends (person_id, friend*id) VALUES (?, ?)' Params: '16', '15' 12. SQL: 'UPDATE company*persons SET spouse*id = ? WHERE id = ?' Params: '13', '14' 11. SQL: 'UPDATE company*persons SET spouse*id = ? WHERE id = ?' Params: '14', '13' 10. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '16', '100000', 'IT' 9. SQL: 'INSERT INTO company*managers (id, title, car*id) VALUES (?, ?, ?)' Params: '16', 'Foo', '4' 8. SQL: 'INSERT INTO company*persons (name, spouse*id, discr) VALUES (?, ?, ?)' Params: 'Roman B.', '', 'manager' 7. SQL: 'INSERT INTO company_cars (brand) VALUES (?)' Params: 'BMW' 6. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '15', '800000', 'IT2' 5. SQL: 'INSERT INTO company*persons (name, spouse*id, discr) VALUES (?, ?, ?)' Params: 'Jonathan W.', '', 'employee' 4. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '14', '400000', 'IT2' 3. SQL: 'INSERT INTO company*persons (name, spouse*id, discr) VALUES (?, ?, ?)' Params: 'Guilherme B.', '', 'employee' 2. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '13', '200000', 'IT' Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:575 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:198 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:511 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:349 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/AdvancedDqlQueryTest.php:84 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:253 ```

admin added the Bug label 2026-01-22 12:39:00 +01:00

admin closed this issue

2026-01-22 12:39:01 +01:00

admin commented

2026-01-22 12:39:02 +01:00

@doctrinebot commented on GitHub (Feb 26, 2010):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Feb 26, 2010): Issue was closed with resolution "Fixed"

admin referenced this issue

2026-01-22 15:58:59 +01:00

[PR #459] [MERGED] Fix DDC-2012 #8232

Sign in to join this conversation.