SQL error on "Group By clause" with Postgresql and JRuby
|Affected version:||1.3.1||Resolution:||Wont fix|
I have a SQL error about each Project's Page , which is a little bit boring...
Redmine version is 1.3.1 on Windows XP with jruby 1.6.7
Database is POSTGRESQL 8.4.11
see screenshot to get more informations.
@*** LOCAL GEMS ***
actionmailer (3.2.1, 2.3.5)
actionpack (3.2.1, 2.3.5)
activerecord (3.2.1, 2.3.5)
activeresource (3.2.1, 2.3.5)
activesupport (3.2.1, 2.3.5)
i18n (0.6.0, 0.4.2)
jdbc-postgres (9.1.901, 8.4.701 java)
json (1.6.5 java)
rails (3.2.1, 2.3.5)
rake (0.9.2.2, 0.8.7)
sprockets (2.3.1, 2.1.2)
#1 Updated by Jean-Philippe Lang about 1 year ago
- Subject changed from SQL error on "Group By clause" with POSTGRESQL 8.4.11 - updated to SQL error on "Group By clause" with Postgresql and JRuby
- Category changed from Database to Ruby support
- Priority changed from High to Normal
Redmine just doesn't work with JRuby+PostgreSQL.
Use one of the ruby interperters that is currently supported.
#3 Updated by Milton Taylor about 1 year ago
It's taken me a couple of solid days debugging and unravelling the postgres jdbc adapter, but I have just about got to the bottom of the problems it seems to have. I've got virtually all the redmine unit tests passing now, with the exception of a very small number of 'group by' queries. I'm hoping those won't be too hard to crack now.
#4 Updated by Milton Taylor about 1 year ago
OK I think I have fixed this "group by" problem too. For anyone wanting to try this out, replace
with the amended version I have uploaded to the jira bug report:
JPL: I assume you will want to wait until an official fix comes out from the activerecord-jdbc guys, but you might consider making a note about this somewhere in the wiki?