Bug #2648 select count(*) from dosis where match(dosis) against("+Kinder +unter +Monaten"

• Submitted: 5 Feb 2004 2:36
• Modified: 5 Feb 2004 13:36
• Reporter: Jochen May
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 4.0.13
• OS: Linux (Linux)
• CPU Architecture: Any

[5 Feb 2004 2:36] Jochen May

Description:
Hello,

I've defined a table like you see described below. I've loaded data. The results I got with the select statements shown below can't be right as I mean:

mysql> status
--------------
mysql  Ver 12.20 Distrib 4.0.13, for pc-linux (i686)

Connection id:          10095
Current database:       abdaae00
Current user:           abda@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Server version:         4.0.13
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /tmp/mysql.sock
Uptime:                 65 days 22 hours 33 min 53 sec

Threads: 1  Questions: 3419893  Slow queries: 4  Opens: 3996  Flush tables: 1  Open tables: 64  Queries per second avg: 0.600
--------------
mysql> describe dosis;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| TXTND | varchar(15) |      | PRI |         |       |
| DOSIS | text        | YES  | MUL | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql>
mysql> select count(*) from dosis where match(dosis) against("+Kinder +unter +Monaten");
+----------+
| count(*) |
+----------+
|     4084 |
+----------+
1 row in set (0.04 sec)

mysql> select count(*) from dosis where match(dosis) against("+Kinder +unter -Monaten");
+----------+
| count(*) |
+----------+
|     4084 |
+----------+
1 row in set (0.03 sec)

mysql> select count(*) from dosis where match(dosis) against("Kinder unter Monaten");
+----------+
| count(*) |
+----------+
|     4084 |
+----------+
1 row in set (0.04 sec)

mysql>

Sorry for my English. Have you any idea?

Jochen May

How to repeat:
mysql> status
--------------
mysql  Ver 12.20 Distrib 4.0.13, for pc-linux (i686)

Connection id:          10095
Current database:       abdaae00
Current user:           abda@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Server version:         4.0.13
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /tmp/mysql.sock
Uptime:                 65 days 22 hours 33 min 53 sec

Threads: 1  Questions: 3419893  Slow queries: 4  Opens: 3996  Flush tables: 1  Open tables: 64  Queries per second avg: 0.600
--------------
mysql> describe dosis;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| TXTND | varchar(15) |      | PRI |         |       |
| DOSIS | text        | YES  | MUL | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql>
mysql> select count(*) from dosis where match(dosis) against("+Kinder +unter +Monaten");
+----------+
| count(*) |
+----------+
|     4084 |
+----------+
1 row in set (0.04 sec)

mysql> select count(*) from dosis where match(dosis) against("+Kinder +unter -Monaten");
+----------+
| count(*) |
+----------+
|     4084 |
+----------+
1 row in set (0.03 sec)

mysql> select count(*) from dosis where match(dosis) against("Kinder unter Monaten");
+----------+
| count(*) |
+----------+
|     4084 |
+----------+
1 row in set (0.04 sec)

mysql>

[5 Feb 2004 13:36] Alexander Keremidarski

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

+/- operators are valid for BOOLEAN MODE only.