Hi,
I have 2 installations of cakePHP on 2 servers.
Both cakePHP versions are 1.1.13.4450
Both PHP were Version 5.2.0.
Then one is updated to PHP Version 5.2.0-8+etch1.
After the update, custom queries which have subqueries started giving
different output.
Here is the example:
PHP Version 5.2.0
pr($this->Application->query('SELECT a.equipment_id FROM (select
equipment_id from chassis group by equipment_id LIMIT 3) as a'));
gives:
Array
(
[0] => Array
(
[chassis] => Array
(
[equipment_id] => 1
)
)
[1] => Array
(
[chassis] => Array
(
[equipment_id] => 2
)
)
[2] => Array
(
[chassis] => Array
(
[equipment_id] => 3
)
)
)
PHP Version 5.2.0-8+etch1.
gives:
(
[0] => Array
(
[a] => Array
(
[equipment_id] => 1
)
)
[1] => Array
(
[a] => Array
(
[equipment_id] => 2
)
)
[2] => Array
(
[a] => Array
(
[equipment_id] => 3
)
)
)
As you can see, in second result, table name is replaced with alias
name.
I'm not sure if this is a bug or what, but I wonder how to get the
same output on both platforms
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
