Bug #16893 Crash in test 'fulltext_order_by'
Submitted: 30 Jan 2006 11:36 Modified: 10 Feb 2006 21:10
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.18 OS:Other (OpenBSD)
Assigned to: Sergey Vojtovich CPU Architecture:Any

[30 Jan 2006 11:36] Joerg Bruehe
Release build of 4.1.18, based on ChangeSet
  1.2463 06/01/27 13:38:15 kent@mysql.com +1 -0
    Enabled rpl_* tests now when bug fixed

Crash occurred only once:
fulltext_order_by              [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query '(select b.id, b.betreff from t3 b) union
(select b.id, b.betreff from t3 b)
order by match(betreff) against ('+abc') desc' failed with wrong errno 2013 instead of 1191...
mysqltest: At line NNN: unable to send query 'select distinct b.id, b.betreff from t3 b
order by match(betreff) against ('+abc' in boolean mode) desc' (mysql_errno=2002 , errno=61)
(the last lines may be the most important ones)

How to repeat:
Detected by running the test suite.
[3 Feb 2006 10:09] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[7 Feb 2006 19:45] Sergey Vojtovich
Fixed that fulltext query + union results in unexpected behaviour.

Fixed in 4.1.19. This bug was already fixed in 5.0 and up in Semptember 2005.
[10 Feb 2006 21:10] Paul DuBois
Noted in 4.1.19 changelog.

          A <literal>FULLTEXT</literal> query in a
          <literal>UNION</literal> could result in unexpected behavior.
          (Bug #16893)