Ticket #455 (closed defect: wontfix)

Opened 6 years ago

Last modified 6 years ago

search string case sensitivity problem with word "like"

Reported by: anonymous Owned by: unassigned
Priority: normal Milestone:
Component: handlers Version: 1.1.6.2
Severity: normal Keywords:
Cc:

Description

Procedure:

  1. in Search box, type in 'Like' hit 'Search' button
  2. in Search box, type in 'LIKE' hit 'Search' button
  3. in Search box, type in 'like' hit 'Search' button

Observed:
Only 'like' returns results. 'Like' and 'LIKE' do not.

Expected:
Other search terms that I enter do not have this case sensitivity problem. Is it because 'Like' is a SQL query operator / reserved word perhaps?

Change History

Changed 6 years ago by DotMG

  • status changed from new to closed
  • resolution set to wontfix
  • milestone 2.0 deleted

It's a MySQL FullTextSearch problem. The same problem occurs with words like ONCE.

See  http://www.thescripts.com/forum/thread505026.html and  http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

Related ticket: #399

If one wants to reopen this ticket, consider updating #399 instead and leaving this as wontfix, unless a better reason.

Note: See TracTickets for help on using tickets.