Defect #3699
Problem with sqlquery in journal.rb
| Status: | Closed | Start date: | 2009-07-31 | ||
|---|---|---|---|---|---|
| Priority: | Normal | Due date: | |||
| Assignee: | Eric Davis | % Done: | 70% |
||
| Category: | Database | ||||
| Target version: | - | Estimated time: | 1.00 hour | ||
| Affected version: | 0.8.4 | Resolution: | Wont fix |
Description
I noticed that problem on IRC channel... then created that solution.
In Oracle DB RM throws SQL error.
It's caused by
"#{Journal.table_name}.notes <> ''"
In Oracle DB RoR text is translated to CLOB...
Unfortunately Oracle CLOB cannot be compared with string like that...
solution is:
length(#{Journal.table_name}.notes)>0
tested with PgSQL.
Should also work with other DB.
My diff (RM 8.4) in the attachment
journal.rb.diff - journal.rb diff (fixed for ORACLE)
(1.1 kB)
History
#1 Updated by Ben Wagaman over 2 years ago
+1
I have the same issue with Oracle. After applying this patch, the issue is fixed in Oracle for me as well. Thank you.
#2 Updated by Jean-Philippe Lang over 2 years ago
- Status changed from New to Closed
- Resolution set to Wont fix
Oracle is not supported. Sorry.