Bug #24009 MySQL full-text search is case-sensitive ?

• Submitted: 6 Nov 2006 13:35
• Modified: 7 Dec 2006 10:18
• Reporter: Gayatri
• Status: No Feedback
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.24a-community-nt
• CPU Architecture: Any
• Tags: case-sensitive, full-text

[6 Nov 2006 13:35] Gayatri

Description:
I realised that the full-text search is case-sensitive which is against the documentation from MySQL. 

The following queries fetch different records from the database, though ideally they all should be returning same number of records.

select name, skills from candidate where match(skills) AGAINST ( 'java' )

select name, skills from candidate where match(skills) AGAINST ( 'Java' )

select name, skills from candidate where match(skills) AGAINST ( 'JAVA' )

The database is setup with default Latin1 character set.

Please let me know if there is any change required in the way MySQL is setup.

How to repeat:
select name, skills from candidate where match(skills) AGAINST ( 'java' )

select name, skills from candidate where match(skills) AGAINST ( 'Java' )

select name, skills from candidate where match(skills) AGAINST ( 'JAVA' )

[7 Nov 2006 10:18] Valeriy Kravchuk

Thank you for a problem report. Please, send complete test case that demonstrates the behaviour described. At least, please, send the results of:

SHOW CREATE TABLE candidate;
SHOW VARIABLES LIKE 'char%';
SHOW VARIABLES LIKE 'collat%';

[8 Dec 2006 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".