Bug #62734 score is different for the same data while using match against in MYSQL 5.0.41
Submitted: 14 Oct 2011 9:27 Modified: 25 Nov 2011 12:47
Reporter: Rama Jalla Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S1 (Critical)
Version:5.0.41-community-log OS:Linux
Assigned to: CPU Architecture:Any

[14 Oct 2011 9:27] Rama Jalla
Description:
Hi,

I am Using Mysql DB - 5.0.41-community-log (MySQL Community Edition (GPL)- x86_64) in Test and Production environments in LINUX environment. We periodically migrate test DB data to production DB in order to maintain data consistency in both the DBs. While migrating we take a dump of TestDB tables (using mysqldump command) and import to Production DB, Data is about 20,00,000 records. And using match() against() functions in the queries. Created Full-Text Index for the columns those are using in match function. But while running the query getting the different scores and different results. Ideally we should have got same result set on two DBs, as we are replicating the same data.
 
Kindly guide me, How I can resolve this issue. I have attached the Query for your reference in "Private comments" section. 

Kindly guide me in this issue.

Thanks in Adv.

Regards,
Rama

How to repeat:
Data is about 20,00,000 records.
[25 Oct 2011 12:47] Valeriy Kravchuk
Nobody is going to fix 5.0.41 in any case. Please, check if this problem is still repeatable with recent versions, 5.0.91+.
[26 Nov 2011 7: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".