Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

The testQueryCount fails for postgresql #231

Closed
olegabr opened this issue Apr 8, 2013 · 0 comments
Closed

The testQueryCount fails for postgresql #231

olegabr opened this issue Apr 8, 2013 · 0 comments
Assignees
@olegabr
Labels
bug
Milestone
2.2.1 Release

Comments

@olegabr
Copy link
Member

olegabr commented Apr 8, 2013

After merge of feaure-80 to the master, the travis build becomes broken. It is because now it runs tests not only for mysql, but for postgresql too. The testQueryCount fails with message:

E_WARNING: pg_query(): Query failed: ERROR: column "t1.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 10: "t1"."name" ^ in /home/travis/build/qcubed/framework/includes/qcubed/_core/database/QPostgreSqlDatabase.class.php on line 229

it is specific to postgresql build. postgresal dislikes any clauses with fields mentioned, if they doues not appear in some aggregate function, like MAX/MIN.
@ghost ghost assigned olegabr Apr 8, 2013
olegabr added a commit to olegabr/qcubed that referenced this issue Apr 8, 2013
@olegabr
The issue qcubed#231 is fixed
be4e859 
The testQueryCount fails for postgresql
olegabr added a commit that referenced this issue Apr 8, 2013
@olegabr
Merge pull request #232 from olegabr/bug-231
02b312d 
The issue #231 is fixed
@olegabr olegabr closed this as completed Apr 8, 2013
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@olegabr olegabr

Labels
bug
Projects
None yet
Milestone
2.2.1 Release
Development

No branches or pull requests
1 participant
@olegabr