Bug 955574 - Switching to Advanced/Personal Tasks tab using PostgreSQL causes SQL Error
Summary: Switching to Advanced/Personal Tasks tab using PostgreSQL causes SQL Error
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: Business Central
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
: 6.0.0
Assignee: Maciej Swiderski
QA Contact: Zuzana Krejčová
URL:
Whiteboard:
: 967761 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-04-23 10:15 UTC by Zuzana Krejčová
Modified: 2016-08-01 01:07 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-08-06 20:09:59 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 955596 0 unspecified CLOSED Trying to Reload Repository causes SQL Error with PostgreSQL 2021-02-22 00:41:40 UTC

Internal Links: 955596

Description Zuzana Krejčová 2013-04-23 10:15:54 UTC
Description of problem:

WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-4) SQL Error: 0, SQLState: 42803
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-4) ERROR: column "names5_.text" must appear in the GROUP BY clause or be used in an aggregate function
  Position: 77

This is thrown (twice) every time I open the Personal Tasks tab in the Tasks view (accessed via Advanced button) or click Refresh there.

No Tasks are shown.

Happens with PostgreSQL (9.1), the default db and MySQL seem to be unaffected.


Version-Release number of selected component (if applicable):
BPMS 6.0.0 DR3


Steps to Reproduce:
1. Configure the kie-ide to use PostgreSQL.
2. Start the org.jbpm.writedocument process.
3. As user salaboy, open the Tasks view, click on Advanced, look into the server log.


Additional info:
"PostgreSQL requires everything in the SELECT to be in GROUP BY or an aggregate function, MySQL is looser with this." (http://stackoverflow.com/questions/5453477/postgresql-rails-heroku-column-must-appear-in-group-by?rq=1)

Comment 1 Maciej Swiderski 2013-05-21 09:23:40 UTC
fix pushed to master

Comment 2 Kris Verlaenen 2013-05-31 22:32:43 UTC
*** Bug 967761 has been marked as a duplicate of this bug. ***


Note You need to log in before you can comment on or make changes to this bug.