| Bug #115547 | against('+m\'otorbuch' in boolean mode) no result but it should deliver one | ||
|---|---|---|---|
| Submitted: | 9 Jul 2024 9:04 | Modified: | 9 Jul 2024 10:05 |
| Reporter: | Heinz Schweitzer (Gold Quality Contributor) | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 8.4.0 | OS: | Windows (Microsoft Windows 11 Pro) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | match against | ||
[9 Jul 2024 10:05]
MySQL Verification Team
Hi Mr. Schweitzer, Thanks a lot for your bug report. However, let us inform you that this is a forum for the bug reports with a fully repeatable test cases. Hence, what is needed here is a table `search` that you have used and the explanation why should there be a result of that query. Thanks a lot in advance. Can't repeat.
Description: on a column 'what' a fulltext index is created. searching for pattern match(what) against('m\'otorbuch' in boolean mode) delivers result using match(what) against('+m\'otorbuch' in boolean mode) does not deliver a result. I expect both querys to work How to repeat: Server version: 8.4.0 MySQL Community Server - GPL Copyright (c) 2000, 2024, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select titleid as id from search where colname='verlag' and match(what) against('m\'otorbuch' in boolean mode); +----+ | id | +----+ | 2 | +----+ 1 row in set (0.03 sec) mysql> select titleid as id from search where colname='verlag' and match(what) against('+m\'otorbuch' in boolean mode); Empty set (0.02 sec)