Default ORDER BY via the property Model::$order cause errors on some postgreSQL statements

[rbecheras]

Consider a model as following:

class Zone extends AppModel {

/**
 * $order is the default order for find queries
 *
 * @var string
 */
    public $order = 'reference ASC';
/**
 * Attached Behaviors
 * 
 * @var array
 */
    public $actsAs = array('Tree');

create a new "Zone" element from POST form like :

$this->Zone->save($this->request->data);

will cause a SQL query as the following :

SELECT MAX("Zone"."rght") AS "rght" 
FROM "mpdefault"."zones" AS "Zone" 
WHERE 1 = 1 AND "Zone"."id" <> 126 ORDER BY "reference" ASC LIMIT 1

MySQL will accept it but PostgreSQL will throw this error :

Error: SQLSTATE[42803]: Grouping error: 7 ERROR: column "Zone.reference" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...RE 1 = 1 AND "Zone"."id" <> 126 ORDER BY "reference... ^ 

The only way I found to run my application was to completely remove the property Zone::$order

[markstory]

Closing as #5159 is open now.

[rbecheras]

What a quick reaction ! Thanks @markstory !