#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
-~----------~----~----~----~------~----~------~--~---
