#6523: Result set of find() method different depending on conditions sepcifed on
MySQL views
---------------------------+------------------------------------------------
    Reporter:  rb5894      |         Owner:                
        Type:  Bug         |        Status:  closed        
    Priority:  High        |     Milestone:  1.2.x.x       
   Component:  Model       |       Version:  1.2 Final     
    Severity:  Major       |    Resolution:  needmoreinfo  
    Keywords:              |   Php_version:  PHP 4 >= 4.3.2
Cake_version:  1.2.3.8166  |  
---------------------------+------------------------------------------------
Comment (by rb5894):

 I copy paste the query and parts of the results for privacy reasons.  If
 it's possible to not make any public posting I could provide the DDL for
 the tables and the view that is based on them.  MySQL version is 5.0.67
 -community-nt.  I ran this on PHP4 and PHP5 with the same results.

 The following query
 {{{
 $calls = $this->CmpgnResult->find('all', array('conditions' => array('OR'
 => array('CmpgnResult.cc_reviewed_call' => false,
 'CmpgnResult.cc_reviewed_call is null'),
                                                                 //
 'CmpgnResult.cac_id' => $acctID,
 'CmpgnResult.cac_has_reviews' => true,
 'CmpgnResult.cc_recorded' => true,
 "CmpgnResult.cc_call_start >= '2009-07-01'"),
                                                 'order' =>
 'CmpgnResult.cc_call_start'));
 }}}

 producess this result set

 {{{
     [7] => Array
         (
             [CmpgnResult] => Array
                 (
                     [cac_id] => 62
                     ....
                     all columns
                 )

         )
 }}}

 now uncommeting the condition from obove query gives me

 {{{
     [0] => Array
         (
             [cac] => Array
                 (
                     [cac_id] => 62
                     ...
                     some columns
                 )

             [CmpgnResult] => Array
                 (
                     [cc_reviewed_call] =>
                     ...
                     some columns
                 )

             [d] => Array
                 (
                     [d_{some compnay name}_gmt_off] => -8
                     one column
                 )

         )
 }}}

-- 
Ticket URL: <https://trac.cakephp.org/ticket/6523#comment:3>
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 
"tickets cakephp" group.
To post to this group, send email to tickets-cakephp@googlegroups.com
To unsubscribe from this group, send email to 
tickets-cakephp+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to