Bug #29811 'make test' fulltext test fails
Submitted: 15 Jul 2007 19:25 Modified: 16 Jul 2007 13:08
Reporter: Liam Gretton Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.0.45 OS:Linux (SuSE 9.3 (i586))
Assigned to: CPU Architecture:Any
Tags: fulltext test

[15 Jul 2007 19:25] Liam Gretton
Description:
After a successful build, the fulltext test fails, as executed by the 'make test' procedure. MySQL installs and generally functions without problems afterwards, but I believe it affects the way MediaWiki's searchindex table operates - I won't elaborate as I have little evidence regarding MediaWiki's problem at the moment.

I notice in the bugs database that this has been reported before - bug #6304.

Here's the output from make test, when fulltext fails:

fulltext                       [ fail ]

Errors are (from /home/public/mysql-5.0.45/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/fulltext.result   Wed Jul  4 16:49:09 2007
--- r/fulltext.reject   Sun Jul 15 22:19:12 2007
***************
*** 11,18 ****
  t1    1       a       2       b       NULL    NULL    NULL    NULL    YES     FULLTEXT
  select * from t1 where MATCH(a,b) AGAINST ("collections");
  a     b
- Only MyISAM tables    support collections
  Full-text indexes     are called collections
  explain extended select * from t1 where MATCH(a,b) AGAINST ("collections");
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t1      fulltext        a       a       0               1       Using where
--- 11,18 ----
  t1    1       a       2       b       NULL    NULL    NULL    NULL    YES     FULLTEXT
  select * from t1 where MATCH(a,b) AGAINST ("collections");
  a     b
  Full-text indexes     are called collections
+ Only MyISAM tables    support collections
  explain extended select * from t1 where MATCH(a,b) AGAINST ("collections");
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t1      fulltext        a       a       0               1       Using where
***************
*** 166,173 ****
  Function MATCH ... AGAINST()  is used to do a search
  select * from t1 where MATCH(a,b) AGAINST ("collections") UNION ALL select * from t1 where MATCH(a,b) AGAINST ("indexes");
  a     b
- Only MyISAM tables    support collections
  Full-text indexes     are called collections
  Full-text indexes     are called collections
  delete from t1 where a like "MySQL%";
  update t1 set a='some test foobar' where MATCH a,b AGAINST ('model');
--- 166,173 ----
  Function MATCH ... AGAINST()  is used to do a search
  select * from t1 where MATCH(a,b) AGAINST ("collections") UNION ALL select * from t1 where MATCH(a,b) AGAINST ("indexes");
  a     b
  Full-text indexes     are called collections
+ Only MyISAM tables    support collections
  Full-text indexes     are called collections
  delete from t1 where a like "MySQL%";
  update t1 set a='some test foobar' where MATCH a,b AGAINST ('model');
***************
*** 369,375 ****
  t     collation(t)
  SELECT t, collation(t),FORMAT(MATCH t AGAINST ('Osnabruck'),6) FROM t1 WHERE MATCH t AGAINST ('Osnabruck');
  t     collation(t)    FORMAT(MATCH t AGAINST ('Osnabruck'),6)
! aus Osnabrück utf8_general_ci 1.591140
  alter table t1 modify t varchar(200) collate latin1_german2_ci not null;
  Warnings:
  Warning       1366    Incorrect string value: '\xD0\xAD\xD1\x82\xD0\xBE...' for column 't' at row 3
--- 369,375 ----
  t     collation(t)
  SELECT t, collation(t),FORMAT(MATCH t AGAINST ('Osnabruck'),6) FROM t1 WHERE MATCH t AGAINST ('Osnabruck');
  t     collation(t)    FORMAT(MATCH t AGAINST ('Osnabruck'),6)
! aus Osnabrück utf8_general_ci 0.000000
  alter table t1 modify t varchar(200) collate latin1_german2_ci not null;
  Warnings:
  Warning       1366    Incorrect string value: '\xD0\xAD\xD1\x82\xD0\xBE...' for column 't' at row 3
***************
*** 450,459 ****
  PREPARE stmt from "SELECT a, FORMAT(MATCH(a) AGAINST('test1 test'),6) FROM t1 WHERE MATCH(a) AGAINST('test1 test')";
  EXECUTE stmt;
  a     FORMAT(MATCH(a) AGAINST('test1 test'),6)
! test1 0.685267
  EXECUTE stmt;
  a     FORMAT(MATCH(a) AGAINST('test1 test'),6)
! test1 0.685267
  DEALLOCATE PREPARE stmt;
  DROP TABLE t1;
  CREATE TABLE t1 (a VARCHAR(255), FULLTEXT(a));
--- 450,459 ----
  PREPARE stmt from "SELECT a, FORMAT(MATCH(a) AGAINST('test1 test'),6) FROM t1 WHERE MATCH(a) AGAINST('test1 test')";
  EXECUTE stmt;
  a     FORMAT(MATCH(a) AGAINST('test1 test'),6)
! test1 0.000000
  EXECUTE stmt;
  a     FORMAT(MATCH(a) AGAINST('test1 test'),6)
! test1 0.000000
  DEALLOCATE PREPARE stmt;
  DROP TABLE t1;
  CREATE TABLE t1 (a VARCHAR(255), FULLTEXT(a));
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Result from queries before failure can be found in r/fulltext.log

Aborting: fulltext failed in default mode. To continue, re-run with '--force'.
Stopping All Servers
make: *** [test-ns] Error 1

How to repeat:
configure
make
make test
[15 Jul 2007 19:28] Liam Gretton
mysql-test/r/fulltext.log - results of fulltext test

Attachment: fulltext.log (application/octet-stream, text), 18.08 KiB.

[16 Jul 2007 9:02] Sveta Smirnova
Thank you for the report.

Verified as described using last BK sources.
[16 Jul 2007 9:56] Sveta Smirnova
Bug is repatable on our sles9-x86 as reporter described: configure without options.
[16 Jul 2007 10:16] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of Bug #11513
[16 Jul 2007 10:18] Sveta Smirnova
Real problem is gcc bug.

You should use optimization flag -O2 to successfully build MySQL on SUSE 9.

For additional information see bug #11513
[16 Jul 2007 13:08] Liam Gretton
Yes, that solves the problem.

Many thanks Sveta, for the very fast response to this. Apologies for the duplicate bug, I didn't spot #11513 when I searched.