Can somebody re-open Trac Ticket #6245. It's sitting in the "waiting for testcase" state, but I have put a testcase in there since then:
6245_testcase.tar.gz (2.1 kB) - added by cuppett on 07/16/09 21:56:09. The CakePHP Testcase There is also some analysis and a patch. Stephen Cuppett steve at cuppett dot com c: +1-919-602-7366 On Fri, Jul 17, 2009 at 9:16 AM, CakePHP : The Rapid Development Framework for PHP <tick...@cakephp.org> wrote: > #6245: HABTM primaryKey identified in one direction only, bad DELETE > queries > > ---------------------------------+------------------------------------------ > Reporter: cuppett | Owner: > Type: Test Case | Status: reopened > Priority: High | Milestone: 1.2.x.x > Component: General | Version: 1.2 Final > Severity: Major | Resolution: > Keywords: HABTM primaryKey | Php_version: PHP 5 > Cake_version: 1.2.2.8120 | > > ---------------------------------+------------------------------------------ > Comment (by cuppett): > > Also, not sure why MySQL includes WHERE clauses for both columns; however, > with large HABTM tables a huge IN() part might have a negative impact on > performance. The query PostgreSQL is generating seems to be superior with > the single value WHERE clause on the appropriate side to delete the whole > set. > > -- > Ticket URL: <https://trac.cakephp.org/ticket/6245#comment:11> > CakePHP : The Rapid Development Framework for PHP < > https://trac.cakephp.org/> > Cake is a rapid development framework for PHP which uses commonly known > design patterns like ActiveRecord, Association Data Mapping, Front > Controller and MVC. Our primary goal is to provide a structured framework > that enables PHP users at all levels to rapidly develop robust web > applications, without any loss to flexibility. > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---