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)
fix pushed to master
*** Bug 967761 has been marked as a duplicate of this bug. ***