Re: MySQL crashes is fulltext search on with some words.

2002-04-16 Thread Sergei Golubchik 

Hi!

On Apr 16, Erlend Hopso Stromsvik wrote:
 I'm not sure if this has been reported earlier, but my mysql-server goes
 down if I run a query with two 'match against' where one of them
 contains/matches the word 'think'...

Can you create a repeatable test case for this ?

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL crashes is fulltext search on with some words.

2002-04-15 Thread Erlend Hopsø Strømsvik 

I'm not sure if this has been reported earlier, but my mysql-server goes
down if I run a query with two 'match against' where one of them
contains/matches the word 'think'...

It terminates after the first query, but when I change the word 'think' to
'excel' or any other word it works flawlessy. I have written the queries
like this since '... against ('+windows +excel' IN BOOLEAN MODE)' doesn't
work in the 4.0.1 version of MySQL.

I find this pretty strange
If this is solved, are there som places where you can download the 4.0.2
source? I can try and put together a test case if it's not been seen before.
I've resovled the stack dump etc. etc.


From mysql consol:

mysql SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('windows' IN BOOLEAN MODE) AND match (tittel) against ('think' IN BOOLEAN
MODE);
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:1
Current database: DB_GNIST

ERROR 2013: Lost connection to MySQL server during query
mysql SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('windows' IN BOOLEAN MODE) AND match (tittel) against ('excel' IN BOOLEAN
MODE);
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:1
Current database: DB_GNIST

+--+
| count(*) |
+--+
|  149 |
+--+
1 row in set (0.17 sec)

mysql 

mysql SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('windows' IN BOOLEAN MODE) AND match (tittel) against ('excel' IN BOOLEAN
MODE);
+--+
| count(*) |
+--+
|  149 |
+--+
1 row in set (0.16 sec)


Regards
Erlend Stromsvik


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php