Hello,
I think this is the different mysql version problem.
sawa írta:
> 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
>
>
> >
>
--
Ámon Tamás
http://linkfelho.amon.hu
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
