[PR #194] [MERGED] DDC-1430 - fix broken test on postgres #7841

New Issue

admin · 2026-01-22T15:57:08+01:00

admin commented

2026-01-22 15:57:08 +01:00

📋 Pull Request Information

Original PR: https://github.com/doctrine/orm/pull/194
Author: @FabioBatSilva
Created: 11/16/2011
Status: ✅ Merged
Merged: 11/18/2011
Merged by: @beberlei

Base: master ← Head: DDC-1430-PGSQL-TEST

📝 Commits (1)

f4da459 fix broken test on postgres

📊 Changes

1 file changed (+11 additions, -8 deletions)

View changed files

📝 tests/Doctrine/Tests/ORM/Functional/Ticket/DDC1430Test.php (+11 -8)

📄 Description

Hello all,

I think these changes fix the DDC-1430 test case on PostgreSQL.

But I got the following error running test suite :


There was 1 error:

1) Doctrine\Tests\ORM\Functional\Ticket\DDC742Test::testIssue
Exception: [PHPUnit_Framework_Error_Notice] Undefined index: 0000000028077f55000000000c00b98f

With queries:
11. SQL: 'INSERT INTO comments (content) VALUES (?)' Params: 'baz'
10. SQL: 'INSERT INTO comments (content) VALUES (?)' Params: 'bar'
9. SQL: 'INSERT INTO comments (content) VALUES (?)' Params: 'foo'
8. SQL: 'ALTER TABLE user_comments ADD CONSTRAINT FK_BF13722AF8697D13 FOREIGN KEY (comment_id) REFERENCES comments (id) NOT DEFERRABLE INITIALLY IMMEDIATE' Params: 
7. SQL: 'ALTER TABLE user_comments ADD CONSTRAINT FK_BF13722AA76ED395 FOREIGN KEY (user_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE' Params: 
6. SQL: 'CREATE TABLE comments (id SERIAL NOT NULL, content VARCHAR(100) NOT NULL, PRIMARY KEY(id))' Params: 
5. SQL: 'CREATE INDEX IDX_BF13722AF8697D13 ON user_comments (comment_id)' Params: 
4. SQL: 'CREATE INDEX IDX_BF13722AA76ED395 ON user_comments (user_id)' Params: 
3. SQL: 'CREATE TABLE user_comments (user_id INT NOT NULL, comment_id INT NOT NULL, PRIMARY KEY(user_id, comment_id))' Params: 
2. SQL: 'CREATE TABLE users (id SERIAL NOT NULL, title VARCHAR(100) NOT NULL, PRIMARY KEY(id))' Params: 

Trace:
/Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/UnitOfWork.php:2479
/Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/ManyToManyPersister.php:113
/Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/ManyToManyPersister.php:95
/Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/AbstractCollectionPersister.php:130
/Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/AbstractCollectionPersister.php:108
/Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/UnitOfWork.php:324
/Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/EntityManager.php:338
/Users/fabio/backup/workspace/php/doctrine2/tests/Doctrine/Tests/ORM/Functional/Ticket/DDC742Test.php:63


/Users/fabio/backup/workspace/php/doctrine2/tests/Doctrine/Tests/OrmFunctionalTestCase.php:359

Environment :

PostgreSQL 8.4.8 on i386-apple-darwin11.1.0, compiled by GCC i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00), 64-bit


PHP 5.3.8 (cli) (built: Sep 14 2011 10:17:25) 
Copyright (c) 1997-2011 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies with Xdebug v2.1.1, Copyright (c) 2002-2011, by Derick Rethans

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/doctrine/orm/pull/194 **Author:** [@FabioBatSilva](https://github.com/FabioBatSilva) **Created:** 11/16/2011 **Status:** ✅ Merged **Merged:** 11/18/2011 **Merged by:** [@beberlei](https://github.com/beberlei) **Base:** `master` ← **Head:** `DDC-1430-PGSQL-TEST` --- ### 📝 Commits (1) - [`f4da459`](https://github.com/doctrine/orm/commit/f4da4591fa998e77caf47914a6511de8f7b8aab7) fix broken test on postgres ### 📊 Changes **1 file changed** (+11 additions, -8 deletions) <details> <summary>View changed files</summary> 📝 `tests/Doctrine/Tests/ORM/Functional/Ticket/DDC1430Test.php` (+11 -8) </details> ### 📄 Description Hello all, I think these changes fix the DDC-1430 test case on PostgreSQL. But I got the following error running test suite : ``` There was 1 error: 1) Doctrine\Tests\ORM\Functional\Ticket\DDC742Test::testIssue Exception: [PHPUnit_Framework_Error_Notice] Undefined index: 0000000028077f55000000000c00b98f With queries: 11. SQL: 'INSERT INTO comments (content) VALUES (?)' Params: 'baz' 10. SQL: 'INSERT INTO comments (content) VALUES (?)' Params: 'bar' 9. SQL: 'INSERT INTO comments (content) VALUES (?)' Params: 'foo' 8. SQL: 'ALTER TABLE user_comments ADD CONSTRAINT FK_BF13722AF8697D13 FOREIGN KEY (comment_id) REFERENCES comments (id) NOT DEFERRABLE INITIALLY IMMEDIATE' Params: 7. SQL: 'ALTER TABLE user_comments ADD CONSTRAINT FK_BF13722AA76ED395 FOREIGN KEY (user_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE' Params: 6. SQL: 'CREATE TABLE comments (id SERIAL NOT NULL, content VARCHAR(100) NOT NULL, PRIMARY KEY(id))' Params: 5. SQL: 'CREATE INDEX IDX_BF13722AF8697D13 ON user_comments (comment_id)' Params: 4. SQL: 'CREATE INDEX IDX_BF13722AA76ED395 ON user_comments (user_id)' Params: 3. SQL: 'CREATE TABLE user_comments (user_id INT NOT NULL, comment_id INT NOT NULL, PRIMARY KEY(user_id, comment_id))' Params: 2. SQL: 'CREATE TABLE users (id SERIAL NOT NULL, title VARCHAR(100) NOT NULL, PRIMARY KEY(id))' Params: Trace: /Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/UnitOfWork.php:2479 /Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/ManyToManyPersister.php:113 /Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/ManyToManyPersister.php:95 /Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/AbstractCollectionPersister.php:130 /Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/Persisters/AbstractCollectionPersister.php:108 /Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/UnitOfWork.php:324 /Users/fabio/backup/workspace/php/doctrine2/lib/Doctrine/ORM/EntityManager.php:338 /Users/fabio/backup/workspace/php/doctrine2/tests/Doctrine/Tests/ORM/Functional/Ticket/DDC742Test.php:63 /Users/fabio/backup/workspace/php/doctrine2/tests/Doctrine/Tests/OrmFunctionalTestCase.php:359 ``` Environment : ``` PostgreSQL 8.4.8 on i386-apple-darwin11.1.0, compiled by GCC i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00), 64-bit PHP 5.3.8 (cli) (built: Sep 14 2011 10:17:25) Copyright (c) 1997-2011 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies with Xdebug v2.1.1, Copyright (c) 2002-2011, by Derick Rethans ``` --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

admin added the pull-request label 2026-01-22 15:57:08 +01:00

admin closed this issue

2026-01-22 15:57:09 +01:00

admin referenced this issue

2026-01-22 16:08:17 +01:00

[PR #7842] #7841 SchemaTool generates extra diff for platforms without FK support #10668

admin referenced this issue

2026-01-22 16:08:29 +01:00

[PR #7937] Revert SchemaTool change to check for foreign key support #10726

Sign in to join this conversation.