Project

General

Profile

Actions
Copy link

Defect #1199

closed

Internal Error on WorkTime0.2.9 & PostgreSQL

Defect #1199: Internal Error on WorkTime0.2.9 & PostgreSQL

Added by Tomohisa Kusukawa almost 13 years ago. Updated over 12 years ago.

Status:
終了（Closed）
Priority:
今すぐ（Immediate）
Assignee:
Tomohisa Kusukawa
Target version:
0.2.10
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'))))):

Updated by Tomohisa Kusukawa almost 13 years ago Actions
Copy link
 #1

  • Status changed from 担当（Assigned） to 解決（Resolved）
  • % Done changed from 0 to 100

更新履歴 commit:84f27d80a7ff で適用されました。

Updated by Tomohisa Kusukawa almost 13 years ago Actions
Copy link
 #2

  • Status changed from 解決（Resolved） to 終了（Closed）

commit:84f27d80a7ff にてPostgreSQL環境で工数タブが表示できるようになったことを確認しました。

Actions
Copy link

Also available in: PDF Atom