ChiliProject is not maintained anymore. Please be advised that there will be no more updates.
We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.
repositories_helper.rb (Bug #556)
Oracle 11g database
db/migrate/20100705164950_change_changes_path_length_limit.rb changes the columns to text (clob in oracle)
line 42: changes = @changeset.changes.find(:all, :limit => 1000, :order => 'path').collect do |change|
oracle clob columns can not be in the order by unless it is cast to a varchar2 with a substr- I removed the :order => 'path' and it works properly
Thanks fpr your report. Unfortunately, we don't officially support Oracle as a database currently. That said, we are going to accept patches to help compatibility if those doesn't affect the functionality and performance for the other supported databases.
That brings us to your proposed fix. A limited query without an order is never correct, as the database can return an arbitrary set of elements without a specified order. That would lead no incorrect or at least unpredictable results. Because of that, we can not accept that fix as it.
Unless you find another, more correct, fix we would be forced to decline this issue.
- Status changed from Open to Needs more information
the issue is an oracle restriction that a lob column can not be included in an order by, group by, distinct or aggregate statement.
I tested a few possible solutions but they would impact other databases.
The resolution I am testing is to change the PATH and FROM_PATH columns to VARCHAR2 on the CHANGES table, which should be large enough to hold the full path strings.
I will update the forum document on oracle installation in case anyone else encounters this issue.
- Status changed from Needs more information to Closed