[#9242] - Search filters case sensitive in pgsql
- Closed
- 28 Feb 2016
- Urgent
- Build: master
- # 9242
Steps to reproduce the issue
Go to extensions->install languages
Search for french
Expected result
two languages are found
Actual result
With Mysql you see two languages
With PGSQL you see zero languages
Additional comments
Repeat pgsql test with searching for French and you get matches
@alikon can you take a look please
No - I will apply that now and see if it is resolved by the changes you
made there
On 28 February 2016 at 12:48, andrepereiradasilva notifications@github.com
wrote:
just a question, did you test with this PR #9089
#9089—
Reply to this email directly or view it on GitHub
#9242 (comment).
Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/
Sorry to say that #9089 doesnt resolve it
On 28 February 2016 at 12:49, Brian Teeman brian@teeman.net wrote:
No - I will apply that now and see if it is resolved by the changes you
made thereOn 28 February 2016 at 12:48, andrepereiradasilva <
notifications@github.com> wrote:just a question, did you test with this PR #9089
#9089—
Reply to this email directly or view it on GitHub
#9242 (comment)
.Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/
Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/
sure, it was just a wild guess.
I dont know much about PGSQL neither have the means to test, but maybe the problem should be in this lines? https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_installer/models/languages.php#L128-L129
See this example in com_modules https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_modules/models/modules.php#L373-L374
I think in postgresql we have to use LOWER() but @alikon certainly knows better than me.
if i'm right the same problem exists in other views (ex: newsfeeds, contacts).
Will check after lunch. If you are on a Mac then you can easily use
postgres with http://postgres.app
if i'm right the same problem exists in other views (ex: newsfeeds).
—
Reply to this email directly or view it on GitHub
#9242 (comment).
no mac here i leave postgresql to others.
my interrest is just learn the more noticleble differences in queries between mysql and postgreSQL so when modfiying some code don't make regressions to postgresql.
News feeds is fine
On 28 February 2016 at 13:34, andrepereiradasilva notifications@github.com
wrote:
no mac here i leave postgresql to others.
my interrest in just learn the more noticleble differences in queries
between mysql and postgreSQL so when modfiying some code don't make
regressions to postgresql.—
Reply to this email directly or view it on GitHub
#9242 (comment).
Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/
Looks like this might work http://alvinalexander.com/sql/sql-select-case-insensitive-query-queries-upper-lower but not sure
@alikon should have the answer so I will wait for the maestro
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9242.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-02-28 17:27:21 |
| Closed_By | ⇒ | brianteeman |
Closed as we have a PR #9244
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9242.
Looks like it is only the search filter on the install languages page - the other search filters I tested were all ok
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9242.