プロジェクト

全般

プロフィール

Vote #79747

完了

"Last updated by" filter causes an SQL error with MariaDB

Admin Redmine さんが約4年前に追加. 約4年前に更新.

ステータス:
Closed
優先度:
通常
担当者:
-
カテゴリ:
Issues filter_56
対象バージョン:
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
56
version_id:
149
issue_org_id:
30367
author_id:
123153
assigned_to_id:
332
comments:
12
status_id:
5
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
99
ステータス-->[Closed]

説明

feature #6375 doesn't seem to work on MariaDB
Server version: 10.4.0-MariaDB-1:10.4.0+maria~xenial-log mariadb.org binary distribution

I think it probably fails on older mysql versions aswell, but I didn't test it

https://github.com/redmine/redmine/blob/6765505b2d0dd14014988b9b15096a33f5b9b2d1/app/models/issue_query.rb#L382


journals

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
the fix is fairly simple, Marius please take a look
--------------------------------------------------------------------------------
Setting the target version to 3.4.10.
--------------------------------------------------------------------------------
Pavel Rosický wrote:
> the fix is fairly simple, Marius please take a look

Thank you for sharing the patch.
I confirmed that the failed test succeeded by applying your patch.
I also confirmed that the last_updated_by filter works from issues/index screen.
--------------------------------------------------------------------------------
Committed the patch. Thank you for reporting and fixing the issue.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------


related_issues

relates,New,19395,Support MariaDB
duplicates,Closed,30964,500 appears when trying to filter by last updated by

Admin Redmine さんが約4年前に更新

  • カテゴリIssues filter_56 にセット
  • 対象バージョン3.4.10_149 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0