"rick" has kicked AR/Oracle while it was down...
ActiveRecord::StatementInvalid: OCIError: ORA-01791: not a SELECTed expression: SELECT DISTINCT projects.id FROM projects LEFT OUTER JOIN developers_projects ON developers_projects.project_id = projects.id LEFT OUTER JOIN developers ON developers.id = developers_projects.developer_id ORDER BY projects.id, developers.created_at
From the looks of it, Oracle has the same requirement as Postgresql,
where it requires the order by columns in a distinct query to be in
the select clause. However, this won't be the same unless you can
define a seperate distinct clause from the select clause like I did
SELECT DISTINCT ON (projects.id) projects.id, developers.created_at...
Does anything like this exist for Oracle? The solutions I'm seeing
involve either subqueries or aggregates.