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
>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
