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

 When using find() method on views the array returns splits into three
 different indexes right after I add one condition to the query
 'viewname.column' => $passedValue, if I remove this conidtion I get one
 index to reach columns.  That's how the returned record looks like with
 the condtion
 $rec['index1']['col1'],
 $rec['index1']['col2']
 ...
 $rec['index2']['col10'],
 $rec['index2']['col11']
 ...
 $rec['index3']['col20'].
 While without the contion I get
 $rec['index1']['col1'],
 $rec['index1']['col2']
 ...
 $rec['index1']['col10'],
 $rec['index1']['col11']
 ...
 $rec['index1']['col20'].

 This bug coused me to move my application from one server to another. I
 was using PHP5 before and couldn't narrow it down so I though it was PHP
 or server configuration.  Before moving the application the behaving was
 different as it wasn't based on the condition - just indexes were
 differnet.  On my local machine the results coming back were
 $rec['viewName']['colName'] on the hosted server it was
 $rec['0']['colName'].  I tough it was the hosting server that was the
 issues until I added this condition now, it became clear to me that it was
 the cake causing this weird behavior.

 I noticed that the names of the indexes are first part of the
 two/three/four word made of underscores. If I have two tables 1) cars with
 a column name and 2) roads with a column name and create a things view out
 of them with c_name and r_name for car and road names.  The record
 returned, after adding the condition, would be $rec['r']['rame'] and
 $rec['c']['c_name'] instead of $rec['Thing']['c_name'] and
 $rec['Thing']['r_name'].

 I'm sorry for confusing people with as I conbined two bugs into one, sort
 of.  To summarize two months ago I moved my application because indexes
 were different on my local machine then hosting server.  At that time it
 wasn't split into 3 different ones like I get one just one was different
 name instead of 'viewName' I had '0'.  Now the behavior was different as
 there is three different indexes for one view but I believe these two are
 connected somehow as it always happenes on the views and not tables.

-- 
Ticket URL: <https://trac.cakephp.org/ticket/6523>
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