Project

General

Profile

Defect #1199

Internal Error on WorkTime0.2.9 & PostgreSQL

Added by Tomohisa Kusukawa about 7 years ago. Updated almost 7 years ago.

Status:
終了(Closed)
Priority:
今すぐ(Immediate)
Target version:
Start date:
03/03/2013
Due date:
03/03/2013
% Done:

100%

Estimated time:

Description

ActiveRecord::StatementInvalid (PG::Error: ERROR:  演算子が存在しません: boolean <> integer
LINE 7:                            and ist.is_closed != 1)
                                                     ^
HINT:  指定名称、指定引数型に合う演算子がありません。明示的な型キャストが必要かもし
れません
: SELECT "issues".* FROM "issues" INNER JOIN issue_statuses ist on ist.id = issues.status_id WHERE (1 = 1
                         and ((issues.author_id = 3
                           and issues.created_on >= '2013-03-03 00:00:00.000000'
                           and issues.created_on < '2013-03-04 00:00:00.000000')
                           or (issues.assigned_to_id = 3
                           and issues.start_date < '2013-03-04 00:00:00.000000'
                           and ist.is_closed != 1)
                           or (exists (select 1 from journals
                                       where journals.journalized_id = issues.id
                                         and journals.journalized_type = 'Issue'
                                         and journals.user_id = 3
                                         and journals.created_on >= '2013-03-03 00:00:00.000000'
                                         and journals.created_on < '2013-03-04 00:00:00.000000'))))):

Also available in: Atom PDF