ZF-7936: Zend_Test_PHPUnit_Db_Operation_Truncate should truncate tables in reversed order.

Issue Type: Bug Created: 2009-09-23T08:16:48.000+0000 Last Updated: 2009-09-24T11:15:07.000+0000 Status: Resolved Fix version(s): - 1.9.4 (13/Oct/09)

Reporter: Kiril (dexm) Assignee: Benjamin Eberlei (beberlei) Tags: - Zend_Test_PHPUnit

Related issues: Attachments:


MySQL database contains InnoDB tables with foreign keys. In XML dataset tables are described in such order, that insertion would go along with existing DB constraints. Method "execute" in "Zend_Test_PHPUnit_Db_Operation_Truncate" class tries to truncate them in same order and fails because of DB constraints. Truncating tables in reverse order would solve the problems as dependent rows would be removed before rows they depend upon.

Changing row 61 in file "Zend/Test/PHPUnit/Db/Operation/Truncate.php" to

<pre class="highlight">
foreach ($dataSet->getReverseIterator() as $table)

solved the problem. This applies to Zend Framework release 1.9.3PL1.


Posted by Matthew Weier O'Phinney (matthew) on 2009-09-23T08:32:08.000+0000

Assigning to Ben Eberlei

Posted by Benjamin Eberlei (beberlei) on 2009-09-23T23:26:02.000+0000

I patched this in trunk already, however it seems the test for it fail on 1.9 release branch, because of some missing bug i forgot to merge into 1.9 from zend test dbadapter. I do the merge into 1.9 later and then close the bug

Posted by Benjamin Eberlei (beberlei) on 2009-09-24T11:14:53.000+0000

Merged into 1.9 release branch, tests now pass

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.