#1635: Query work in mysql, not in postgresql
-----------------------------------+----------------------------------------
Reporter: sikkle | Owner: romanb
Type: defect | Status: new
Priority: minor | Milestone: Unknown
Component: Query/Hydration | Version: 1.0.3
Keywords: postgresql query | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
-----------------------------------+----------------------------------------
That query work into mysql, but not into postgresql.
error //
SQLSTATE[42803]: Grouping error: 7 ERROR: column "b.title" must appear in
the GROUP BY clause or be used in an aggregate function
action//
public function executeIndex($request)
{
$this->posts = Doctrine::getTable('BlogPost')->getAll();[[BR]]
}
model //
public function getAll()
{
return Doctrine_Query::create()->[[BR]]
select('p.title, p.slug, p.body, p.author, p.created_at, count(c.id)
numcomments')->
from('BlogPost p, p.BlogComment c')->
orderBy('p.created_at DESC')->
groupBy('p.id')->
execute();
}
Schema //
BlogPost:[[BR]]
actAs:[[BR]]
Sluggable:[[BR]]
fields: [title][[BR]]
Timestampable:[[BR]]
columns:[[BR]]
title: string(255)[[BR]]
body: clob[[BR]]
author: string(255)[[BR]]
BlogComment:[[BR]]
actAs: [Timestampable][[BR]]
columns:[[BR]]
blog_post_id: integer[[BR]]
author: string(255)[[BR]]
email: string(255)[[BR]]
content: clob[[BR]]
relations:[[BR]]
BlogPost:[[BR]]
class: BlogPost[[BR]]
local: blog_post_id[[BR]]
foreign: id[[BR]]
foreignType: many[[BR]]
type: one[[BR]]
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1635>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" 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.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
