Project

General

Profile

Actions

Defect #30367

closed

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

Added by Pavel Rosický about 5 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Issues filter
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

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


Files

out.txt (8.12 KB) out.txt Pavel Rosický, 2019-01-09 18:49
issue_query.rb.patch (844 Bytes) issue_query.rb.patch Pavel Rosický, 2019-03-06 13:51

Related issues

Related to Redmine - Feature #19395: Support MariaDBNew

Actions
Has duplicate Redmine - Defect #30964: 500 appears when trying to filter by last updated byClosed

Actions
Actions #1

Updated by Marius BĂLTEANU about 5 years ago

Actions #2

Updated by Marius BĂLTEANU about 5 years ago

  • Related to Defect #30964: 500 appears when trying to filter by last updated by added
Actions #3

Updated by Marius BĂLTEANU about 5 years ago

  • Related to deleted (Defect #30964: 500 appears when trying to filter by last updated by)
Actions #4

Updated by Marius BĂLTEANU about 5 years ago

  • Related to Defect #30964: 500 appears when trying to filter by last updated by added
Actions #5

Updated by Marius BĂLTEANU about 5 years ago

  • Related to deleted (Defect #30964: 500 appears when trying to filter by last updated by)
Actions #6

Updated by Marius BĂLTEANU about 5 years ago

  • Has duplicate Defect #30964: 500 appears when trying to filter by last updated by added
Actions #8

Updated by Pavel Rosický about 5 years ago

the fix is fairly simple, Marius please take a look

Actions #9

Updated by Go MAEDA about 5 years ago

  • Subject changed from 2 failures on MariaDB to "Last updated by" filter causes an SQL error with MariaDB
  • Category changed from Database to Issues filter
  • Target version set to 3.4.10

Setting the target version to 3.4.10.

Actions #10

Updated by Mizuki ISHIKAWA about 5 years ago

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.

Actions #11

Updated by Go MAEDA about 5 years ago

  • Status changed from New to Resolved
  • Assignee set to Go MAEDA
  • Resolution set to Fixed

Committed the patch. Thank you for reporting and fixing the issue.

Actions #12

Updated by Go MAEDA about 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF