Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#3529] - [#33648] Postgres Search case sensitive

? Success

User tests: Successful: Unsuccessful:

avatar Humorlos
Humorlos
29 Apr 2014

Make search in PostgreSQL case insensitive in default parameters

avatar Humorlos Humorlos - open - 29 Apr 2014
avatar mbabker
mbabker - comment - 29 Apr 2014

Is this an issue too with MySQL or SQL Server, or is it just PostgreSQL that experiences this issue? Also, since this change will change the query for all servers, is there any chance it could cause issues with those databases?

avatar Humorlos
Humorlos - comment - 29 Apr 2014

It is only in PostgreSQL – but the function LOWER () is found in MySQL since 5.0 (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html) and MSSQL supports it to (see http://msdn.microsoft.com/de-de/library/ms174400%28v=sql.90%29.aspx) - therefor should have no effect on the other databases.

Outcome shall be, that in default search parameters search is case insensitive. Only in exact search the results shall take care of the cases.

avatar infograf768
infograf768 - comment - 23 Jul 2014

Looks like the issue also exists for Managers:
see:
http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=33560&start=0

avatar nicksavov nicksavov - change - 21 Aug 2014
Title
…
[#33648] Postgres Search case sensitive
[#33648] Postgres Search case sensitive
Labels Removed: ?
avatar brianteeman brianteeman - change - 25 Aug 2014
Status New ⇒ Pending
avatar brianteeman brianteeman - change - 25 Aug 2014
Title
…
[#33648] Postgres Search case sensitive
[#33648] Postgres Search case sensitive
avatar brianteeman brianteeman - change - 25 Aug 2014
Category ⇒ Postgresql
avatar brianteeman brianteeman - change - 3 Sep 2014
Category Postgresql ⇒ Postgresql Search
avatar nicksavov nicksavov - change - 16 Oct 2014
Labels Added: ?
avatar alikon alikon - test_item - 1 Nov 2014 - Tested successfully
avatar alikon
alikon - comment - 1 Nov 2014

@test success

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/3529.

avatar waader
waader - comment - 3 Nov 2014

@test success (postgres, mysql)

remark @infograf768: I can confirm the same problem eg. for the language manager. But to my understanding, that´s not the scope of this patch.

avatar zero-24 zero-24 - alter_testresult - 3 Nov 2014 - alikon: Tested successfully
avatar zero-24 zero-24 - alter_testresult - 3 Nov 2014 - waader: Tested successfully
avatar brianteeman
brianteeman - comment - 27 Nov 2014

Two good tests setting to RTC - thanks

This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/3529.

avatar brianteeman brianteeman - change - 27 Nov 2014
Status Pending ⇒ Ready to Commit
avatar brianteeman brianteeman - change - 29 Nov 2014
Labels Added: ?
avatar Bakual
Bakual - comment - 2 Dec 2014

Merged into staging. Thanks!

avatar Bakual Bakual - close - 2 Dec 2014
avatar Bakual Bakual - close - 2 Dec 2014
avatar Bakual Bakual - change - 2 Dec 2014
Status Ready to Commit ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2014-12-02 19:18:07
avatar Bakual Bakual - change - 2 Dec 2014
Milestone Added:

Add a Comment

Login with GitHub to post a comment