Hey Manticore Community,
I am trying to extend our search results wich exceptions or wordforms. Neither of them works for me and I do not know what the Problem is. I implemented like so
and added to exceptions:
Polster => Kissen
and to wordform:
Polster > Kissen
The path is correct and I rotated the table + restarted manticore… nothing helps
Hi. Can you provide a printout of your query and the result which demonstrates that it’s not working?
Hey Sergey thank you for your fast response.
My Search Query looks like this
SELECT * FROM objects_de WHERE MATCH('"Polster"') AND REGEX(maincatalog, '5b901Dev|AndiDev|2a10859dffc5916631b2e27266f161ef|7d81a|fb3483aa57d7fbdcae0828472b683531|2304a|24992eb534cffcfe6bafdc57f6c1a49d|7dda5|6f404e8a0bb468dba3098ffa60f5acba|143799dbd2ddcbd8ae0f1934000bf248|45199|5146b|a36fa45bfbcb3a3eb4ea74bd60452977|36a7d59c2a26c3482e74d0d62d326e7f|babcc|fa1be21c4f80fb2f8b229dca2816d5f6|ac9f6|fc06eba748ec04e24dd5973430ad17a7|eb8d891367e87b9927ab7ec14a8af050|fbf7a|361d0|e3af4aac2d665ac76f8a3b210d91162d|644cc|83431128947fa530d8e172235240540d|3987d|14e61|675474351bb08ff01ba52802d4548173|71e3f|31202f76b785bc46b9daa6a5902e05a4|5533c|e9519|1932020bd014bc45d03c76b8c73ff025|af9ec|644ccit|644ccnl|644ccpl|644ccsk|83431128947fa530d8e17223524054fr|966a47d54e0b254dd9a9efd2fb69dec8|6f814|b15f5|85e709d8ccc78dc7859deda0cdd63d4d|aaaaa|aaaab|77611|ceda7cf57ecc60ea3d817da054820829|40872|e4271a55fd51b22ef2ac4df07c439f47|52b134cc0e4830328a572d871548d625|7bcbd|717ca8e1745ff6cfcc59fdd2346280df|9ddbf|a0e86|5b90f|5b90i|5b90nl|5b90pl|5b90sk|bbbfr|bbbit|bbbsk|5b911Dev|1277c358c1138b876fcec5cb48fa94a3|63e8e|cbaf460e7f3bc6fbe7f7ef849b34f4aa|e67f0|166f7|22679398192af1faea12c2c63491227b|6fc8ca7f089b356010eecbfd554be34e|d97e3|1984480425c4c11728f67128a9c74591|5b901|7d3cbb54f4f73cd9d83012fcb6bc0a6f|f3f8d|||1c38c6a4a160cc375db174aed1c60806|a0193|5fe4c|896c1|5ef3beca513d27fdb7f721d6384579d9|bd02a|testid|babcca|d3bfb|e29cd6f751e1ad79c42d976ab3ba41ff|4f334e9098b9ea62d7a59916ebd70f75|47765720b802402b7ee0010f9faa8d6d|d8cece5a11627b4b4ab1a4e2976e6578|bb5bc53cbb6a1e8d23b3aa262957dc7b|b3c7996ad575097c5abb426313406fa1|ec415|cb2a3|79951f669f6ffc2fc70e0005dfd06bab|1f83375cf673ed76c59007761e0a13ac|cf6f8|39e61|68de5bcb468538e0811fdd9d22230f4f') ORDER BY Name ASC LIMIT 0 , 60 OPTION field_weights=(name=10, maincatalog=1, itempath=3, manufacturer=9, articlenumber=9, classname=1, expltext=1, decltext=1), max_matches = 60;
And this is my Result
+-------------------+--------------------------------------+--------------------------------------+---------------------------------------------------+-------------+------------------------------------------------------------+--------------+---------------+----------+----------+------------+------------+-----------+------------+-----------------+----------------------------------+
| id | itemid | previewid | name | maincatalog | itempath | manufacturer | articlenumber | expltext | decltext | sizex | sizey | sizez | creation | classname | contenthash |
+-------------------+--------------------------------------+--------------------------------------+---------------------------------------------------+-------------+------------------------------------------------------------+--------------+---------------+----------+----------+------------+------------+-----------+------------+-----------------+----------------------------------+
| 99896826963862551 | 23851c7a-91b7-11ed-aaf8-00155dfe333b | e5e0992c-de77-11eb-983c-48dc2d08332b | Bank 4 + Polster | af9ec | Interior + Design/Wohnen/Kleinmöbel/Einzelbänke/0007.pos | | | | | 140.000000 | 58.810635 | 93.000000 | 1673443469 | CMStretchObject | d8b29be46300ce8a6d82d63ceec36391 |
| 99896826963862314 | 21495fc7-91b7-11ed-aaf8-00155dfe333b | b3b92b36-de77-11eb-983c-48dc2d08332b | Eckbank 2 + Polster | af9ec | Interior + Design/Wohnen/Kleinmöbel/Eckbänke/0007.pos | | | | | 190.038437 | 150.152252 | 93.107430 | 1673443469 | CMStretchObject | 48f0794bfd61252e9dafc3eadcefdc21 |
| 99896826963868377 | 57477e31-91b8-11ed-aaf8-00155dfe333b | 19fdb8e9-df01-11eb-983c-48dc2d08332b | Sessel Freischwinger Stahlrohr 1 + Polster | af9ec | Interior + Design/Wohnen/Stühle + Liegen/Sessel/0034.pos | | | | | 64.078613 | 81.946960 | 83.967056 | 1673443469 | CMObject | 5bbd652f39c78d9f525c4d43793dc456 |
| 99896826963868408 | 57a36d9d-91b8-11ed-aaf8-00155dfe333b | 205039da-df01-11eb-983c-48dc2d08332b | Sessel Freischwinger Stahlrohr 1 Hocker + Polster | af9ec | Interior + Design/Wohnen/Stühle + Liegen/Sessel/0036.pos | | | | | 54.818779 | 63.666447 | 43.553898 | 1673443469 | CMObject | 29f80c9e479ac7ce231eb06c3a2fa0bb |
+-------------------+--------------------------------------+--------------------------------------+---------------------------------------------------+-------------+------------------------------------------------------------+--------------+---------------+----------+----------+------------+------------+-----------+------------+-----------------+----------------------------------+
I hope that is what you asked for.
I expected Kissen as reponse too.
Thanky you
Please show a query which finds the document with Kissen which the query with MATCH() cannot find (e.g. select * from ... where id = ...). Note that you can use markdown syntax here on the forum so your code looks better.
Here is the Query for Kissen
SELECT * FROM objects_de WHERE MATCH('"Kissen"') AND REGEX(maincatalog, '5b901Dev|AndiDev|2a10859dffc5916631b2e27266f161ef|7d81a|fb3483aa57d7fbdcae0828472b683531|2304a|24992eb534cffcfe6bafdc57f6c1a49d|7dda5|6f404e8a0bb468dba3098ffa60f5acba|143799dbd2ddcbd8ae0f1934000bf248|45199|5146b|a36fa45bfbcb3a3eb4ea74bd60452977|36a7d59c2a26c3482e74d0d62d326e7f|babcc|fa1be21c4f80fb2f8b229dca2816d5f6|ac9f6|fc06eba748ec04e24dd5973430ad17a7|eb8d891367e87b9927ab7ec14a8af050|fbf7a|361d0|e3af4aac2d665ac76f8a3b210d91162d|644cc|83431128947fa530d8e172235240540d|3987d|14e61|675474351bb08ff01ba52802d4548173|71e3f|31202f76b785bc46b9daa6a5902e05a4|5533c|e9519|1932020bd014bc45d03c76b8c73ff025|af9ec|644ccit|644ccnl|644ccpl|644ccsk|83431128947fa530d8e17223524054fr|966a47d54e0b254dd9a9efd2fb69dec8|6f814|b15f5|85e709d8ccc78dc7859deda0cdd63d4d|aaaaa|aaaab|77611|ceda7cf57ecc60ea3d817da054820829|40872|e4271a55fd51b22ef2ac4df07c439f47|52b134cc0e4830328a572d871548d625|7bcbd|717ca8e1745ff6cfcc59fdd2346280df|9ddbf|a0e86|5b90f|5b90i|5b90nl|5b90pl|5b90sk|bbbfr|bbbit|bbbsk|5b911Dev|1277c358c1138b876fcec5cb48fa94a3|63e8e|cbaf460e7f3bc6fbe7f7ef849b34f4aa|e67f0|166f7|22679398192af1faea12c2c63491227b|6fc8ca7f089b356010eecbfd554be34e|d97e3|1984480425c4c11728f67128a9c74591|5b901|7d3cbb54f4f73cd9d83012fcb6bc0a6f|f3f8d|||1c38c6a4a160cc375db174aed1c60806|a0193|5fe4c|896c1|5ef3beca513d27fdb7f721d6384579d9|bd02a|testid|babcca|d3bfb|e29cd6f751e1ad79c42d976ab3ba41ff|4f334e9098b9ea62d7a59916ebd70f75|47765720b802402b7ee0010f9faa8d6d|d8cece5a11627b4b4ab1a4e2976e6578|bb5bc53cbb6a1e8d23b3aa262957dc7b|b3c7996ad575097c5abb426313406fa1|ec415|cb2a3|79951f669f6ffc2fc70e0005dfd06bab|1f83375cf673ed76c59007761e0a13ac|cf6f8|39e61|68de5bcb468538e0811fdd9d22230f4f') ORDER BY Name ASC LIMIT 0 , 60 OPTION field_weights=(name=10, maincatalog=1, itempath=3, manufacturer=9, articlenumber=9, classname=1, expltext=1, decltext=1), max_matches = 60;
and this is the Result
+-------------------+--------------------------------------+--------------------------------------+-----------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+--------------+---------------+----------+----------+------------+------------+------------+------------+-----------------+----------------------------------+
| id | itemid | previewid | name | maincatalog | itempath | manufacturer | articlenumber | expltext | decltext | sizex | sizey | sizez | creation | classname | contenthash |
+-------------------+--------------------------------------+--------------------------------------+-----------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+--------------+---------------+----------+----------+------------+------------+------------+------------+-----------------+----------------------------------+
| 99896826963886942 | da1b09d7-7ea5-11ec-acab-00155dfe3423 | 1f47c3b3-d64b-11eb-983c-48dc2d08332b | 002_Sofa mit Kissen | 63e8e | Palette@Home/Ofenplaner/Ofen und Kamin/006_Polstermöbel/0001.pos | | | | | 216.918854 | 101.343460 | 88.926193 | 1643194168 | CMObject | 31dba8e09b3c41cb7114aaecdcde319e |
| 99896826963887947 | e137c3d3-7ea5-11ec-acab-00155dfe3423 | 325b9bd2-d64b-11eb-983c-48dc2d08332b | 002_Sofa mit Kissen | 63e8e | Palette@Home/Wohnplaner/Einrichtungskataloge/003_Polstermöbel/0001.pos | | | | | 216.918854 | 101.343460 | 88.926193 | 1643194168 | CMObject | 01fd0dd82dc329ca379e9a021c77f79f |
| 99896826963888387 | e48fddce-671a-11ed-aaf8-00155dfe333b | d635a954-2950-11ed-985f-48dc2d08332d | 031_Kissen | 5b911Dev | Palette Rooms/Einrichtungskataloge/005_Wohnräume/020_Schlafzimmer/0030.pos | | | | | 77.664398 | 37.321098 | 18.623501 | 1668759962 | CMStretchObject | 0c019c44edc2951859880eb85a25457a |
| 99896826963863927 | 2ed3eb89-7ea6-11ec-acab-00155dfe3423 | | 061_Kissen | 166f7 | Palette@Home PRO/Wohnplaner/Einrichtungskataloge/009_Schlafzimmer/009_Schlafzimmer_0027.pos | | | | | 77.664398 | 37.321098 | 18.623501 | 1643194168 | CMStretchObject | 187011ec97935f9898a1f00ba6c7121a |
| 99896826963860040 | 0f438deb-91b9-11ed-aaf8-00155dfe333b | 0c57d340-d61a-11eb-983c-48dc2d08332b | 40105 Conseta Sesselkorpus 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0054.pos | Cor | 40105 | | 40105 | 106.200005 | 86.551598 | 65.219688 | 1673443469 | CMObject | 464817ad9c822eeab9d8d2f677f57598 |
| 99896826963860116 | 0fde1e97-91b9-11ed-aaf8-00155dfe333b | 0c57d347-d61a-11eb-983c-48dc2d08332b | 40160 Conseta Sesselkorpus 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0061.pos | Cor | 40160 | | 40160 | 61.200001 | 86.551598 | 65.219688 | 1673443469 | CMObject | 60a66b3bea7b33cf92b3813f44f7c524 |
| 99896826963860209 | 1090d561-91b9-11ed-aaf8-00155dfe333b | 0c57d34e-d61a-11eb-983c-48dc2d08332b | 40170 Conseta Sesselkorpus 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0068.pos | Cor | 40170 | | 40170 | 71.200005 | 86.551598 | 65.219688 | 1673443469 | CMObject | 9cd9ef7b458d7debc9c9518a5a56b293 |
| 99896826963860222 | 10a6dee0-91b9-11ed-aaf8-00155dfe333b | 0c57d34f-d61a-11eb-983c-48dc2d08332b | 40180 Conseta Sesselkorpus 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0069.pos | Cor | 40180 | | 40180 | 81.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | b5bd6fe5b6ee6866cd025f66aec870bc |
| 99896826963860238 | 10bbefa2-91b9-11ed-aaf8-00155dfe333b | 0c57d350-d61a-11eb-983c-48dc2d08332b | 40190 Conseta Sesselkorpus 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0070.pos | Cor | 40190 | | 40190 | 91.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | 0a04542186e7d06e9b072d0e5a62e2ef |
| 99896826963860246 | 10cfff47-91b9-11ed-aaf8-00155dfe333b | 0c57d351-d61a-11eb-983c-48dc2d08332b | 40210 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0071.pos | Cor | 40210 | | 40210 | 211.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | 4e80f6cd5043ce539ca4a7f6d6e2cb47 |
| 99896826963860257 | 10e41cf1-91b9-11ed-aaf8-00155dfe333b | 0c57d352-d61a-11eb-983c-48dc2d08332b | 40219 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0072.pos | Cor | 40219 | | 40219 | 211.199997 | 96.551598 | 65.219688 | 1673443469 | CMObject | 9a7c4536228e6fb72fe66165ba455b13 |
| 99896826963860289 | 1120512a-91b9-11ed-aaf8-00155dfe333b | 0c57d355-d61a-11eb-983c-48dc2d08332b | 40260 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0075.pos | Cor | 40260 | | 40260 | 121.200005 | 86.551598 | 65.219688 | 1673443469 | CMObject | 5b29286af8861277ca36bb1b2fe6f23a |
| 99896826963860300 | 11341233-91b9-11ed-aaf8-00155dfe333b | 0c57d356-d61a-11eb-983c-48dc2d08332b | 40270 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0076.pos | Cor | 40270 | | 40270 | 141.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | 8cc267410772d6c2571b6fd90e64f00c |
| 99896826963860320 | 115c0258-91b9-11ed-aaf8-00155dfe333b | 0c57d358-d61a-11eb-983c-48dc2d08332b | 40280 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0078.pos | Cor | 40280 | | 40280 | 161.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | 73875efd1a70bd67e35a4b705963f527 |
| 99896826963860332 | 1171b64c-91b9-11ed-aaf8-00155dfe333b | 0c57d359-d61a-11eb-983c-48dc2d08332b | 40289 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0079.pos | Cor | 40289 | | 40289 | 161.199997 | 96.551598 | 65.219688 | 1673443469 | CMObject | 0d29b764938b824f81955d29b51cb1fa |
| 99896826963860339 | 11878d0f-91b9-11ed-aaf8-00155dfe333b | 0c57d35a-d61a-11eb-983c-48dc2d08332b | 40290 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0080.pos | Cor | 40290 | | 40290 | 181.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | 94fd75ad2c76ac80ac1d38362c45309e |
| 99896826963860360 | 11b070a1-91b9-11ed-aaf8-00155dfe333b | 0c57d35c-d61a-11eb-983c-48dc2d08332b | 40299 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0082.pos | Cor | 40299 | | 40299 | 181.199997 | 96.551598 | 65.219688 | 1673443469 | CMObject | 4edff777fa99805778f073e3ac388661 |
| 99896826963860407 | 120fed86-91b9-11ed-aaf8-00155dfe333b | 0c57d35f-d61a-11eb-983c-48dc2d08332b | 40360 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0085.pos | Cor | 40360 | | 40360 | 181.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | 4bb59448954862afdebef5a549ffa3e9 |
| 99896826963860431 | 123be95f-91b9-11ed-aaf8-00155dfe333b | 0c57d361-d61a-11eb-983c-48dc2d08332b | 40370 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0087.pos | Cor | 40370 | | 40370 | 211.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | 7d11cc141e47ccc27378df8a24274920 |
| 99896826963860466 | 127be9d6-91b9-11ed-aaf8-00155dfe333b | 0c57d364-d61a-11eb-983c-48dc2d08332b | 40380 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0090.pos | Cor | 40380 | | 40380 | 241.199997 | 86.551598 | 65.219688 | 1673443469 | CMObject | bab30cfb6e654ceed469f4ab83e84502 |
| 99896826963860479 | 1290b247-91b9-11ed-aaf8-00155dfe333b | 0c57d365-d61a-11eb-983c-48dc2d08332b | 40389 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0091.pos | Cor | 40389 | | 40389 | 241.199997 | 96.551598 | 65.219688 | 1673443469 | CMObject | a6ea261446abab6bc3ff9b15de7f77c6 |
| 99896826963860579 | 1340367b-91b9-11ed-aaf8-00155dfe333b | 0c57d36e-d61a-11eb-983c-48dc2d08332b | 40745 Conseta Trapezelement 45 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0100.pos | Cor | 40745 | | 40745 | 152.901627 | 123.690643 | 65.219688 | 1673443469 | CMObject | 8022828f55c3cf64ef51702f55b0b17d |
| 99896826963860590 | 1353a813-91b9-11ed-aaf8-00155dfe333b | 0c57d36f-d61a-11eb-983c-48dc2d08332b | 40774 Conseta Trapezelement 90 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0101.pos | Cor | 40774 | | 40774 | 138.000000 | 138.000000 | 65.219688 | 1673443469 | CMObject | 8e3c9fbfe3fdd0dd64d9a1cbdc05136d |
| 99896826963860601 | 1368d599-91b9-11ed-aaf8-00155dfe333b | 0c57d370-d61a-11eb-983c-48dc2d08332b | 40790 Conseta Trapezelement 90 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0102.pos | Cor | 40790 | | 40790 | 176.600006 | 176.600006 | 65.219688 | 1673443469 | CMObject | a1b9d3a0cb5b689c5df2f6c7a4e5aa34 |
| 99896826963862553 | 23888319-91b9-11ed-aaf8-00155dfe333b | 1857d89c-d61a-11eb-983c-48dc2d08332b | 60210 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0295.pos | Cor | 60210 | | 60210 | 211.200043 | 86.551575 | 77.219688 | 1673443469 | CMObject | 8c3e6e5ede057995cd456b076a0a5e69 |
| 99896826963862567 | 239c6d72-91b9-11ed-aaf8-00155dfe333b | 1857d89d-d61a-11eb-983c-48dc2d08332b | 60219 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0296.pos | Cor | 60219 | | 60219 | 211.199997 | 96.551514 | 77.219688 | 1673443469 | CMObject | 4043aa7a18c01d570264286a7226e730 |
| 99896826963862575 | 23ae5811-91b9-11ed-aaf8-00155dfe333b | 1857d89e-d61a-11eb-983c-48dc2d08332b | 60251 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0297.pos | Cor | 60251 | | 60251 | 211.199997 | 106.551361 | 77.219688 | 1673443469 | CMObject | 9f5ab2e184ca3a8979d46f9a5c961764 |
| 99896826963862606 | 23e8c810-91b9-11ed-aaf8-00155dfe333b | 1e58d848-d61a-11eb-983c-48dc2d08332b | 60260 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0300.pos | Cor | 60260 | | 60260 | 121.199997 | 86.551575 | 77.219688 | 1673443469 | CMObject | 3f461d621401f4231f669497d9ab1b8c |
| 99896826963862614 | 23fcd893-91b9-11ed-aaf8-00155dfe333b | 1e58d849-d61a-11eb-983c-48dc2d08332b | 60270 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0301.pos | Cor | 60270 | | 60270 | 141.200012 | 86.551575 | 77.219688 | 1673443469 | CMObject | 4d42c75e26c78244478e298deb625393 |
| 99896826963862633 | 2424548f-91b9-11ed-aaf8-00155dfe333b | 1e58d84b-d61a-11eb-983c-48dc2d08332b | 60280 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0303.pos | Cor | 60280 | | 60280 | 161.199997 | 86.551575 | 77.219688 | 1673443469 | CMObject | 59a719b86acb454f9c29f59c619395e9 |
| 99896826963862645 | 243ae755-91b9-11ed-aaf8-00155dfe333b | 1e58d84c-d61a-11eb-983c-48dc2d08332b | 60289 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0304.pos | Cor | 60289 | | 60289 | 161.199997 | 96.551514 | 77.219688 | 1673443469 | CMObject | 767bddb1b50c96a7377d0d453dbe104c |
| 99896826963862653 | 244ca9b1-91b9-11ed-aaf8-00155dfe333b | 1e58d84d-d61a-11eb-983c-48dc2d08332b | 60290 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0305.pos | Cor | 60290 | | 60290 | 181.199936 | 86.551575 | 77.219688 | 1673443469 | CMObject | c3700c008c4702e496ab2b082e0d8e5a |
| 99896826963862546 | 2378d94d-91b9-11ed-9ec5-00155dfe3423 | 1e58d84e-d61a-11eb-983c-48dc2d08332b | 60291 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0306.pos | Cor | 60291 | | 60291 | 181.199997 | 106.551361 | 77.219688 | 1673443469 | CMObject | d356ba581b41c9d8e61decd2d11bf6d1 |
| 99896826963862566 | 239c55fb-91b9-11ed-9ec5-00155dfe3423 | 1e58d850-d61a-11eb-983c-48dc2d08332b | 60299 Conseta Korpus 2 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0308.pos | Cor | 60299 | | 60299 | 181.200027 | 96.551514 | 77.219688 | 1673443469 | CMObject | 982b0858f8455c5d4237049e00bd2afd |
| 99896826963862719 | 24dc026f-91b9-11ed-aaf8-00155dfe333b | 1e58d853-d61a-11eb-983c-48dc2d08332b | 60360 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0311.pos | Cor | 60360 | | 60360 | 181.199997 | 86.551575 | 77.219688 | 1673443469 | CMObject | 66e4968aaffb65e764e0db668176fa4e |
| 99896826963862731 | 24f2bdb3-91b9-11ed-aaf8-00155dfe333b | 1e58d854-d61a-11eb-983c-48dc2d08332b | 60370 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0312.pos | Cor | 60370 | | 60370 | 211.199997 | 86.551575 | 77.219688 | 1673443469 | CMObject | 9abac66b0d2b30df3a8e740363ba44ad |
| 99896826963862751 | 251a2ed7-91b9-11ed-aaf8-00155dfe333b | 1e58d856-d61a-11eb-983c-48dc2d08332b | 60380 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0314.pos | Cor | 60380 | | 60380 | 241.200012 | 86.551575 | 77.219688 | 1673443469 | CMObject | dc533ad6a1b6678b9d1eb75dcd75cc6e |
| 99896826963862762 | 252f36d9-91b9-11ed-aaf8-00155dfe333b | 1e58d857-d61a-11eb-983c-48dc2d08332b | 60389 Conseta Korpus 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0315.pos | Cor | 60389 | | 60389 | 241.199997 | 96.551514 | 77.219688 | 1673443469 | CMObject | 6886c3e4b91028a91ae5dfc8fef64a9d |
| 99896826963862835 | 25c3cdab-91b9-11ed-aaf8-00155dfe333b | 1e58d85e-d61a-11eb-983c-48dc2d08332b | 60745 Conseta Trapezelement 45 1_Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0322.pos | Cor | 60745 | | 60745 | 152.901627 | 123.690704 | 77.219688 | 1673443469 | CMObject | 7088cb4eb296b673ab8239b73f19bbc5 |
| 99896826963862842 | 25d4d9f6-91b9-11ed-aaf8-00155dfe333b | 1e58d85f-d61a-11eb-983c-48dc2d08332b | 60774 Conseta Trapezelement 90 1 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0323.pos | Cor | 60774 | | 60774 | 138.000000 | 138.000107 | 77.219688 | 1673443469 | CMObject | 591115c080afc2edd6874c3148aa5c78 |
| 99896826963862850 | 25e8e4ad-91b9-11ed-aaf8-00155dfe333b | 1e58d860-d61a-11eb-983c-48dc2d08332b | 60790 Conseta Trapezelement 90 3 Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/COR/Conseta/0324.pos | Cor | 60790 | | 60790 | 176.600006 | 176.599976 | 77.219688 | 1673443469 | CMObject | c1a179f0157bb67cf84fac51d16a09fd |
| 99896826963876857 | 934eead1-91b9-11ed-aaf8-00155dfe333b | 587ba930-d61d-11eb-983c-48dc2d08332b | Anreihelement 2,5, Kissen links | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/WERTHER die Möbelmanufaktur/Wave 399/0000.pos | WERTHER | 399 | | 399 | 193.425812 | 104.999268 | 83.819046 | 1673443469 | CMObject | 437867de41e4768306258c39a0582e46 |
| 99896826963876876 | 9371f36d-91b9-11ed-aaf8-00155dfe333b | 587ba931-d61d-11eb-983c-48dc2d08332b | Anreihelement 2,5, Kissen rechts | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/WERTHER die Möbelmanufaktur/Wave 399/0001.pos | WERTHER | 399 | | 399 | 193.425812 | 104.999268 | 83.819046 | 1673443469 | CMObject | 50ceb3f2f105619b43ed0bccc85841db |
| 99896826963876900 | 93992f6e-91b9-11ed-aaf8-00155dfe333b | 587ba932-d61d-11eb-983c-48dc2d08332b | Anreihelement 3, Kissen links | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/WERTHER die Möbelmanufaktur/Wave 399/0002.pos | WERTHER | 399 | | 399 | 223.545074 | 104.548386 | 83.819061 | 1673443469 | CMObject | 4259b06a4d49290cc0e0136a40b9cc94 |
| 99896826963876928 | 93c479be-91b9-11ed-aaf8-00155dfe333b | 587ba933-d61d-11eb-983c-48dc2d08332b | Anreihelement 3, Kissen rechts | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/WERTHER die Möbelmanufaktur/Wave 399/0003.pos | WERTHER | 399 | | 399 | 223.545074 | 104.548386 | 83.819061 | 1673443469 | CMObject | 326993aba1175f44098ce1beec11c972 |
| 99896826963874151 | 82231563-91b9-11ed-aaf8-00155dfe333b | 0ca6fb75-d61d-11eb-983c-48dc2d08332b | Bank 2,5-Sitzig mit Reverse-Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/WERTHER die Möbelmanufaktur/Fyn 497/0001.pos | WERTHER | 497 | | 497 | 165.175446 | 91.319870 | 109.806976 | 1673443469 | CMObject | 0133a25540dd8b0067e0be00b3b1d3ab |
| 99896826963874187 | 825e4478-91b9-11ed-aaf8-00155dfe333b | 0ca6fb77-d61d-11eb-983c-48dc2d08332b | Bank 3-Sitzig mit Reverse-Kissen | af9ec | Interior + Design/Wohnen/_Markenhersteller Kataloge/Möbel/WERTHER die Möbelmanufaktur/Fyn 497/0003.pos | WERTHER | 497 | | 497 | 194.871613 | 91.319870 | 109.831184 | 1673443469 | CMObject | 1dc9d1daaa16688b0eef1b8a105b7467 |
| 99896826963876970 | 9416275c-91b7-11ed-aaf8-00155dfe333b | 25248f6f-de86-11eb-983c-48dc2d08332b | Burg Sofa + Kissen | af9ec | Interior + Design/Wohnen/Polstermöbel/Polstermöbel/Serie 82/0002.pos | | | | | 220.000000 | 98.851151 | 82.438942 | 1673443469 | CMObject | 0eda42b28e4c1ca3e62c8be4831379a8 |
| 99896826963888050 | e1e6abec-91b6-11ed-aaf8-00155dfe333b | 7ba394a1-d614-11eb-983c-48dc2d08332b | Kissen | af9ec | Interior + Design/Schlafen/Bettauflagen/0004.pos | | | | | 80.000000 | 80.000000 | 21.302393 | 1673443469 | CMStretchObject | 536e69ebb5872c1b974665d199acccb4 |
| 99896826963882032 | b6f0b0fc-91b8-11ed-aaf8-00155dfe333b | ea7d4780-df07-11eb-983c-48dc2d08332b | Kissen 1 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0010.pos | | | | | 58.968563 | 29.742758 | 31.224318 | 1673443469 | CMObject | 930fa011f076469c296a8faad71849bf |
| 99896826963882044 | b700be67-91b8-11ed-aaf8-00155dfe333b | ea7d4781-df07-11eb-983c-48dc2d08332b | Kissen 2 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0011.pos | | | | | 35.495621 | 15.352842 | 30.788454 | 1673443469 | CMObject | bab06505d639f6f27e2be4d21788cab1 |
| 99896826963882053 | b711d4fd-91b8-11ed-aaf8-00155dfe333b | ea7d4782-df07-11eb-983c-48dc2d08332b | Kissen 3 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0012.pos | | | | | 40.266674 | 17.123030 | 39.814857 | 1673443469 | CMObject | 04295293c39df57ba1a6461e5adb69b1 |
| 99896826963882067 | b722b327-91b8-11ed-aaf8-00155dfe333b | f1c77e99-df07-11eb-983c-48dc2d08332b | Kissen 4 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0013.pos | | | | | 43.383354 | 24.433495 | 26.281492 | 1673443469 | CMObject | 2d3c3eae42b5995c0ef2358ff6dbd802 |
| 99896826963882096 | b757c679-91b8-11ed-aaf8-00155dfe333b | f1c77e9a-df07-11eb-983c-48dc2d08332b | Kissen 5 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0014.pos | | | | | 59.308872 | 29.363337 | 35.546139 | 1673443469 | CMObject | 3112d35ce7f31bde4d4003ac8b67fb0e |
| 99896826963882112 | b770fbd4-91b8-11ed-aaf8-00155dfe333b | f1c77e9b-df07-11eb-983c-48dc2d08332b | Kissen 6 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0015.pos | | | | | 47.395554 | 21.269796 | 26.999229 | 1673443469 | CMObject | 1f2c165962dec5bbab008d751d43cfa6 |
| 99896826963882139 | b7a38932-91b8-11ed-aaf8-00155dfe333b | f7bdad78-df07-11eb-983c-48dc2d08332b | Kissen 7 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0016.pos | | | | | 77.660004 | 24.567642 | 78.807945 | 1673443469 | CMStretchObject | 2e24c4a9764a23689c28095f58277dfb |
| 99896826963882147 | b7b781b3-91b8-11ed-aaf8-00155dfe333b | f7bdad79-df07-11eb-983c-48dc2d08332b | Kissen 8 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0017.pos | | | | | 56.674500 | 29.374157 | 40.688763 | 1673443469 | CMStretchObject | f9ad5898f0446c2c1189ca7ba435da47 |
| 99896826963882157 | b7c838ba-91b8-11ed-aaf8-00155dfe333b | f7bdad7a-df07-11eb-983c-48dc2d08332b | Kissen 9 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0018.pos | | | | | 46.200001 | 45.953129 | 20.794739 | 1673443469 | CMObject | d5a1b15669c5987e0ae71a66d995fbc1 |
| 99896826963882178 | b7ec6445-91b8-11ed-aaf8-00155dfe333b | f7bdad7b-df07-11eb-983c-48dc2d08332b | Kissen 10 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0019.pos | | | | | 73.676849 | 47.584816 | 20.000000 | 1673443469 | CMObject | 0c4e675488bf1c0d364f0f7564e45230 |
| 99896826963882189 | b803a4e9-91b8-11ed-aaf8-00155dfe333b | ffe95cb6-df07-11eb-983c-48dc2d08332b | Kissen 11 | af9ec | Interior + Design/Wohnen/Zubehör/Kissen/0020.pos | | | | | 70.000000 | 51.372643 | 22.000000 | 1673443469 | CMObject | b6294a2fdc4e9fef8554366b58a1eaae |
+-------------------+--------------------------------------+--------------------------------------+-----------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+--------------+---------------+----------+----------+------------+------------+------------+------------+-----------------+----------------------------------+
Thanks. Please also run
desc objects_de
Alright, the response of
desc objects_de
is
+---------------+--------+------------+
| Field | Type | Properties |
+---------------+--------+------------+
| id | bigint | |
| name | text | indexed |
| maincatalog | text | indexed |
| itempath | text | indexed |
| manufacturer | text | indexed |
| articlenumber | text | indexed |
| expltext | text | indexed |
| decltext | text | indexed |
| itemid | string | |
| previewid | string | |
| name | string | |
| maincatalog | string | |
| itempath | string | |
| manufacturer | string | |
| articlenumber | string | |
| expltext | string | |
| decltext | string | |
| sizex | float | |
| sizey | float | |
| sizez | float | |
| creation | uint | |
| classname | string | |
| contenthash | string | |
+---------------+--------+------------+
I can’t reproduce your issue with the following mysql script:
mysql> drop table if exists objects_de; create table objects_de(name text indexed attribute , maincatalog text indexed attribute, itempath text indexed attribute , manufacturer text indexed attribute , articlenumber text indexed attribute, expltext text indexed attribute , decltext text indexed attribute , itemid string , previewid string , sizex float , sizey float , sizez float , creation uint , classname string , contenthash string) regexp_filter='ß => ss' regexp_filter='ü => ue' regexp_filter='ä => ae' regexp_filter='ö => oe' regexp_filter='Ü => ue' regexp_filter = 'Ä => ae' regexp_filter = 'Ö => oe' morphology='lemmatize_de' exceptions='/tmp/exceptions' wordforms='/tmp/wordforms' index_exact_words='1'; insert into objects_de(name, maincatalog) values('Bank 4 + Polster','af9ec'), ('002_Sofa mit Kissen', '63e8e'); SELECT * FROM objects_de WHERE MATCH('"Polster"') AND REGEX(maincatalog, '5b901Dev|AndiDev|2a10859dffc5916631b2e27266f161ef|7d81a|fb3483aa57d7fbdcae0828472b683531|2304a|24992eb534cffcfe6bafdc57f6c1a49d|7dda5|6f404e8a0bb468dba3098ffa60f5acba|143799dbd2ddcbd8ae0f1934000bf248|45199|5146b|a36fa45bfbcb3a3eb4ea74bd60452977|36a7d59c2a26c3482e74d0d62d326e7f|babcc|fa1be21c4f80fb2f8b229dca2816d5f6|ac9f6|fc06eba748ec04e24dd5973430ad17a7|eb8d891367e87b9927ab7ec14a8af050|fbf7a|361d0|e3af4aac2d665ac76f8a3b210d91162d|644cc|83431128947fa530d8e172235240540d|3987d|14e61|675474351bb08ff01ba52802d4548173|71e3f|31202f76b785bc46b9daa6a5902e05a4|5533c|e9519|1932020bd014bc45d03c76b8c73ff025|af9ec|644ccit|644ccnl|644ccpl|644ccsk|83431128947fa530d8e17223524054fr|966a47d54e0b254dd9a9efd2fb69dec8|6f814|b15f5|85e709d8ccc78dc7859deda0cdd63d4d|aaaaa|aaaab|77611|ceda7cf57ecc60ea3d817da054820829|40872|e4271a55fd51b22ef2ac4df07c439f47|52b134cc0e4830328a572d871548d625|7bcbd|717ca8e1745ff6cfcc59fdd2346280df|9ddbf|a0e86|5b90f|5b90i|5b90nl|5b90pl|5b90sk|bbbfr|bbbit|bbbsk|5b911Dev|1277c358c1138b876fcec5cb48fa94a3|63e8e|cbaf460e7f3bc6fbe7f7ef849b34f4aa|e67f0|166f7|22679398192af1faea12c2c63491227b|6fc8ca7f089b356010eecbfd554be34e|d97e3|1984480425c4c11728f67128a9c74591|5b901|7d3cbb54f4f73cd9d83012fcb6bc0a6f|f3f8d|||1c38c6a4a160cc375db174aed1c60806|a0193|5fe4c|896c1|5ef3beca513d27fdb7f721d6384579d9|bd02a|testid|babcca|d3bfb|e29cd6f751e1ad79c42d976ab3ba41ff|4f334e9098b9ea62d7a59916ebd70f75|47765720b802402b7ee0010f9faa8d6d|d8cece5a11627b4b4ab1a4e2976e6578|bb5bc53cbb6a1e8d23b3aa262957dc7b|b3c7996ad575097c5abb426313406fa1|ec415|cb2a3|79951f669f6ffc2fc70e0005dfd06bab|1f83375cf673ed76c59007761e0a13ac|cf6f8|39e61|68de5bcb468538e0811fdd9d22230f4f') ORDER BY Name ASC LIMIT 0 , 60 OPTION field_weights=(name=10, maincatalog=1, itempath=3, manufacturer=9, articlenumber=9, classname=1, expltext=1, decltext=1), max_matches = 60\G show warnings;
--------------
drop table if exists objects_de
--------------
Query OK, 0 rows affected (0.00 sec)
--------------
create table objects_de(name text indexed attribute , maincatalog text indexed attribute, itempath text indexed attribute , manufacturer text indexed attribute , articlenumber text indexed attribute, expltext text indexed attribute , decltext text indexed attribute , itemid string , previewid string , sizex float , sizey float , sizez float , creation uint , classname string , contenthash string) regexp_filter='ß => ss' regexp_filter='ü => ue' regexp_filter='ä => ae' regexp_filter='ö => oe' regexp_filter='Ü => ue' regexp_filter = 'Ä => ae' regexp_filter = 'Ö => oe' morphology='lemmatize_de' exceptions='/tmp/exceptions' wordforms='/tmp/wordforms' index_exact_words='1'
--------------
Query OK, 0 rows affected (0.01 sec)
--------------
insert into objects_de(name, maincatalog) values('Bank 4 + Polster','af9ec'), ('002_Sofa mit Kissen', '63e8e')
--------------
Query OK, 2 rows affected (0.00 sec)
--------------
SELECT * FROM objects_de WHERE MATCH('"Polster"') AND REGEX(maincatalog, '5b901Dev|AndiDev|2a10859dffc5916631b2e27266f161ef|7d81a|fb3483aa57d7fbdcae0828472b683531|2304a|24992eb534cffcfe6bafdc57f6c1a49d|7dda5|6f404e8a0bb468dba3098ffa60f5acba|143799dbd2ddcbd8ae0f1934000bf248|45199|5146b|a36fa45bfbcb3a3eb4ea74bd60452977|36a7d59c2a26c3482e74d0d62d326e7f|babcc|fa1be21c4f80fb2f8b229dca2816d5f6|ac9f6|fc06eba748ec04e24dd5973430ad17a7|eb8d891367e87b9927ab7ec14a8af050|fbf7a|361d0|e3af4aac2d665ac76f8a3b210d91162d|644cc|83431128947fa530d8e172235240540d|3987d|14e61|675474351bb08ff01ba52802d4548173|71e3f|31202f76b785bc46b9daa6a5902e05a4|5533c|e9519|1932020bd014bc45d03c76b8c73ff025|af9ec|644ccit|644ccnl|644ccpl|644ccsk|83431128947fa530d8e17223524054fr|966a47d54e0b254dd9a9efd2fb69dec8|6f814|b15f5|85e709d8ccc78dc7859deda0cdd63d4d|aaaaa|aaaab|77611|ceda7cf57ecc60ea3d817da054820829|40872|e4271a55fd51b22ef2ac4df07c439f47|52b134cc0e4830328a572d871548d625|7bcbd|717ca8e1745ff6cfcc59fdd2346280df|9ddbf|a0e86|5b90f|5b90i|5b90nl|5b90pl|5b90sk|bbbfr|bbbit|bbbsk|5b911Dev|1277c358c1138b876fcec5cb48fa94a3|63e8e|cbaf460e7f3bc6fbe7f7ef849b34f4aa|e67f0|166f7|22679398192af1faea12c2c63491227b|6fc8ca7f089b356010eecbfd554be34e|d97e3|1984480425c4c11728f67128a9c74591|5b901|7d3cbb54f4f73cd9d83012fcb6bc0a6f|f3f8d|||1c38c6a4a160cc375db174aed1c60806|a0193|5fe4c|896c1|5ef3beca513d27fdb7f721d6384579d9|bd02a|testid|babcca|d3bfb|e29cd6f751e1ad79c42d976ab3ba41ff|4f334e9098b9ea62d7a59916ebd70f75|47765720b802402b7ee0010f9faa8d6d|d8cece5a11627b4b4ab1a4e2976e6578|bb5bc53cbb6a1e8d23b3aa262957dc7b|b3c7996ad575097c5abb426313406fa1|ec415|cb2a3|79951f669f6ffc2fc70e0005dfd06bab|1f83375cf673ed76c59007761e0a13ac|cf6f8|39e61|68de5bcb468538e0811fdd9d22230f4f') ORDER BY Name ASC LIMIT 0 , 60 OPTION field_weights=(name=10, maincatalog=1, itempath=3, manufacturer=9, articlenumber=9, classname=1, expltext=1, decltext=1), max_matches = 60
--------------
*************************** 1. row ***************************
id: 1515200002673082374
creation: 0
sizex: 0.000000
sizey: 0.000000
sizez: 0.000000
name: 002_Sofa mit Kissen
maincatalog: 63e8e
itempath:
manufacturer:
articlenumber:
expltext:
decltext:
itemid:
previewid:
classname:
contenthash:
*************************** 2. row ***************************
id: 1515200002673082373
creation: 0
sizex: 0.000000
sizey: 0.000000
sizez: 0.000000
name: Bank 4 + Polster
maincatalog: af9ec
itempath:
manufacturer:
articlenumber:
expltext:
decltext:
itemid:
previewid:
classname:
contenthash:
2 rows in set, 1 warning (0.00 sec)
--------------
show warnings
--------------
+---------+------+-----------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+-----------------------------------------------------------------------------------+
| warning | 1000 | index objects_de: Fields specified in field_weights option not found: [classname] |
+---------+------+-----------------------------------------------------------------------------------+
1 row in set (0.00 sec)
The external files are:
➜ ~ cat /tmp/exceptions
Polster => Kissen
➜ ~ cat /tmp/wordforms
Polster > Kissen
Please try to modify it making it closer to your situation until it starts reproducing and provide what you get.
Hey, Sergey thank you for your help. To see that it works for you was a good hint.
I found the Problem. Our IT-Management removed the permission for rotating the index. So my exceptions never get into manticore.
Now with granted Permission, everything is working as expected.
большое спасибо, ты мне очень помог.