Bug #72010 A boolean mode full-text search hindi query would result empty in mysql

• Submitted: 11 Mar 2014 12:32
• Modified: 13 Mar 2014 5:21
• Reporter: Ranbir kumar
• Status: Duplicate
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1, 5.5, 5.6
• OS: Linux (redhat 5.8 and centos)
• CPU Architecture: Any
• Tags: query

[11 Mar 2014 12:32] Ranbir kumar

Description:
A boolean mode full-text search hindi query would result empty in mysql 5.1

How to repeat:
A boolean mode full-text search hindi query would result empty in mysql 5.5.21
A boolean mode full-text search hindi query would result empty in mysql 5.5.15

Suggested fix:
so pls suggest me . how to resolve the issue A boolean mode full-text search hindi query would result empty in mysql 5.1, 5.5.21, 5.6.15

[11 Mar 2014 12:50] MySQL Verification Team

Hi Ranbir,

Thank you for the report.
Isn't this duplicate of Bug #70240? Please let us know.

Thanks,
Umesh

[12 Mar 2014 14:19] Ranbir kumar

Query   |   13 | Waiting for table metadata lock | select SQL_CACHE match(title,description,keywords,browser_title) against ('+ +रामकृपाल*' in boolean mode) as score,title, DATE_FORMAT(datetime,'%M %e,%Y %h:%i %p') AS datetimeformat, storyid, filename, channel_slno,description,keywords,browser_title,slug_intro from DNA_Files_2011_Keywords where edit_flag in (0,1,3) AND match(title,description,keywords,browser_title) against ('+ +रामकृपाल*' in boolean mode) ORDER BY score DESC,datetime DESC LIMIT 20                                 |

[12 Mar 2014 14:20] Ranbir kumar

Query   select SQL_CACHE match(title,description,keywords,browser_title) against ('+ +रामकृपाल*' in boolean mode) as score,title, DATE_FORMAT(datetime,'%M %e,%Y %h:%i %p') AS datetimeformat, storyid, filename, channel_slno,description,keywords,browser_title,slug_intro from DNA_Files_2011_Keywords where edit_flag in (0,1,3) AND match(title,description,keywords,browser_title) against ('+ +रामकृपाल*' in boolean mode) ORDER BY score DESC,datetime DESC LIMIT 20                                 |

[12 Mar 2014 14:22] Ranbir kumar

Query select SQL_CACHE match(title,description,keywords,browser_title) against ('+रामकृपाल*' in boolean mode) as score,title, DATE_FORMAT(datetime,'%M %e,%Y %h:%i %p') AS datetimeformat, storyid, filename, channel_slno,description,keywords,browser_title,slug_intro from DNA_Files_2011_Keywords where edit_flag in (0,1,3) AND match(title,description,keywords,browser_title) against ('+रामकृपाल*' in boolean mode) ORDER BY score DESC,datetime DESC LIMIT 20                                 |

[13 Mar 2014 5:21] MySQL Verification Team

Thank you for the bug report, duplicate of http://bugs.mysql.com/bug.php?id=70240