| Bug #6304 | fulltext failed during make test | ||
|---|---|---|---|
| Submitted: | 28 Oct 2004 12:55 | Modified: | 28 Oct 2004 16:35 |
| Reporter: | [ name withheld ] | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Compiling | Severity: | S2 (Serious) |
| Version: | 4.1.17 | OS: | Linux (Linux SuSE 9.1) |
| Assigned to: | CPU Architecture: | Any | |
[28 Oct 2004 14:29]
MySQL Verification Team
I tested for BK source and I wasn't able to repeat. I will test using our package tarball which I assume you are used.
[28 Oct 2004 15:35]
[ name withheld ]
I used "mysql-4.1.7.tar.gz". Downloaded yesterday on 27 October 2004.
[28 Oct 2004 16:35]
MySQL Verification Team
Testing the tarball on Slackware I wasn't able to repeat. My colleague Hartmut will test on Suse 9.1 for to see is OS specific. Thanks
[1 Aug 2005 9:42]
Sivakumar K
I am facing the same problem. This is a SuSE specific issue and is observed in 4.1.13 of the mysql code. The same tests pass in redhat machines.
Some details of the issue are:
A snipped from the diff output ::
-------------------------------------------------------
*** r/fulltext.result 2005-07-23 03:07:18.000000000 +0300
--- r/fulltext.reject 2005-08-01 13:14:05.647559216 +0300
***************
insert t1 values ("aaa10 bbb20"), ("aaa20 bbb15"), ("aaa30 bbb10");
select * from t1 where match a against ("+aaa* +bbb*" in boolean mode);
a
- aaa10 bbb20
- aaa20 bbb15
- aaa30 bbb10
select * from t1 where match a against ("+aaa* +bbb1*" in boolean mode);
a
- aaa20 bbb15
- aaa30 bbb10
select * from t1 where match a against ("+aaa* +ccc*" in boolean mode);
a
select * from t1 where match a against ("+aaa10 +(bbb*)" in boolean mode);
a
- aaa10 bbb20
select * from t1 where match a against ("+(+aaa* +bbb1*)" in boolean mode);
a
- aaa20 bbb15
- aaa30 bbb10
select * from t1 where match a against ("(+aaa* +bbb1*)" in boolean mode);
a
- aaa20 bbb15
- aaa30 bbb10
**** The line "select * from t1 where match a against ("+aaa* +bbb*" in boolean mode)"
is causing the error - the output from this seems to be no rows. - looks like the select's are not returning any values.
Description: Hello, I have compiled the new stable release 4.1.17 on SuSE 9.1 with only prefix and localstatedir. 'configure' and 'make' was ok, but 'make test'. 'make test' fails during fulltext test with: Errors are (from /programme/sources/lamp/mysql-4.1.7/mysql-test/var/log/mysqltest-time) : /programme/sources/lamp/mysql-4.1.7/client/.libs/mysqltest: At line 291: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/fulltext.result 2004-10-23 10:51:03.000000000 +0300 --- r/fulltext.reject 2004-10-27 14:22:15.085511040 +0300 *************** *** 11,18 **** t1 1 a 2 b NULL NULL NULL NULL YES FULLTEXT select * from t1 where MATCH(a,b) AGAINST ("collections"); a b . . . . ------------------------------------------------------- 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. Aborting: fulltext failed. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished If I install (make install) everything seems to be ok, mysqld can be started. But i don't know, if fulltext function will work without any problem. How to repeat: Repeat "make test"