Project

General

Profile

Actions
Copy link

Defect #30367

closed

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

Added by Pavel Rosický almost 6 years ago. Updated almost 6 years ago.

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

0%

Estimated time:
Resolution:
Fixed
Affected version:
4.0.0

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

Download all 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
Copy link
 #1

Updated by Marius BĂLTEANU almost 6 years ago

Actions
Copy link
 #2

Updated by Marius BĂLTEANU almost 6 years ago

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

Updated by Marius BĂLTEANU almost 6 years ago

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

Updated by Marius BĂLTEANU almost 6 years ago

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

Updated by Marius BĂLTEANU almost 6 years ago

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

Updated by Marius BĂLTEANU almost 6 years ago

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

Updated by Pavel Rosický almost 6 years ago

the fix is fairly simple, Marius please take a look

Actions
Copy link
 #9

Updated by Go MAEDA almost 6 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
Copy link
 #10

Updated by Mizuki ISHIKAWA almost 6 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
Copy link
 #11

Updated by Go MAEDA almost 6 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
Copy link
 #12

Updated by Go MAEDA almost 6 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF