Project

General

Profile

Actions
Copy link

Defect #3699

closed

Problem with sqlquery in journal.rb

Added by Łukasz Żbikowski over 15 years ago. Updated about 15 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Eric Davis
Category:
Database
Target version:
-
Start date:
2009-07-31
Due date:
% Done:

70%

Estimated time:
1.00 h
Resolution:
Wont fix
Affected version:
0.8.4

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

Files

journal.rb.diff (1.14 KB) journal.rb.diff journal.rb diff (fixed for ORACLE) Łukasz Żbikowski, 2009-07-31 00:23
Actions
Copy link

Also available in: Atom PDF