Ticket #3790 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

Title/Creators/Journal auto-completion is now case-sensitive

Reported by: sf03r@… Owned by:
Priority: Must do Milestone: EPrints 3.2.1
Component: - Version: 3.2
Severity: normal Keywords:
Cc:

Description

Reported by Sheridan while demo-ing exemplar:

Using the test-data, entering "Observations" show potential duplicates in the repo, while entering "observations" doesn't.

EP 3.2 sets up MySQL to use case-sensitive matching but this makes the autocompletion scripts fail.

Same with the creators field, entering Swan show potential creators, while "swan" doesn't.

Change History

Changed 3 years ago by tdb01r

  • status changed from new to closed
  • resolution set to fixed
  • milestone changed from EPrints 3.2.x (general bugs/features for 3.2) to EPrints 3.2.1

This should be fixed in 3.2.1 by using sql_LIKE which performs a case-insensitive match (at least for mysql/Pg).

Note: See TracTickets for help on using tickets.